Todd Brasseur wrote:

>>>That the replication process would get new primary keys and insert the
>>>records using the new primary keys rather than the existing ones. This
>>>would allow us to leave our application and database virtually the same.
> Why would this approach "lose the ability to check for errors"?

If you records have one value for PK in one database, and completely different
PK value for same record in other database, how would you keep track?

If somewhere the process breaks, how would you check which records are
replicated successfully and which are not?

--
Milan Babuskov
http://fbexport.sourceforge.net