This menu features actions against the connected MySQL server. The Database menu has these items:
Query Database: Launches the SQL Editor, which enables you to create SQL code and execute it on a live server. For more information, see Section 6.1, “SQL Editor”.
Manage Connections: Launches the Manage Server Connections dialog, which enables you to create and manage multiple connections. For more information, see Section 3.3, “Manage Server Connections”
Reverse Engineer: Creates a model from an existing database. For more information, see Section 188.8.131.52, “Reverse Engineering a Live Database”.
Forward Engineer: Creates a database from a model. For more information, see Section 184.108.40.206, “Forward Engineering to a Live Server”.
Schema Transfer Wizard...: Executes the database migration wizard for MySQL databases. It is useful for moving from an older MySQL server to the latest MySQL version, and is meant for local development purposes. You should not use this tool on production MySQL instances as they often require more complex data migration techniques.
For additional information about this wizard, see MySQL Schema Transfer Wizard.
Migration Wizard...: Executes the database migration wizard for most any database, and is meant to migrate tables and data from supported database systems to your MySQL server. For additional information, see Chapter 10, Database Migration Wizard.
Edit Type Mappings for Generic
Migration: From here you can define custom type
mappings, such as migrating the source data type
int8 to the target MySQL data type
Synchronize Model: Synchronizes your database model with an existing database. For more information, see Section 220.127.116.11, “Database Synchronization”.
Synchronize with Any Source: Allows you to compare a target database or script with the open model, external script, or a second database, and apply these changes back to the target. For more information, see Section 18.104.22.168, “Database Synchronization”.
Compare Schemas: Compares your schema model with a live database or a script file. Section 22.214.171.124, “Compare and Report Differences in Catalogs”.