Ignore any user differences and object permissions

dbForge Schema Compare for MySQL allows ignoring user differences and object permissions when synchronizing two databases.

To ignore object permissions

The configured schema comparison settings can be saved as a .scomp file for future use, allowing for the automation of schema comparison and synchronization tasks from the command line.

To save the project settings:

1. On the Options page of the New Schema Comparison wizard, select the Ignore permissions checkbox. Note that selecting this option will automatically activate the Ignore users’ permissions option.

2. Click Compare to run the comparison.

3. On the toolbar, click Save to save the project as a .scomp file.

To use the settings of the .scomp file in the command line, provide a path to it after the /compfile argument.

"C:\Program Files\Devart\dbForge Compare Bundle for MySQL\dbForge Schema Compare for MySQL\schemacompare.com" /schemacompare /compfile:"D:\comparison-file.scomp" /sync

where D:\comparison-file.scomp is the path to the .scomp file.

Helpful topics

• Use object filter
• Automate schema comparison and synchronization from the command line
• Command Line Wizard

Want to Find out More?

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Schema Compare for MySQL.

Request a demo

If you consider employing the Schema Compare for your business, request a demo to see it in action.

Ready to start using dbForge Schema Compare for MySQL?

Download a free 30-day trial

• Previous
• Next