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 |
|
ritesh.mehrotra
Starting Member
1 Post |
 Posted - 2007-04-12 : 21:31:17
|
| I need to move my database servers from one location to another. The issue is that I have over 200 databases to move and my clients can't afford a downtime. The collective volume of all the databases is over 2.5 TB and growing. I am thinking to copy these databases in batches over the WAN to the new location and replicate them using Transactional replication till I have all the databases moved and synchronized. Will it be wise enough to use replication for synchronizing 200 databases or is there a better approach which I can use to move these databases with minimum downtime and compromise on performance of applications.Note: Migration is from SQL Server 2000 to SQL Server 2005.Thanks in advance.Ritesh |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-13 : 10:30:55
|
| Another option: log shipping. |
 |
|
|
|
|
|
Data Migration using Transactional Replication