Does the table structures on the source and the target machine have to be the same for replicatio
Does the table structures on the source and the target machine have to be the same for replication?
Source and target tables must have the same structure in order to be replicated. The number of columns must be identical, and corresponding columns must contain the same datatypes. The names and owners of a source and target table can be different, as long as the structures of the two are the same. (SharePlex knows to replicate to the correct table because you specify it by owner and table name within the configuration file.)