Applying Project Options When Synchronizing a Project and a Schema

When comparing two schemas, all database object parameters can be retrieved from the server. But some parameters in project DDL scripts may be skipped, for example, table engine for tables, collation, definer for stored routines and views. When comparing project and schema, values for these skipped parameters are taken from the project properties. Default table engine and collation (with its charset) are automatically placed to the object DDL when comparing. If default definer is specified and it is not the CURRENT_USER, it is also placed to the object DDL automatically.

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?