x

Migrate Merge Replicated Database to MSSQL 2008

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.
more ▼

asked Jun 07, 2012 at 01:51 PM in Default

smiller1fb gravatar image

smiller1fb
0 2 2 2

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

I always believe that BOL and Technet are great resources for such kind of work. I said so because mostly, they have almost all kind of information you want and what steps you must take before starting the process. For instance, following are two of your interests

Considerations for Upgrading Replicated Databases

[Breaking Changes in SQL Server Replication][2]

[2]: http://technet.microsoft.com/en-us/library/ms143470(v=sql.105).aspx
more ▼

answered Jun 08, 2012 at 07:38 AM

Usman Butt gravatar image

Usman Butt
13.9k 6 8 14

(comments are locked)
10|1200 characters needed characters left
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.
more ▼

answered Jun 08, 2012 at 03:38 AM

ayesamson gravatar image

ayesamson
10

(comments are locked)
10|1200 characters needed characters left

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.
more ▼

answered Jun 08, 2012 at 12:59 PM

smiller1fb gravatar image

smiller1fb
0 2 2 2

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1853
x306
x62
x48
x23

asked: Jun 07, 2012 at 01:51 PM

Seen: 1769 times

Last Updated: Jun 08, 2012 at 12:59 PM