Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have a business partner that is still on SQL Server 2000, and we would like to replicate a couple databases to one of our SQL Server 2005 instances.

The business partner databases that we need to replicate from are only updated daily, so we could certainly use something like log shipping, if that is a possibility. Our databases that we replicate to will be read-only.

What options do we have in this heterogeneous environment?

share|improve this question
up vote 2 down vote accepted

I do replication between SQL2000 and SQL2005 all the time in our production environment, and it works fine. Snapshot replication would be appropriate if you only need to replicate the data once a day.

Log shipping from SQL2000 to SQL2005 would probably also work. (I doubt you could use log shipping from SQL2005 to SQL2000, though, since SQL2000 can't read SQL2005 backups.)

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.