DBUpdater Technology

  Summary

DbUpdater is a professional tool for synchronizing database structures.
It is ideal for software farms which have the problem of taking the customer data structure synchronized with the actual database structure.
During the life-cycle of an application, quite often the development team need to change the database structure and push those changes to customer database. Software farms spend lots of time and resources to accomplish this task.

DbUpdater will automate this non trivial process. It works in three steps:

1. prepares a package containing the complete schema of the original database
2. compares the schema with the customer database and builds a set of SQL commands required to synchronize the two databases
3. run the sql commands

All the process is governed by a set of configuration files where is possible to specify which objects (tables, stored procedures, views, indexes, .) synchronize and how (create, modify, delete, .).

All the three steps can be done in a single step in which case it is required a live connection to the customer database.

Moreover, the update can be made off-line. In this case the DbUpdater does not requires a live connection: when development team needs to update customers, it extracts the database schema (step 1), send schema to the customer and prepares the required sql instructions "on the fly" comparing actual database schemas with customer database structure.

In addition, the component can update databases which are installed in different providers. For example, if the actual database has been developed and maintained with SQL Server and if the customer provider is Sybase Adaptive Server Anywhere (ASA), the program can takes the two database synchronized.

Inside DBUpdater Technology (continue...)