Devart Forums

Hi just downloaded the software for a test trial. The issue I am having is when I try and run the command line sync it says there are no differences, however, even in the summary it shows the source has 2 additional records that need to be inserted in the target db. Am I missing a parameter

I am using the following command line
"C:\Program Files\Devart\dbForge Data Compare for MySQL\datacompare.com" /datacompare /compfile:C:\TD_Library\Scripts\tdLiveSync.dcomp /sync

Thanks,

MJH

In fact, the command line string that you provided is correct for the case when you want to synchronize it straight into a database.

If you want to generate a synchronization script, the command line string should be as follows:

"C:\Program Files\Devart\dbForge Data Compare for MySQL\datacompare.com" /datacompare /compfile:C:\TD_Library\Scripts\tdLiveSync.dcomp /sync:file_name.sql

However, the following problems are possible:

1. Incompatibility with the Target's constraints. For example, when trying to insert NULL values into a NOT NULL column, a conflict in the values of FOREIGN KEYS, etc.
2. A conflict with the triggers on the Target.

Please also check whether the synchronization runs successfully through the GUI of dbForge.

In case it runs in the GUI, but doesn't run trough the command line, please provide us the following:

1. CREATE definitions of the tables you are synchronizing.
2. At least two records with data.
3. The .dcomp data comparison document.
4. The version of the MySQL server.

Thank you for your assistance the gui interface will allow me to sync but it presents me with a warning of "a foreign key might not recover after synchronization" not sure if this warning is prevention the insertion of the 2 new records - also what would cause this warning?

Thanks,

MJH

The warning means that the 'Disable Foreign Keys' option is selected on the 'Options' page of Data Synchronization Wizard.

Could you please let us know whether you also get such warning when synchronizing through the command line interface. Are you using the same .dcomp file in the GUI and command line interface?

Could you please still provide us the CREATE definitions of the tables that you were synchronizing and a few records with data?

To make sure your data is kept confidential, please send a reply straight to our support system at supportATdevartDOTcom, and we will keep further correspondence with you on this issue via that system.

Thank you for the files you sent us.

We are currently investigating this issue and will answer you as soon as possible.

From the Summary section of the log file you provided, there appear to be 53311 rows: 1 - Only In SOURCE, the rest - Equal. Whereas in the detailed description, there appear to be 53310 records that are all detected as Equal.

We suppose that one of the records that is in the 'Only In SOURCE' section, is just unselected for synchronization and the *.dcomp file is saved in this state. As a result, synchronization doesn't start since the only difference is excluded from the synchronization.

We would recommend you to check that all records are selected for synchronization.

If this still doesn't solve the issue, please provide us the *.dcomp file and exactly the record that is in the 'Only In SOURCE' section.