Migration type

Select the type of migration, offline or online.

Note:

For online migrations

• To prevent Foreign Key constraint violation, all foreign keys are automatically disabled and then re-enabled before the switchover.

• Any DDL performed on these constraints during this period are not supported and will lead to failures in GoldenGate replication. This DDL limitation only applies during Data Pump Export.

• If DDLs on the disabled constraints are expected to happen during Data Pump Export then an Online migration with Snapshot Standby database is recommended.

• Performing the initial load from a Snapshot Standby (static environment) ensures a consistent dataset on the target, and all DDL changes will be captured by GoldenGate and applied to the target.

• Offline migration
  When using the offline migration method, you must stop updates to the source database before you start a migration.

• Online migration
  An online migration enables you to perform database migration without any downtime of your source database.