Applying Project Options When Synchronizing a Project and a Schema

Last modified: October 18, 2023

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.