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)
 Synchronize databases

Author  Topic 

NamrataC
Starting Member

5 Posts

Posted - 2010-11-02 : 05:29:50
Hi All,
I need to compare and synchronize two databases, i.e., make changes in table structure, views, stored procedures and user-defined functions of destination database if it is different from source database.

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2010-11-02 : 05:34:09
You can use Database compare tools. Which is freely available.

Vaibhav T

To walk FAST walk ALONE
To walk FAR walk TOGETHER
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2010-11-02 : 06:54:49
I use RedGate Compare 8.



N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page
   

- Advertisement -