November 2, 2006 at 8:29 am
...replicated environment to SQL Server 2K5. Where do I start?
Transactional Replication
Server1 replicated to Server2
Distribution DBs reside on Server2
Server2 is the one that will be upgraded to SQL 2K5
Any assistance or advice on this would be greatly appreciated!
Thanks, Ben:
November 2, 2006 at 10:51 am
Think I would start with BOL.
Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982
November 3, 2006 at 12:06 pm
Just to make sure that I understand correctly, the distribution database is on the same server as the subscriber, not the publisher?
Are you planning to do an upgrade in place or uninstall SQL 2000 and then install SQL 2005?
I agree with David that you should start with the SQL 2005 BOL. Specifically, look up "replication [SQL Server], backward compatibility". On the "Using Multiple Versions of SQL Server in a Replication Topology" page (linked off of the aforementioned page to look up), there is a section that you'll need to pay particular attention to about half way down the page. The section header is: Using a SQL Server 2005 Distributor with a Publisher Running SQL Server 2000
November 3, 2006 at 12:31 pm
Yes, the distribution DBs are on the same server as the subscriber. The subscriber server is the one that I will be upgrading to SQL Server 2K5. Would it be easier to do an "in place" or an uninstall/reinstall? I have done the "in place" before but all that it did was to create another named instance on the same server.
I will check out BOL and the web.
November 3, 2006 at 12:38 pm
Then you didn't do an in place upgrade. If you are upgrading the default instance, tell the setup program to make the install the default instance, and it will upgrade the current instance to SQL 2005. If upgrading a named instance, there is an "Advanced" button at the level where you tell it to make the install the default or a named isntance. This button will give you a list of the instances on the server and allow you to pick the one to upgrade.
I have done the installs 3 different ways, and I haven't experienced any real problems with any method. However, I did not have replication running at the time. Supposedly you can upgrade the replication databases, but I'm really leary of that.
If it was me, I would drop all replication, upgrade the server, and then install replication again from the ground up. I would completely uninstall the distribution database and recreate it after the upgrade.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply