Subject Re: [ib-support] Unique ID's for several Databases
Author Ann W. Harrison
At 01:35 AM 3/3/2001 +0100, guido.klapperich@... wrote:

>Does anyone knows any literature about this theme, it's very
>important for me. I know SQL-Server has this feature and I'm sure, I have
>read this article about realizing this in IB.

The subject has come up on the mers list from time to time. One
answer is to use GUIDs as David Robinson (?) suggested. Another
is to use generators, but preface the generated value with a string
unique to the database. Stick it at the front, rather than the
end to reduce the size of indexes. The archives at mers should
help.


Regards,

Ann
www.ibphoenix.com
We have answers.