Skip to Content
Information
This version of the software is currently available only to customers in the Controlled Availability (CA) program.

Database considerations for all RDBMSs

The following configuration information applies to all relational database management systems.

Replication

During data migration, do not use data replication technologies such as Oracle Dataguard or MS SQL AlwaysOn. Otherwise, export and import times are negatively affected.

We recommend that you create a data migration RDBMS environment for the project. This RDBMS should house a copy of the source and target databases.

In an upgrade scenario, the source database is typically created by taking a copy of the overnight backup from the current production system. During the final production cutover, this source database is created from a manual backup created after the production system is shut down.

Using a static snapshot of your production system also simplifies the process of verifying that all in-scope data was migrated successfully. It is much more difficult to do this against a live production system where the data is constantly changing.

Database space

Make sure you have enough database space in the target database for the data that is being imported.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Helix Data Manager 21.05