Replication and data types

Enterprise Replication supports built-in data types and user-defined data types, including row types and collection types.

Enterprise Replication does not support replication of simple large objects stored on optical devices.

If you use SERIAL, SERIAL8, or BIGSERIAL data types, you must be careful when defining serial columns.

For non-master replicates, Enterprise Replication does not verify the data types of columns in tables that participate in replication. The replicated column in a table on the source database server must have the same data type as the corresponding column on the target server. The exception to this rule is cross-replication between simple large objects and smart large objects. By using master replicates, you can verify that all participants in a replicate have columns with matching data types. Master replicates also allow verification that each participant contains all replicated columns, and optionally that column names are the same on each participant.