Online Documentation for DB Comparer for MySQL

Compare options


Set specific parameters of comparison for each type of database objects.

 

 

Select an object type in the object tree, set a flag to include the object type into the comparison process and define Compare properties in the corresponding group within the Compare Options tab.

 

The Script generation group allows you to specify whether a specific type of script (CREATE, ALTER, DROP) should be generated for objects of the selected type.

 

The Select All, Unselect All and Invert Selection buttons are implemented to make options selection easier.

Environment Options - Compare Options

 

CheckBox Case sensitive comparing

Enable this option to make the comparing process case sensitive.

 

CheckBox Compare broken objects

Enable this option to allow the utility to compare broken or invalid objects.

 

 

CheckBox Analyze renamed objects

This option enables/disables comparing databases object which might have been renamed.

 

CheckBox Show objects list

If this option is checked the list of all objects is displayed on the next step. If there is no need to check the list of retrieved objects you can uncheck this option to speed up comparison process.

 

CheckBox Add comments to generated script

Use this option to toggle comments in modification script.

 

CheckBox Trim table and field description after n characters

This option enables/disables cutting off the description for tables and fields after the specified number of characters.

 

 

CheckBox Use INFORMATION_SCHEMA

If this option is checked then metadata is refreshed using the INFORMATION_SCHEMA database. Otherwise, the 'mysql' database is used.

 

CheckBox Disable autoincrement in table DDL

If this option is checked autoincrement is off in DDL statements.

 

You can also set filtering criteria for objects to be compared. Use the Filter options tab for that purpose. For details see Setting compare options.