dbdeploy is a tool for managing database changes. The project helps developers and database administrators to change their basic manner.The a simple, controlled, flexible and frequent recurring problems with the development of databases is that at some point, you will need to update an existing database and maintain its content. In development environments, it is often possible (even desirable) to blow away the database and rebuild from scratch as often as the code is rebuilt but this approach can be taken forward in more controlled environments as QA, UAT and Production.Drawing our experiments, we found that one of the easiest ways to allow people to change the database is to use scripts to version control SQL Delta. We have also found useful to ensure that the scripts used to build development environments are exactly the same used in QA, UAT and production. Maintain and make use of these deltas can quickly become a significant overhead - dbdeploy aims to meet this.How It compares WorksBy Delta SQL scripts on your file system on a table patch in the target database, it generates SQL scripts - it is not directly apply methodsdbdeploy them.Invocation can be called from an Ant build file. Supportdbdeploy DBMS supports the following DBMS: SQL OracleMS SQL ServerSybaseHypersonic
☰