4

I have a database server, SQL Server 2005, that's inside a private network. Now i need to make a database there available for a webserver, so i want to replicate this db to an external server, which is running SQL Server 2008. I want the internal server to be the Master and the external one the Slave. New data will be added a few times a day maybe, infrequently, and should be replicated smoothly without manually intervention.

Is this a possible scenario, or do i need to upgrade the SQL Server on the inside to the same version as the external one?

If it's possible, are there drawbacks in doing it in this way that makes the upgrade scenario more recommended anyway?

1 Answer 1

5

Short answer is yes that is possible and straight forward (I've just finished setting up transactional replication from SQL 2005 to SQL 2008 R2).

Note: in SQL Server replication the terms are 'Publisher' and 'Subscriber'

2
  • Excellent, just what i wanted to hear =) Thank you Andrew, i'm going to try it out asap.
    – Johan
    Commented May 24, 2011 at 8:55
  • @Johan good luck, if you have issues (ie: choosing type of replication and method of replication (push/pull)) please ask a new question... Commented May 25, 2011 at 7:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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