Hi,

I have two database, DB1 and DB2. Both database have same table format but
different data.
Is there a way for me to transfer data from DB1 to DB2 and at the same time
it won't overwrite the existing data in DB2 when DB1 usng the same unique
key in DB2. Thats mean during the data export from DB1 to DB2, I need to
cater for not overwriting the existing key but creating a new key for it.
And at the same time, I am able to create a new key for some relationship
table as well when existing key is existed.

What I am looking for is a sample program which can guide me.
I need an intelligent way to do it because I have about 20,000 rows of data
and 50 tables.

Thanks a lot.
Kenny