Creating Replication Definitions and Subscriptions

Add new information at the end of step 1 in the task “Creating replication definitions and subscriptions” in Chapter 11, “Sybase IQ Replicate Data Server Issues.”

Create repdef_testtab replication definition:

create replication definition repdef_testtab
with primary at ASE_DS.pdb1
with primary table named ‘testtab’
with replicate table named dbo.‘testtab’
(c1 int, c2 int, c3 char(10))
primary key(c1)
go

Add any required referential constraint clauses to the replication definitions to support RTL.

Map the datatypes in primary Adaptive Server tables to replicate Sybase IQ tables:

Adaptive Server timestamp maps to IQ varbinary(8).
Adaptive Server bigdatetime maps to IQ timestamp.