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 |
|
missMac
Posting Yak Master
124 Posts |
 Posted - 2009-08-26 : 18:09:44
|
| Hello,whats the best way to synchronize the data of two instances.We have to migrate databases and during the process, we had some updates to one db, which belong to a sub directory iehttp://products.domain.com data was updatedwhile the main sitehttp://www.domain.com data was updatedand both were on seperate instances.Now we want to synchronize both into one db, whats the best and easiest waythanksMM |
|
|
missMac
Posting Yak Master
124 Posts |
Posted - 2009-09-04 : 05:24:38
|
| bump !!! |
 |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-04 : 10:54:21
|
| How many tables are affected?Would the same record be updated on both databases? If so, which one "wins" then?How much downtime (no updates) is allowed?You can use a 3rd party tool to generate the scripts (e.g. Redgate).Or compare the data and generate the script, using SQL. |
|
|
|
chriztoph
Posting Yak Master
184 Posts |
Posted - 2009-09-14 : 01:08:32
|
| use replication.. |
|
|
|
|
|
|
Synchronizing two instances