Database Projects for MySQL Server

The Database Projects functionality has significantly improved database development. A database project represents a database schema with extended opportunities for offline schema development.

  • Improve the readability of database objects, aliases, variables, and users while preserving meaning with the refactoring feature
  • Use a MySQL version control system for efficient database team development
  • Customize a MySQL database project for deploying to various versions of SQL Server with multiple configurations
  • Simplify your work with SQL scripts by utilizing features such as automatic syntax checking, identification of schema object references in all statements, and detection of any object duplicates
  • Use the scripts folder to export a database project to a SQL script file

Introduction to Database Projects

A database project is a collection of logically organized SQL scripts and query files, which are used both to create a new database and to update an existing one. Database projects can be created from scratch or imported from a database. They offer a lot of features that propel quick and convenient database development and SQL editing. Watch the video and see it all in action.

10 Benefits You Get from Database Projects

1. Logically organized scripts and query files in Project Explorer that allows for quick access to SQL scripts and database objects.

When the Check references option is active, the tool automatically validates project metadata before generating a deployment script. The script is created only if no errors are detected.

2. Developing databases in offline mode within a fully customizable environment.

3. Multiple database project output options are available for deploying changes to a server database. These options include a single ready-to-deploy script, a customizable set of scripts with a batch file for execution in the MySQL Command-Line Tool or in dbForge Studio.

When the Add IF NOT EXIST in create object statements option is selected, the IF NOT EXISTS command will be added to the object creation script.

Database Projects MySQL outputs

4. Various customizable configurations. Yu can set up the required connection and settings in the project configuration once, so you can easily reuse them in the future, eliminating the need for manual adjustments.

5. Automatic validation of database project syntax and object references when building or comparing a database project in MySQL. You can rename tables, views, columns of tables and views, aliases, stored routines, local variables, triggers, events, and users. Statements that reference a renamed object will be automatically updated in all the project scripts. Text strings and comments containing the object's name will also be automatically updated.

6. Adjustable build configuration. The project can include all files of your solution or only necessary files in the output for different project configurations.

Database Projects in MySQL - Adjustable build configuration

7. Convenient and facile database deployment to the server. You can deploy the entire project or the changes you have made to the server.

To make the deployment easier, you can specify a server version to generate SQL statements aligning them with the syntax of that server version. You can also configure or import project settings. In addition, the Database tab provides options for renaming the target database or recreating the database to ensure database integrity.

Use our tutorial - Modern Approach to Database Development for in-depth guidance on working with database projects.

Database Projects in MySQL - Convenient database deployment

8. Comparison of a MySQL project with a required database, a scripts folder with subfolders for each object type, or a source control. You can get a synchronization script and deploy database changes.

9. Project sample included in the dbForge Studio for MySQL trial version. You can access it at:
"C:\Users\User_Name\Documents\dbForge Studio for MySQL\Projects\Sakila\"

10. Database project is a modern and dynamically developing technology. The Studio provides a range of useful options to make your project development efficient and enjoyable.

Database Projects MySQL - Comparing a database project with a database

Conclusion

Database Projects available in dbForge Studio for MySQL fully meet modern database development standards. With the Database Projects functionality, MySQL database development is a clear and logical process that allows you to efficiently:

  • Create a database project in the wizard, either empty or with database objects imported from a database
  • Manage SQL scripts and query files in the project and edit their contents
  • Build the ready project to create a script that will deploy all the project changes to the database on the server
  • Deploy either the entire project or only required changes to the server

dbForge Studio for MySQL

The most intelligent MySQL management tool

Download

Availability in the editions of dbForge Studio for MySQL

Feature

Enterprise
Professional
Standard
Express
Database project framework
Yes
Yes
None
None

We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.