Data Replication supports the replication of many types of DDL operations from DB2 for Linux, UNIX, and Windows, Microsoft SQL Server,
MySQL,
and Oracle sources to a target.
In the Data Replication Console, you can select the types of DDL operations to replicate on the
Map Tables
and
Map Columns
tabs. Also, from the
Map Tables
tab, you can customize apply settings to indicate the types of DDL changes to apply.
When the Data Replication Console retrieves metadata for the configuration from the source database, the Console gets the current SCN
, log coordinates,
or LSN and writes this value to the replication configuration. When you run the Extractor later, it skips DDL changes that have SCN
, log coordinate,
or LSN values that are lower than the SCN
, log coordinates,
or LSN in the configuration.
When replicating DDL operations between heterogeneous sources and targets, the source and target databases might support different sets of DDL operations. You can replicate only the source DDL operations that can be mapped to compatible target DDL operations.
The Applier might skip a DDL operation or end abnormally if you replicate a source DDL operation that cannot be represented in the SQL syntax for the target type.