Subject | Prepare to Replication |
---|---|
Author | fowlertrainer |
Post date | 2003-10-30T11:16:28Z |
I want to create a tool what prepare databases to replication.
It is create triggers/procedures/tables/etc for replication.
But I have a problem with primary key modification.
The tables have an ID field, an unique ID -> the primary key.
I want to chahge the constraint to containing the new field names
REPL_SITE_ID.
Every site have an SITE_ID, and if the generators are produced same
value to ID, the SITE_ID avoid the collisions.
In IBO help I see the definitions of IB_DDL classes, but I cannot see
any examples for I see, how to write a code to replace the constraint.
Please help me !
THX:
KK
It is create triggers/procedures/tables/etc for replication.
But I have a problem with primary key modification.
The tables have an ID field, an unique ID -> the primary key.
I want to chahge the constraint to containing the new field names
REPL_SITE_ID.
Every site have an SITE_ID, and if the generators are produced same
value to ID, the SITE_ID avoid the collisions.
In IBO help I see the definitions of IB_DDL classes, but I cannot see
any examples for I see, how to write a code to replace the constraint.
Please help me !
THX:
KK