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 |
|
hey001us
Posting Yak Master
185 Posts |
 Posted - 2009-03-15 : 23:41:06
|
| We are changing SQL server 2000 (Server 1) to new SQL server 2005 (Server 1A). Let me know the below are correct. and what i need to care?Note: I have already tested with TestDB on Server1A for Test Replication. (to avoid security issue)Current Setup:Server 1 – publisher1 – SQL 2000Server 2 – Subscriber1 – SQL 2000Server 3 – Subscriber2 – SQL 2000Server 1 – publisher2 – SQL 2000Server 2 – Subscriber1 – SQL 2000Server 3 – Subscriber2 – SQL 2000New Setup:Server 1A – publisher1 – SQL 2005Server 2 – Subscriber1 – SQL 2000Server 3 – Subscriber2 – SQL 2000Server 1A – publisher2 – SQL 2005Server 2 – Subscriber1 – SQL 2000Server 3 – Subscriber2 – SQL 20001) Delete the two subscriptions at server1?2) Backup the databases3) Restore at Server1A4) Setup a publisher & subscriptions at Server 1AThankshey |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-03-16 : 11:32:43
|
| yep. Just script out the replication scripts prior to your step 1, and change server names.. If your subscribers need an entire copy of the publisher database you could just restore the backup on all servers - publisher and both subscribers.. and choose "subscriber already has data" option to void sync'ing.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
hey001us
Posting Yak Master
185 Posts |
Posted - 2009-03-16 : 18:03:45
|
| Thanks Dinakar.I have migrated successfully without any major issue, but I just redo all the setup instead of restoring publisher database, since I am not much expert on restoring publisher database.hey |
|
|
|
|
|
|
Replication - Changing New SQL Server