deltasql

deltasql is a comprehensive and efficient software solution aimed to provide database developers with the means of keep tracking of changes performed by team members, acting as a version control instrument to enable them to keep their schema up to date, at all times, allowing them to carry on with their work.

By relying on version control, it is less likely for errors such as missing scripts or different schemas to occur, while also limiting the amount of critical errors in production, as a result of schema inconsistency.

deltasql does this by synchronizing the databases with the source code as it is being written by developers. It comes with a series of PHP scripts that will be run on an Apache server connected to a database, in order to gather the scripts altering the data model, along with method of handling its branches.

For this to happen, users need to number the SQL scripts and build a database instance table where they can store the number of the script that was run last. deltasql relies on a table names ‘TBSYNCHRONIZE’ for this precise purpose.

By means of a form, users can input data from the synchronization table, which automatically updates and computer the data model chain, returning the result to users. Scripts need to be manually executed.

Moreover, deltasql allows users to update the development as well as the production schemas, or they can transform them from one to the other. A dumped schema can be imported into a different DB and can be upgraded, given that the synchronization table is stored within the duplicate schema.

Downgrading a schema to an earlier version, however, is not supported. deltasql is equipped to handle Oracle, PostgreSQL, MySQL or SQL Server databases, but it can also work with other SQL-like DBs.