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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Migrating replication from SQL Server 2000 to 2005

Author  Topic 

Sqlbuddy
Starting Member

27 Posts

Posted - 2009-05-29 : 00:22:43
Hi,

I have a SQL server 2000 instance on a server that acts as both publisher and distributor and another SQL server 2000 instance that acts as a subscriber to the above mentioned SQL server 2000 instance. Now I want to migrate both of these instances to separate SQL Server 2005 instances.

Could any one please tell me how to migrate these Replication settings onto the SQL Server 2005 instance so that the replication still works in the new SQL Server 2005 instance without any problems?

Should I setup the replication right from the scratch or is there any scripting method available?

Thank you,

Yours
SQL Buddy
   

- Advertisement -