SQL Server Performance

Migrating Replication from SQL Server 2000 to SQL Server 2005

Discussion in 'SQL Server 2005 General DBA Questions' started by SQLBuddy123, May 28, 2009.

  1. SQLBuddy123 New Member

    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
  2. moh_hassan20 New Member

    check
    http://msdn.microsoft.com/en-us/library/ms146934(SQL.90).aspx
    http://msdn.microsoft.com/en-us/library/ms143470(SQL.90).aspx
  3. SQLBuddy123 New Member

    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.

Share This Page