WHAT IS it?
The XComparer application is a manager tool of the differences of the database’s structure for the database’s developer technicians. It can provide solution in equally way for the comparison and synchronization of the database’s structure. It is able to identify quickly the differences of the database’s structures and support with it the immediate issue of the new updates of databases.
DATABASE of CONNECT
The connection of the new and old structure of database version. The database’s connection settings are totally independent of each other, so the place and mode of these can be different, too.
NEW AND OLD STRUCTURE
It can provide possibility to quickly map of the structural differences of two databases. The difference is the generation of the SQL scrip the synchronization of the two databases and the test of these databases after the synchronization.
Synchronized databases
After the synchronization the databases will be totally the same. You can avoid that risk that the difference customers will use the same database structure version.
RENAME Of the TABLE COLUMN
It can be provided a possibility without the data losing to change a column’s name by the function of the rename of the table column. You only have to give the old and the new name of the table column. You can avoid to losing the old table column or creating a new one so there will not be data losing.
difference sql script
The difference SQL script can be executed in simply way by the application of the Firebird’s command line. The XComparer takes care at the generation of the script that all of the database’s objects will be valid after the execution and there will not be invalid objects in the database (Procedure, View).
MANUAL MODIFY SCRIPT
The difference SQL can be modified or completed with other instructions by manual. It is a great help for the flexible operation of synchronization.
STRUCTURE TEST
The completed difference SQL scripter will be executed over the old database by the request of the application. After all it will make a comparison again for that case to test the operation of the synchronization.