You must consider the following issues in a non-Sybase primary to non-Sybase replicate configuration:
The Replication Server primary database connection must include a valid user ID and password for the primary database. This user ID must have authority to apply replicate transactions (even if no transactions will be replicated to the primary database).
The hds_xxx_setup_for_replicate.sql script for the replicate database must be executed against the replicate database to create the rs_info and rs_lastcommit tables in the replicate database.
The Replication Server replicate database connection must be created referencing the correct function-string class for this particular replicate database (for example, rs_informix_function_class).
The hds_xxx_funcstrings.sql script must be applied to the RSSD of the replicate Replication Server.
The hds_clt_ase_to_xxx.sql script must be applied to the RSSD of the replicate Replication Server to provide class-level translation of Adaptive Server native datatypes to the replicate database native datatypes.
Even if you are not replicating from an Adaptive Server primary database, Adaptive Server native datatypes are used in the default Replication Server function string calls to maintain the rs_lastcommit table. In addition, replication definitions for a non-Sybase primary database may use Adaptive Server native datatypes.
If you use a Replication Server HDS datatype definition to define a column’s datatype in a replication definition, the hds_clt_xxx_to_xxx.sql script must be applied to the RSSD of the replicate Replication Server to provide automatic translation of that primary database datatype to a replicate database native datatype.
For example, with an Oracle primary database and an Informix replicate database, you must apply the hds_clt_oracle_to_informix.sql script to the RSSD of the replicate Replication Server.
If you can use existing Replication Server native datatypes to represent all the columns (that is, no datatype definitions are required), then no HDS translation scripts need be applied.
If the same type of non-Sybase database is used for
both primary and replicate databases (for example, Informix to Informix),
no additional translation script is required.
