Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Handling Configuration Management for SQL 7.0

Author  Topic  oledave Starting Member 6 Posts Posted - 2001-02-23 : 16:06:14 We're a web development company and we usually have 4 databases (Alpha, Testing, Beta, Live) per project. I'm looking for the best and easiest way to handle moving changes to the database schema up to each new server when it's time to deploy. Obviously we could make all schema changes using scripts and then apply those scripts on deployment. But I'm looking for something better. I've been experimenting with using syncronization where we just syncronize the schema and not the data. I've been fiddling with this but haven't got it to work yet. Has anyone done this? Dave