Deploying a database to an offsite location

The Case

Your company opens a new project and you need to migrate your database to a new offsite location. The deployment procedure is sophisticated due to the database volume.

Main goals to be achived

• Reducing the time for the database deployment.

Our solution is

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

1. Select schema objects to be migrated;
2. Create migration 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 create schema and data;
4. Copy export file to an offsite location and execute it.

You can assign the comparison at night, or at any time you are comfortable with, by using the scheduling capabilities of the CDBS products.

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 database package can be used any number of times.
• The database package can be maintained per product version.