Aurimas:

I've passively researched this over a number of years and tell you
what I've come up with.

There are two types I am aware of: at the database level, and at the
connection level.

At the database level, I have found two I am aware of:

(1) Jason has one with IBO. My concerns here (and Jason pipe in if you
disagree--these are only my impressions) are:
a) It isn't overly well used. I want something solidly tested.
b) It seems pretty intrusive into changing the database structure.
c) Also, I don't understand it so that if there ever were any
issues, I would have to learn the custom methodology before I could
fix it.
d) The documentation is lacking.

(2) IBExperts (or the maker of IB Experts) has a solution. It requires
that each database use only one generator for all of the ID's in the
database--quite a change for any complex database. They have had a
white paper on it that explains it pretty well. I would need to over
it in more detail to get a full grasp of how it works.

At the connection level, REMObjects has an option to connect to any
back-end. This requires all connection access in the application to be
changed--but these also makes it easier to change databases in the
future (should that need ever arise).

I hope this gets you started. If you find out more, please let me know.

Edward Dressel