dbdeploy is a Database Change Management tool. The project helps developers and DBAs change their database in a simple, controlled, flexible and frequent manner.
The recurring problem with database development is that at some point you??ll need to upgrade an existing database and preserve its content. In development environments it??s often possible (even desirable) to blow away the database and rebuild from scratch as often as the code is rebuilt but this approach cannot be taken forward into more controlled environments such as QA, UAT and Production.
Drawing from our experiences, we??ve found that one of the easiest ways to allow people to change the database is by using version-controlled SQL delta scripts. We??ve also found it beneficial to ensure that the scripts used to build development environments are the exact same used in QA, UAT and production. Maintaining and making use of these deltas can quickly become a significant overhead - dbdeploy aims to address this.
How It Works
By comparing the SQL delta scripts on your filesystem against a patch table in the target database, it generates SQL scripts ?? it doesn??t directly apply them.
dbdeploy can be called from within an ant build file.
dbdeploy supports the following DBMS:
MS SQL Server
Hypersonic SQL. . Publisher of dbdeploy, Author of dbdeploy 2.01. dbdeploy is a Database Change Management tool. The project helps developers and DBAs change their database in a simple, controlled, flexible and frequent manner. The recurring problem with d
Druide DB project is a simple XML file database API in Java to manage an XML database file system without database complexity (no server or client, and stores only strings).
You should try DruideDB if you are doing the following :
??? ... DBFW
DBFW is a PHP-based database framework for rapid application development and rapid prototyping.
DBFW project allows the creation of almost complete Web/database-based applications in no more than few hours, as well as faster development cycles.
It uses automatic DB schema discovery with ...
(Popularity: ) : Pear::DbDeploy is a pear package to employ dbdeploy as a database change-management tool. (See http://dbdeploy.com/) dbdeploy.NET
(Popularity: ) : Manages the deployment of numbered change scripts to an SQL Server database, using a simple table in the database to track the current schema version. Port of dbdeploy to .NET