Lesson 6: Create the table for the primary database

Lesson 5: Add Replication Server information to the primary database

Lesson 7: Add Replication Server information to the replicate database

ASA Database Administration Guide
Replicating Data with Replication Server
Tutorial: Replicate data using Replication Server

Lesson 6: Create the table for the primary database

In this section, you create a single table in the primary site database, using isql. First, make sure you are connected to the primary site database:

isql -U DBA -P SQL -S PRIMEDB

Next, create a table in the database:

CREATE TABLE news (
  ID int,
  AUTHOR char( 40 ) DEFAULT CURRENT USER,
  TEXT char( 255 ),
  PRIMARY KEY ( ID, AUTHOR )
)
go

Identifier case sensitivity

In Adaptive Server Anywhere, all identifiers are case insensitive. In Adaptive Server Enterprise, identifiers are case sensitive by default. Even in Adaptive Server Anywhere, ensure the case of your identifiers matches in all parts of the SQL statement to ensure compatibility with Adaptive Server Enterprise.

In Adaptive Server Anywhere, the database determines case sensitivity. For example, passwords are case insensitive in case insensitive databases, and case sensitive in case sensitive databases. Extended characters used in passwords are case sensitive regardless of database sensitivity. User IDs, being identifiers, are case insensitive in all Adaptive Server Anywhere databases.

For news to act as part of a replication primary site, you must set the REPLICATE flag to ON for the table using an ALTER TABLE statement:

ALTER TABLE news
REPLICATE ON
go

This is equivalent to running the sp_setreplicate or sp_setreptable procedure on the table in Adaptive Server Enterprise. You cannot set REPLICATE ON in a CREATE TABLE statement.