DB diff & update tool?

[zippy]

How about generating scripts from both databases and then comparing them?

I think he wants a tool that will generate the scripts to, for example, add columns to tables which are missing from one db.

 

[xrapidx]

If you're using Microsoft, SQL Data Tools.

 

[stoymigo]

If you're using Microsoft, SQL Data Tools.

Will check, thx

 

[poffle]

Amazing prorgram i use:

http://www.xsql.com/products/sql_server_schema_compare/

I just used the Trail version and worked fine
xSQL Data Compare will work as a fully licensed professional edition for the first 2 weeks. After the trial period is over then it will revert to the Lite edition which functions as described below.

 

[guest2013-1]

Anyone still on SQL 2000 should be shot IMO