deltasql Open source tool to synchronize databases with source code
Download

deltasql Ranking & Summary

deltasql Tags

sync synchronize database synchronize synchronizer database synchronizer database sync

deltasql Description

Open source tool to synchronize databases with source code 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 mySQLFrom time to time, branches of source code are done to stabilize the code which will go to production. A sort of data model branch is also needed. deltasql provides a simple way to collect all scripts which change the data model, and means to handle data model branches.The trick is to number the sql scripts and to create on each database instance a table which keeps the number of the latest executed script (the table is named TBSYNCHRONIZE). A form allows the user to enter data from the synchronization table and thereafter the needed chain of datamodel updates is computed and shown to the user. The user has to manually execute the synchronization script.It is possible to update development schemas (the HEADs) and production schemas (the branches), to transform the production schema into a development schema and vice versa.However, also in case of a schema dumped and imported into another database, it is still upgradeable as the synchronization table is contained into the copyed schema. However, it is not possible to downgrade a schema back to a previous version. What's New in This Release: · possibility to submit scripts with the option "in all branches" or "not in any branch" (by Lukas Stucki) · ability to remove empty lines in a script in submitscript.php (by Lukas Stucki) · bugfix: test data is correctly inserted by install.php · bugfix: error rights in Top Ten Submitters

deltasql Related Software