By: Armando Prato | Last Updated: 2012-10-08 | Comments (3) | Application Development
Visual Studio 2010 and SQL Server Tutorial
One of the more difficult jobs that database professionals have to endure is maintaining installation and upgrade scripts for their databases from release to release. Many methods and tools are used such as loose SQL scripts run via SQLCMD or even writing a homegrown system to handle the creating and upgrading of databases. The biggest headaches are making sure dependencies among objects are observed so an install or upgrade does not fail and also to create scripts to update a database from a previous schema version to the latest. These processes are usually manual and they can be labor intensive. Unfortunately, this also means that they can be prone to error.
Last Updated: 2012-10-08
About the author
View all my tips