Setting Comparison Key

Comparison key is used to determine which rows correspond to each other. You can choose suitable constraints for comparison or specify custom comparison keys. dbForge Studio can select comparison key automatically if tables have matching primary key or unique constraint.

To choose a constraint pair, click the button in the Comparison Key column on the Mapping page of the Data Comparison wizard and select the constraint pair you need.

To set a custom comparison key, click the button in the Comparison Key column on the Mapping page of the Data Comparison wizard and select Custom. Then, in the appeared Column Mapping dialog box, select check boxes in the Key column to add columns to the comparison key.

Note that you can set custom comparison key or choose the needed constraint pair directly in the Comparison Key drop-down list of the Column Mapping dialog box.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for MySQL.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for MySQL?