Replication between SQL2000 and SQL2008

Question

Replication between SQL2000 and SQL2008

james.mcallester

SSC Journeyman

Points: 90
More actions
September 12, 2010 at 8:58 pm

#97333

I have a client that is in the process of migrating systems from SQL2000 to SQL2008. To facilitate a "stepped" approach to this, users will be migrated in groups and monitored to ensure each group "settles in".
However, the data on each SQL Server must be maintained in tandem. That is, changes on SQL2000 must be replicated on the SQL2008 server and vice versa in real time.
My experience is limited in the area of replication in general, so if anyone has experience and can assist it would be most appreciated.
(Note this is also being posted on the SQL2008 general forum).
Thanks, James

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 1

Did you get an update in 2008 forums? If not, maybe you should look up Merge replication. There is also updatable transactional replication. Two way. That too might work. I do not see any other method you could get this done.

-Roy

Steve Jones - SSC Editor SSC Guru Points: 736479 More actions · Answer 2

Merge or Bidirectional transactional will help. However you might end up spending a lot of time trying to resolve conflicts and issues. Are you talking about moving some tables and/or data from a database at a time? Or is this moving some servers or databases from a server at a time?

steveb. SSC-Forever Points: 46733 More actions · Answer 3

it worth noting that peer-to-peer trans replication is only available on Enterprise edition.

How large is this database that you are migrating?

while the stepped approach sounds good, you may find it brings up more problems that it solves esp. around data conflicts between the two servers.

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 4

Is peer to peer transactional replication available in SQL 2000?

-Roy

steveb. SSC-Forever Points: 46733 More actions · Answer 5

Roy Ernest (9/17/2010)
Is peer to peer transactional replication available in SQL 2000?

no it isn't

james.mcallester SSC Journeyman Points: 90 More actions · Answer 6

First of all ... thanks you everyone for your replies.

I think that maybe I didn't explain the problem properly since the answers seem to be about moving a database step-by-step from 2000 to 2008. (Maybe I'm misunderstanding the answers.)

What is being moved is the application user base in steps. So a group of users will move to the new server using 2008 and after some time a second set of users will move and so on.

During this process any change made on 2000 must be available to the 2008 users and vice-versa.

I hope this clarifies things and I apologise if I have misunderstood any already-supplied responses.

Thanks, Jame