We use seperate database instances for development, qa, ua, and production with multiple databases in each environment. So, I'm looking for a way to automate the database changes to these different environments.
After creating a database project with change scripts and database references, I can't seem to find a way to automate these changes out to a server/environment.
We're currently using SQL 2000 + 2005, Visual Studio 2003 + 2005, and Visual Source Safe 6 (researching Team Foundation System).
Any ideas/thoughts?
If I am reading your message correctly you already have a change script that you want to apply to your target systems and do this in an automated fashion? One possible solution is to deploy the script using SQLCMD. If I did not read this correctly, and you're looking for the capability to generate a change script, then you would need to shop for a 3rf party tool as we do not have this capability.
