Changes to Connection Profile Commands

Replication Server Data Assurance Option 15.7.1 SP110 accepts MSSQL and UDB values in the type parameter, when you create Microsoft SQL Server and IBM DB2 UDB connections using the create connection command.

You can also use the type parameter to enter MSSQL and UDB values in the replace connection and test connection config commands.

As of 15.7.1 SP110, you can specify an optional sessionTimeZone property for an Oracle database connection.

This property is used by the Oracle JDBC driver, when comparing TIMESTAMP WITH LOCAL TIME ZONE columns. For example:

create connection ora_conn1
      set type=ORACLE
  and set agent=agent_jupiter
  and set host=jupiter
  and set port=1521
  and set database=XE
  and set user=harry
  and set password=openSesam3
  with properties
       set sessionTimeZone='Europe/London'
go

The sessionTimeZone property overrides the default value.

See Replication Server Data Assurance Option Users Guide.