June 23, 2011 at 6:39 am
Hi,We currently have in place a 2005 EN box that has been around for ever that management would like to get upgraded to 2008 EN. However one of the DB's on this box has Merge Replication. Is replication DB's migration is differ then normal migration, if it is differ can any one guide the procedure.
Thanks in advance
Srikanth
June 26, 2011 at 10:09 am
It's pretty different but not overly complicated
How do you plan on performing the upgrade?
June 26, 2011 at 10:24 pm
We are planning for side-by-side migration along with Sql server 2008 EN.
June 27, 2011 at 3:45 am
Are you going to backup/restore? Logship? Detach/Reattach?
In all methods, you will need a downtime slot to prevent any database updates.
You then need to:
1. script the drop replication scripts (subscribers/articles/publications/drop distributor).
2. script the create replication scripts (add distributor/mark database for publish/publication/articles/subscribers)
If no data changes are occurring (there should not be), you can edit the subscriptions "@sync_type='none'" and this will prevent the need to reinitialise.
Then perform the migration
1. run the drop scripts on the publisher
2. migrate db using your preferred method
3. run the create scripts on the new publisher
The key is preparation and testing. Should work fine though.
June 27, 2011 at 3:54 am
Hi, Thanks for the information, we are palnning for the Backup and restore method.
June 27, 2011 at 4:06 am
I'd recommend at least having 3 instances installed somewhere (like your desktop) so you can have a play and test this.
I've do it fairly regularly, but I always have a test run. 😀
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply