Database Change Management Tool

数据库的变更管理

 

工具地址： 

http://dbdeploy.com/documentation/taking-control-of-your-database-development-white-paper/ 

http://dbmaintain.sourceforge.net/overview.html  

 

 在敏捷开发的时候，功能不断变化，有时候需要变更数据库的Table,View或者Stored Procedure或者修改数据等等

在功能开发完成后，需要deploy到QA，UAT环境中，如果没有自动化的数据库Deploy工具，那么手动一个个去执行这些数据库脚本是非常费时费力的，而且有时候有些数据库脚本已经执行过了。还有一种比较复杂的情况，比如脚本002_Create_Table...， 这个脚本后来发现有错误，所以修改了这个脚本到数据库中，而从QA环境的数据库检查来看，已经执行了这个脚本，所以就会犹豫到底要不要执行这个脚本呢？  

 

DBMaintain：You no longer have to keep track of which database updates have been deployed on which database - DbMaintain does this for you. The database itself keeps track of the scripts that have been applied. A checksum is stored for each script that to ensure nothing has changed to the scripts that were already applied 
 

使用CheckSum标记，上面都问题就迎刃而解。

Updates are performed incrementally: Only what has been changed since the last deployment is applied. Features such as repeatable scripts, postprocessing scripts, multi-database / database user support and support for patches turn DbMaintain into a complete solution for the enterpris 

 

不过理论上看来没有什么，但是也是需要具体问题具体实践。