logo

deltasql - Database Evolution under Control


Back to Website

Navigation Bar

Scripts

Modules

Projects

Branches/Tags

Synchronization

Statistics

Users

Utils

Help

Database Synchronization Form

1) First, make sure your database schema has a table called TBSYNCHRONIZE. If not, click on the project list and press on the 'Table' link, this will generate a script you have to launch on your database schema.

2) You should run the following query into the database instance you would like to synchronize, and then fill the form below with the query's results as explained in the italic comments

select * from tbsynchronize where versionnr = (select max(versionnr) from tbsynchronize);

Copy to Clipboard

3) Please enter the synchronization details you retrieved from the query:

Project Name:= value in column projectname
Version Number:= value in column versionnr
From:

= value in column branchname or tagname
Update To:= HEAD if schema has to include all scripts or another branch name if not
Output Format: HTML Text XML Single files (zipped)
Debug: Include debug information


4) Please copy and execute in a sql client (like SqlPlus or Toad or PhpMyAdmin) the script you will receive after pressing the button below!
This will update both your database schema and the synchronization information in table TBSYNCHRONIZE.



How synchronization works with examples

select * from tbsynchronize where versionnr = (select max(versionnr) from tbsynchronize);