Subject Re[2]: [IBO] Prepare to Replication
Author Kepes Krisztian
Hello Jason Wharton !

Friday, October 31, 2003, 6:33:55 PM, you wrote:

>> 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.

JW> You may want to look at the work I've done with my replication. It provides
JW> a good model to follow and you could even help me improve mine as well.

JW> Look in the IB_RPL_*.* files.

JW> Jason Wharton


JW> Yahoo! Groups Sponsor
JW> ___________________________________________________________________________
JW> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
JW>              without the need for BDE, ODBC or any other layer.
JW> ___________________________________________________________________________
JW> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
JW> keyword-searchable FAQ, community code contributions and more !          

JW> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



Sorry for disturbing, but how it is working ?
It have an example in the web ?

What is it's mechanism/method ?

What a kind of table changes needed to be it is working in my database
?

Thanx for any anwers !
KK

------------------------------------------------------
Kepes Krisztian -> mailto:Kepes.Krisztian@...
------------------------------------------------------