Issue: We have merge replicated databases on MS SQL 2000 SP4. I need to relocated these databases to new Windows Server 2008 R2 x64 systems running MS SQL 2008 R2 x64. The new systems will have a different name. How does a person relocate and upgrade merge replicated databases? Thanks.
I assume there's a front-end application has it been tested against 2008? You will need to setup replication on the new server so you can backup the databases on the 2000 instance and restore them on the 2008 instance. Setting up replication is quick and can be scripted.
Thank you for the responses. I want to add a little more information and see what people recommend. Merge replication is used to keep certain database tables syncronized between two locations. The "Not For Replication" option is used and the identity ranges are different between locations. If a would configure replication on new systems, I assume that I will have to import the data into the tables at the proper sites. Meaning that I would import the data where it originated from by the identity range. The tables would then replicate and merge together as they were before the migration. Is that correct? Would it be a bad choice to replace merge replication with the database mirroring? Again, merge replication is used to keep the main and disaster recovery site data synchronized. Occasionally, data is written to our DR site and replicated to the main location. Our DR site is an active office with a large data center. Thanks.