I am trying to determine the best way of automatically synchronising databases using SQL Server 7.0
We have three servers all using the same database - one is used for development work, a second is used for development and pre-production testing and the main machine is the production server.
Is there an easy (and safe) way to synchronise the development servers with the databse on the production machine?
I am aware that I can use backups and restore to the other machine, but I am looking for a simpler, automatic type method.
Thanks in advance
Waggers
We have three servers all using the same database - one is used for development work, a second is used for development and pre-production testing and the main machine is the production server.
Is there an easy (and safe) way to synchronise the development servers with the databse on the production machine?
I am aware that I can use backups and restore to the other machine, but I am looking for a simpler, automatic type method.
Thanks in advance
Waggers