Hi, I have a SQLserver 2000 instance on a server that acts as both publisher and distributorand another SQL server 2000 instance that acts as a subscriber to the abovementioned SQL server 2000 instance. Now I want to migrate both of theseinstances to separate SQL Server 2005 instances. Could any oneplease tell me how to migrate these Replication settings onto the SQL Server2005 instance so that the replication still works in the new SQL Server 2005instance without any problems? Should I setup the replication right fromthe scratch or is there any scriptingmethod available? Thankyou, Yours SQL Buddy
check http://msdn.microsoft.com/en-us/library/ms146934(SQL.90).aspx http://msdn.microsoft.com/en-us/library/ms143470(SQL.90).aspx
Hi Hassan, Thank you very much for your help. I will go through those documents and if I have any doubts I will ask you for help. Best Regards, SQLBuddy.