Continuous integration of database development-SQL Server deployment and upgrade Tool

articles directory
continuous integration of database development-SQL Server deployment and upgrade tool
continuous integration of database development-SQL Server database structure comparison
continuous Database Development integration-methods and processes
continuous integration of database development-liquibase introduction and application
continuous integration of databases-cruisecontrol. net project configuration

During this period, we have standardized the database development process of our group and searched for and compiled corresponding tools. We hope that the database development will be similarProgramDevelopment can be controlled and evolved in that way, and the system upgrade is expected not to suffer from database structure changes.
The following content will be involved:
1) based on the database design method of powerdesigner, the database version management is handed over to powerdesigner.
2) continuous integration of databases based on ccnet, mainly for script verification and packaging and Publishing
3) Group database development specifications
The tools involved include:
1) database structure comparison tool (desktop tools are used for design and msbuild tasks for continuous integration)
2) database deployment tools
3) powerdesigner
4) database version verification database (used in the business system to determine whether the database version matches)

Now I have written a database Deployment Tool sqldeploytool. Its features include:
* Deploy or upgrade the database based on the script directory (you need to add a version number to the database instance)
* Supports SQL script execution and CSV Data Import
* Three tools are provided: Console programs, desktop applications, and msbuild tasks.
* Pre-upgrade backup and recovery when an error occurs

Source code, detailed in readme.txt

* Update 20080606
sorry, this post is displayed only after this article is completed :. NET database migration tool Roundup
my sqldeploytool function is equivalent to rikmigrations mentioned in it.