Saturday, February 25, 2012

Replication issues upgrade to SQL 2005.

Hi Everyone:

I am not sure if I should be posting this question in the setup forum. I apologise if this is the wrong forum. My question is simple and straightforward.

1). What are the things that I should consider while upgrading Replication from SQL 2000 to SQL 2005 Assuming

Case A : My SQL Server 2000 is the Publisher.

CASE B: My SQL Server 2000 is the Distributor

CASE C : My SQL Server 2000 is the Subscriber.

Any documents, whitepapers or KBs or related posts would be helpful. MS SMEs please share your thoughts.

Thanks

AK

You can start with reading SQL 2005 Books Online. Search for "replication upgrade". You should find topics "Upgrading Replicated Databases", as well as read upon what new features exist, and what features are deprecated. i.e. "Breaking Changes in SQL Server 2005 Replication" and "Behavior Changes in SQL 2005 Replication".

you can also access SQL 2005 at http://msdn2.microsoft.com.

No comments:

Post a Comment