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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2007-11-22 : 07:24:42
|
| what's the best way to synchronize 2 databases(mssql 2005) on 2 different servers. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-22 : 07:30:30
|
| You have a few options, depending on your set-up and hardware:Replication - The easiest to set up, but there are a few pitfallsMirroring - Depends on your hardware and the use of the databasesLog Shipping - Depends on the use of the databases as one would be read-only. |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2007-11-22 : 07:35:58
|
| they definitely both have to be writable.what's the pitfalls of replication and how is this done? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-22 : 08:10:00
|
| It is by far the easiest to set up, you need to think about what type of replication you would want though. By the sounds of it you will want either merge, updateable transactional or peer-to-peer.To start with, both databases need to be in the same state. So if you have different data on both the databases, this may be a problem, but it can be overcome.I would probably look into merge replication. There is plenty of information on how to set this up on the web and in BOL. |
|
|
|
|
|
|
synchronizing databases