deltasql 是一个高级的数据库模型">版本控制软件,类似于 cvs 和 svn 。它可以让一个团队同时开发一个数据模型,该工具目前支持的数据库包括:MySQL, PostgreSQL 和 Oracle
A strong version control system for databases saves time to developers, who would like to keep their schema updated while developing with minimal effort. With a version control for databases, the number of mistakes due to different schemas or missing scripts is considerably reduced. Critical errors in production due to schema inconsistencies disappear, too.
deltasql is an Open Source tool to synchronize databases with source code, which helps to keep database evolution under control. While developing medium to large applications, developers undertake changes to the data model which go along with changes to the source code. The deltasql server runs on Apache and is backed by mySQL
特点:
·Deltasql server manages SQL scripts which alter database structure and contents. It organizes scripts in modules, which can be grouped in projects. It allows to search among them.
·Database synchronization by adding special synchronization table to each schema. Synchronization script generated by deltasql server. Handling of branches of branches and tags supported.
·Verification step inside synchronization script to ensure script is executed on correct schema (available for Oracle and PostgreSQL).
·Several teams of developers can manage several projects and several databases.
·Ability to manage development schemas and production schemas by creating branches, branches of branches and tags.
·Syncronization scripts can be generated for Oracle, postgreSQL, mySQL, Microsoft SQL Server and sqlite. On user request, any SQL-like database can be supported.
·Synchronization script can be exported in several formats, including pretty printed HTML, text and XML or even a zipped package with each script stored in a separate file.
·Free to use, Open Source tool licensed under GPL.
·Integration in Eclipse IDE with ant client or dbredactor client.
·Bash client can perform continouus database integration on Linux.
·Google Gadget shows latest submitted scripts on iGoogle homepage.
·Easy to install, like a webforum, as deltasql server runs on Apache/PHP backed by a mySQL database.
·There is a manual and a list of frequently asked questions.
·It is used productively by companies in Switzerland and India and is popular in Japan and South Korea. In some companies it manages more than 2000 scripts and more than 10 projects.
·Typically used for large J2EE/Oracle software architectures which are partially customized to the customer's wishes.
·Lightweight, fast and reliable :-)
下载地址:http://sourceforge.net/projects/deltasql/files/deltasql%20server%20and%20clients/1.3.4/deltasql-1.3.4.zip/download