Deploying a database to an offsite location

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. Due to the volume of the database, the deployment procedure is sophisticated.

Main goals to be achieved

Reducing the time for the database deployment.

Our solution

Use Cross-Database Studio 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, which 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 other convenient time, 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 databases;
• 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;