Now you can set different connections for project configurations. These connections allow you to deploy the same database project to various servers. You get more freedom in handling the project. For example, you can test the project on one server and deploy the final version to another one.
Now when you apply the project changes to the server, you can deploy only the required ones without redeploying the whole database.
In prior versions the Generate DDL, Schema Export, New Project Wizard, Schema Synchronization wizards generated SQL scripts paying no attention to object dependencies. Now all objects in SQL scripts are generated based on object dependency sorting principle. For example, if View 1 refers to View 2, View 1 will come first or tables will follow those tables which refer to them.
This ensures that the generated SQL scripts will be executed without errors and you won’t loose your time for additional code editing.
SQL editor performance has been greatly increased due to optimized parsing of SQL scripts. You can open and edit large SQL scripts quicker. Moreover, to speed up your work, automatic switching off SQL editing features in large SQL scripts is implemented.
A sample database project, based on MySQL database Sakila, is added to the installation. Using the sample, even beginners will quickly get the idea and start working with projects successfully.