Building and Deploying Project

This topic explains how to build and deploy a project.

Building Project

After you have edited your database project, you should build it to create a script that will deploy all the project changes to the database on the server. A project can be built to a single ready-to-deploy script or a set of scripts with a batch to run it in the MySQL Command-Line Tool.

To build a project:

  1. Choose a project configuration to build on the Build tab of the Project Properties window. (To open the window, click Properties on the Project menu).
  2. Right-click in the Project Explorer window and select Build the Project on the shortcut menu.

Project building is enhanced with the following features:

  • Syntax check in project scripts. (If any errors are found, the build is stopped.)
  • Check of references to schema objects in all statements.
  • Check of any object duplicates.

Project options to customize build results

Before building the project, you can set project options to customize build results.

  1. Right-click in the Project Explorer window and select the Properties option, or on the Project menu, click Properties. The Project Properties window opens. It contains three tabs: Build, Build Order, and Database.
  2. Use the Build tab to define the settings for the generated SQL file with project changes. For example, you can select whether to generate a single SQL script file or a batch script file, etc.
  3. The Build Order tab lets you manage the order of files in the build script and deploy execution. You can manage dependencies between objects in different files using build order. For example, table film2 in film_text.Table.sql references table film1 in film_Table.sql, so you should move film_text.Table.sql to locate under film_Table.sql on the Build Order tab.

    Note

    Actual document look may slightly vary from the above image, depending on the product you use.

  4. Move to the Database tab to manage target database settings. For example, you can set Server version to generate SQL statements, using syntax of this server version.

Note

Actual document look may slightly vary from the above image, depending on the product you use.

Deploying Project to Server

You can deploy either the entire project or only the changes in the project to the database on your server.

Note

Project files can be deployed only if a connection was assigned to the project.

Deploying an entire project

To deploy an entire project, click Deploy the Project on the Build menu.

Use Always re-create a database option to guarantee database integrity.

Deploying changes from your project

When you want to deploy only the changes from your project to the server, you should compare your project with the database on the server and create a special schema synchronization script. The script will deploy only required changes to the server.

  1. Right-click in the Project Explorer window and select the Synchronize Project with Server option. The document with comparison results opens.

    Note

    Actual document look may slightly vary from the above image, depending on the product you use.

  2. By default, the synchronization actions are automatically selected for each compared object. You can change them, for example, by selecting the Skip action to prevent applying the change.
  3. On the Comparison menu, click Synchronize to deploy the project changes to the database.

Synchronizing changes from the database on the server with the project

To synchronize changes from the database on the server with your project, do the following:

  1. Right-click the required database in the Database Explorer window, and select New Schema Comparison. The wizard opens.
  2. Select the database on the server as Source and your project as Target.

    Note

    Actual document look may slightly vary from the above image, depending on the product you use.

  3. Click OK and see the comparison results in the opened window.
  4. Analyze the differences. By default, the synchronization actions are automatically selected for each compared object, but you can change them, if required.
  5. Click the Synchronize button on the toolbar to synchronize the database with the project.

While comparing, the project can be either Source or Target. Note that the project is automatically built during comparison, so if any errors occur during this process, the comparison fails.