June 29, 2010 at 8:01 am
We have transactional replication set up SQL2000 to SQL2000. We are soon to upgrade the publisher to SQL server 2005 x64 whilst retaining our subscribers on SQL server 2000. Is any one aware of any issues or gotchas I should be aware of? Thanks.
July 2, 2010 at 8:03 am
You shouldn't see any major issues as long as your publications are all transactional or snapshots and the subscriptions are push. I worked with a SQL 2000 Publisher and 2005 subscribers for a couple of years without difficulty - and your case should be easier. See Using Multiple Versions of SQL Server in a Replication Topology for some further information on potential issues.
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
July 5, 2010 at 8:26 am
Hi,
Be carefull if you plan to use SSMS to run sp_addarticle and you need to have your NC indexes on the subscribers, because it will by default skip the NC indexes DDL in the snapshot. You'll have to adjust the @schema_option manually to ship both clustered and NC indexes for each article of your publication. I've written an article to describe this issue, but it is in french and I haven't translated already. In case you read french it is there[/url].
HTH, David B.
David B.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply