Are scripts available that do this?

[tvoss]

Compare 2 databases A and B and then modify B to match A while leaving Bs data as intact as possible:

for 4 areas:

1)Check a source table to see if a table exists in target database, if it isn't add it.
2)In each table check to see if the column/field exists, and if not add it.
3)Compare the column properties of the source against the installed version, and if there were changes, alter the destination.
4)Clear and refresh all the stored procedures

Or do most developers/dba's just write a new program to add new version features to B directly each time?

Thanks,

 

[fluteplr]

There are several commercial products available that will do this. I do not know of any free/shareware ones.

check out sqlcompare from Redgate software and
Changemanager from Embarcadero.

http://www.red-gate.com

http://www.embarcadero.com

 

[Glowworm27]

There is a Stored Proc that will compare databases. the article is at

http://www.sql-server-performance.com/vg_database_comparison_sp.asp

George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net?referedby=54275&cam=Tek-Tips