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.
| Author |
Topic |
|
Ragabash
Starting Member
6 Posts |
 Posted - 2008-01-17 : 09:28:07
|
| I want to synchronize two databases. Is there a query or a tool to synchronize them? |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-01-18 : 04:26:28
|
| We use Red Gate SQL Compare, although there are others on the market. Usually, they offer you a free downloadJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
Ragabash
Starting Member
6 Posts |
Posted - 2008-01-18 : 07:09:42
|
| The program you recommend me sychronize only the tables,functions and stored procedures, but I must also save the data in the tables of the old database. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-20 : 20:53:06
|
| Use ssis or dts package to copy data. |
|
|
|
|
|
|
Sync database