acegracely wrote:

>
>
> I need to make my database replication friendly...
>
> Am I right in thinking that the easiest way is to make all primary
> keys an integer with a generator?

That's a start.

>
> If so, will this fall over if replication is bi directional i.e.
> depending on the time interval between replications, both ends could
> add a number of records thus the generators could be out of sync.

Yup. But put a table in your database that contains a field that
identifies the server and make all your keys two part - server and
generated value.

>
> Also, how does this affect foreign key constraints IOW can I create a
> foreign key constraint on a unique index rather than the primary key
> field?

A Unique constraint will do.

>
> Is there any firebird documentation to help with this?

The Firebird Book by Helen Borrie from APress, available through
ibphoenix.com