I've always tried to stay away from GUIDs because of the size and associated I/O hit. However, in this case I probably should have opened my mind to it...

Thanks for your response, Gail. My desire for doing this is to implement a primary key system (all surrogates) that enforces unique identifiers across the database (a.k.a. Enterprise Keys),...

We are now using Embarcadero's ERStudio as well... great tool and great customer service. As others have pointed out, it should do everything on your wish list. And...