Rank: Newbie
Joined: 3/6/2009
Posts: 9
|
Hello all,
I'm using Diffdog with the MySQL ODBC-driver for merging two databases. There is a problem in Diffdogs behavior when merging the rows.
An example: you have one database row which only exists in the source table and you want to insert this row in the target table. Diffdog then uses the auto-increment number (set in MySQL) for the new primary key.
This behaviour ensures that the primary key is unique, however, it doesn't necessarily keeps the consistency between tables. If you insert multiple rows from different tables of the source database, you may want to keep the foreign key constraints. However, I can't see any option in Diffdog to ensure the consistency of foreign key constraints in the target database.
There should be at least an option "keep the primary key". Diffdog then just has to check if there would be any double primary keys in the target database when inserting rows from the source.
I've tried to insert table rows via ODBC using Access. In this case, it is possible to ignore the auto-increment value from MySQL. So there is no restriction in the ODBC driver.
Anyone else who thinks this might be a useful option?
Andreas
|
