Database Project Overview

dbForge Studio for MySQL comes with an extensive project management system that allows you to create database projects and integrate related database development files.

dbForge Studio database projects greatly facilitate database development and allow offline database development. Database project can be created from the scratch or imported from a database.

Project building allows you to create a single ready-to deploy script for deploying your database to the server. Building project includes the following:

  • Checking SQL syntax of all files from the project.
  • Checking references.
  • Applying project options to the scripts if necessary.
  • Combining project scripts to a single script or generating run script that executes project scripts in a certain order.

For more information about project building, see Building and Deploying Project.

Checking SQL syntax and checking references ensure that your project is valid without using the server connection.

Project allows you to manage such items as SQL and query files and database objects easily. It allows you to group scripts and queries into folders and provides fast access to the selected database objects.

You can also work with schema objects, generated by the project scripts. These objects are displayed in the Schema View window. You can delete such an object. For more information, see Working with Database Objects in Projects.

When you work with the project and exit dbForge Studio for MySQL, it remembers all opened documents, even files and database objects that do not belong to the project, and opens them next time when you open this project. The project also remembers all document bookmarks, breakpoints, and watches that can help you to restore the previous debug session. Note that when you close the project, all opened documents are closed too.

The project folder and file structure, connection and database object links, build order are stored in a file with extension. Temporary information about opened documents, bookmarks, breakpoints, watches is stored in the file, having the same name and extension user.