Before you deploy a configuration or configuration changes, ensure that the following requirements are met:
For a remote deployment, ensure that all components in both environments use the same version of Data Replication. If one environment uses an earlier Data Replication version, upgrade that Data Replication installation.
The mapped source and target tables must exist in the destination environment. Also, the source and target table definitions must be the same in both environments.
You can replace the schema names from the original environment during the initial configuration deployment. However, do not replace a single schema name with multiple schema names or replace multiple schema names with a single schema name. When defining schema replacement rules, ensure that each schema in the original environment corresponds to a single schema in the destination environment.
If the schemas are different, the new configuration in the destination environment includes only the column mappings that exist in the tables in both environments. In this case, the column positions in the new configuration might be incorrect. You can save the new configuration to update the column positions so that data can be replicated accurately in the destination environment.
If Oracle source and target tables contain any columns defined as UNUSED, these columns must be the same in both environments. Unused columns are defined by executing the ALTER TABLE