The heterogeneous datatype support (HDS) feature of Replication Server provides a number of sample SQL scripts that help you set up the HDS feature in the replicate Replication Server and the Oracle replicate database. These include:
A script to be applied to the Oracle replicate database.
The hds_oracle_setup_for_replicate.sql script creates the RS_INFO, RS_LASTCOMMIT, and RS_TICKET_HISTORY tables in the replicate database. The script includes GRANT statements that need to be changed before execution to reference the correct user ID name of the Maintenance User defined in the Replication Server database connection for the replicate database. The Maintenance User ID must have UPDATE authority on the tables.
Sybase recommends using the Maintenance User ID to execute
this script.
hds_oracle_funcstrings.sql and hds_oracle_udds.sql – scripts to be applied to Replication Server System Database (RSSD).
The hds_oracle_udds.sql script adds the user-defined datatypes (UDDs) that define the attributes of Oracle native datatypes to the RSSD. The UDDs are required to ensure datatypes received from primary transactions are properly formatted for application to the Oracle replicate database.
You might need to modify the hds_oracle_udds.sql script
to reference the correct RSSD database name.
The hds_oracle_funcstrings.sql script replaces several default Replication Server function strings with custom function strings designed to communicate with an Oracle data server and access the tables and procedures created by the hds_oracle_setup_for_replicate.sql script. These function strings are added to the Replication Server default rs_oracle_function_class.
You might need to modify the script to reference the
correct RSSD database name.
Class-level translations identify primary datatypes and the replicate datatypes the data should be translated into (for example, IBM DB2 Universal Database TIMESTAMP should be translated to Oracle DATE).
These translations can affect Replication Server performance.
Only the translations needed for your specific primary database
and replicate database should be applied to the RSSD.
Class-level translation scripts supplied for the Oracle replicate database are:
hds_clt_ase_to_oracle.sql – translates Adaptive Server datatypes to Oracle datatypes.
hds_clt_db2_to_oracle.sql – translates IBM DB2 Universal Database for z/OS datatypes to Oracle datatypes.
hds_clt_udb_to_oracle.sql – translates IBM DB2 Universal Database (for UNIX and Windows) datatypes to Oracle datatypes.
hds_clt_msss_to_oracle.sql – translates Microsoft SQL Server datatypes to Oracle datatypes.
A script to be applied to the replicate Replication Server.
The hds_oracle_connection_sample.sql script provides a template for creating the Replication Server database connection for an Oracle replicate database using the pre-defined Oracle function-string class provided with Replication Server.
You must modify the hds_oracle_connection_sample.sql template
to include your actual server, database, and Maintenance User names
before executing the script.
