MS SQL Server - Upgrading Replication objects from SS 2000 to 2005

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Upgrading Replication objects from SS 2000 to 2005

Ken

2006-03-15, 3:23 am

We are doing a preliminary requirements document for upgrading our SQL
Server 2000 Servers to 2005. We are an ASP and we have over 2000
databases. Over 100 of these databases we offer transactional
replication to our clients (subscribers).

1. When I run the SQL Server Installation for 2005 and upgrade the
existing 2000 instances (publication server and distributor server),
will all the publications be up and running without having to
reinitialize?

2. Is it possible to migrate a database, articles (i.e, replication
objects) from a SQL 2000 server to 2005 without having to
reinititalize?

The reason I'm asking is we have very huge tables.

Thanks,

KS

Sponsored Links