Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 2 down vote favorite

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?

share|improve this question

1 Answer

up vote 3 down vote accepted

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'

share|improve this answer
Excellent, just what i wanted to hear =) Thank you Andrew, i'm going to try it out asap. – Johan May 24 '11 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... – Andrew Bickerton May 25 '11 at 7:57

Your Answer

 
discard

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.