To add a database for a non-Sybase data server, use the create connection command.
To add a database for a Sybase data server, you normally use Sybase Central or rs_init, both of which prepare the database for replication. If you use create connection, you must prepare the database for replication yourself. Refer to “Steps in preparing databases for replication”.
Enter create connection at the Replication Server that is to manage the database. The syntax is:
create connection to data_server.database
set error class [to] error_class
set function string class [to] function_class
set username [to] user
[set password [to] passwd]
[set database_param [to] 'value']
[set security_param [to] {‘required’ | ‘not_required’}]
[with {log transfer on, dsi_suspended}]
[as active for logical_ds.logical_db |
as standby for logical_ds.logical_db
[use dump marker]
You must use the with dsi_suspended clause, which starts the connection with the DSI suspended, when you create a connection to a database that will not be a replicate database.
The as active, as standby, and use dump marker clauses are used only when you create physical connections for a logical connection for a warm standby database. Only Adaptive Server databases may be used in warm standby applications.
If your system supports network-based security, use the set security_param command according to instructions in “Managing network-based security”.
Refer to Chapter 3, “Replication Server Commands,” in the Replication Server Reference Manual for more information about the create connection command.
