With Replication Server 15.2, there is improved support for non-ASE servers such as simplified installation and configuration, and connection profiles. To prepare non-ASE databases for replication, see the Replication Server Heterogeneous Replication Guide.
With Replication Server 15.2, you do not need to edit and execute scripts to install datatype definitions, function strings, and class-level translations for heterogeneous (non-ASE) datatype support. The functions provided by the scripts are included as part of the Replication Server 15.2 installation, or are included in connection profiles that are installed with Replication Server 15.2. These enhancements simplify installation and configuration for non-ASE environments. Follow the simplified configuration instructions in Chapter 8, “Installing and Implementing Heterogeneous Datatype Support” in the Replication Server 15.2 Configuration Guide for your platform.
In addition, Replication Server 15.2 and later provides error class support for non-ASE replicate databases. See “Data server error handling,” in Chapter 6, “Handling Errors and Exceptions” in the Replication Server Administration Guide Volume 2.
With Replication Server 15.2, you can use connection profiles that contain connection configurations and replicate database object definitions relevant to each type of actively supported non-ASE data server. You can use these connection profiles and simple syntax to create connections between actively supported data servers such as Adaptive Server Enterprise, IBM DB2, Microsoft SQL Server, and Oracle. Replication Server uses the connection profile to configure the connection and create replicate database objects for you.
Connection profiles specify the function-string class, error class, and class-level translations to be installed. You can also use connection profile options to specify other actions such as whether commands should be batched and the command separator to use. See “Creating database connections” to create connections using connection profiles.
When you create a connection using a connection profile,
the system table services (STS) caches are refreshed so that you
do not need to restart Replication Server.
See “Command batching for non-ASE servers,” in Chapter 2, “Customizing Database Operations” in the Replication Server Administration Guide Volume 2.
