Use forward engineering to export your schema design to a MySQL server.

Select the schema that you wish to forward engineer and then choose the Database, Forward Engineer... menu item from the main menu.

The first page to be displayed is Catalog Validation (validation is available only in the Standard Edition).

Figure 7.33. Catalog Validation

Click Run Validations to validate the catalog.

Click Next to continue.

The next page enables you to set options for the database to be created. These options are as described in Section 7.7.10.1.1, “Creating a Schema”.

Figure 7.34. Options

Select the required options and then click Next.

The next page enables you to select the objects to forward engineer.

Figure 7.35. Select Objects to Forward Engineer

To select a subset of objects to forward engineer, use the Show Filter/Hide Filter button, then select specific objects. After you have selected your objects, click Next to continue

On the Review Script page you may review and edit the SQL script that will be executed.

Figure 7.36. Review Script

Click Next to continue if you are satisfied with the generated script.

The next step of the process is to connect to a MySQL server in order to create the new database schema. This page enables you to use a previously stored connection, or enter the connection parameters.

Figure 7.37. Set Parameters for Connecting to a DBMS

After the connection parameters have been set, click Execute. The next page of the wizard displays the results of the forward engineering process.

Figure 7.38. Forward Engineering Progress

You can confirm that the script created the schema by connecting to the target MySQL server and issuing a SHOW DATABASES statement.