We're expanding our operation a bit and setting up some better development environments. But now I've got a production SQL Server install, a development server, a demo instance, and a training instance. Plus a partner company that runs the same database, but separate, as well.
What is something that I can use to keep everything in sync? I don't want changes to development to immediately propagate to everything else, but once it's been tested, it would be great if I could somehow automate applying the update scripts to all of the other servers. Anything out there? Thanks for any ideas!
What is something that I can use to keep everything in sync? I don't want changes to development to immediately propagate to everything else, but once it's been tested, it would be great if I could somehow automate applying the update scripts to all of the other servers. Anything out there? Thanks for any ideas!
