Upgrading offsite databases

The Case

A number of schema and data upgrades have been made to your database, and now you need to deploy the new upgraded version of the database to the customer.

Main goals to be achived

• Reducing or eliminating impact on clients due to database downtime.
• Reducing the time for the database upgrade.

Our solution is

Use Cross-Database Studio 6.0 in order to generate SQL synchronization scripts:

1. Select schema objects to be deployed;
2. Create synchronization scripts for selected database objects and/or data and save them into export file;
3. Preview and edit on demand the SQL scripts will be used to deploy schema and/or data changes;
4. Copy export file to an offsite customer site and execute it.

Advantage of our solution

• No impact on users since the CDBS products can be run on live database
• Reducing transfer and upload time by compressing the package
• The package can be used any number of times to upgrade multiple offsite databases.