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?