Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Compare 2 DB's

Author  Topic 

a4apple
Starting Member

2 Posts

Posted - 2010-11-10 : 22:44:32
Hello All. I need a help scripting this.

Say I have three databases.

Test 1, Test 2, Test 3.

Everything have same columns and tables but differ somewhere in constraint names.

I have to generate a script that compare two databases and gives me the list of constraints that are different so that I can change them.

so that it makes either Test 1 or Test 2 ideal. and so that I can check that with the main database and then update any changes.

Please help me with this.. Thanks

a4apple
Starting Member

2 Posts

Posted - 2010-11-10 : 22:45:28
Actually, I dont want to use RED GATE.. I Need pure scripting...
Go to Top of Page
   

- Advertisement -