Devart Blog

10 reasons to try database projects

Posted by on June 22nd, 2009

Why not distract your attention from usual database development and facilitate your work with projects?

Let’s inspect the reasons why you should:

  1. Database projects provide quick access to SQL scripts and database objects. You have logically organized scripts and query files in one place. 
  2. Database projects allow developing databases in offline mode within a fully customizable environment. 
  3. Database projects support Source Control usage, so database development can be shared between development team members. 
  4. Database projects can be built to different outputs (they are used to deploy all the project changes to a database on the server): a single ready-to-deploy script, a set of scripts with a batch to run it in the MySQL Command-Line Tool or in dbForge Studio, etc. You can adjust the output for your needs. 
  5. Database projects support different customizable configurations. Each of them can have the required connection and settings, so the next time you can use the required configuration and escape manual tuning of all the settings. 
  6. During building or comparison of a database project, the syntax and objects references are automatically validated in all the project’s files to ensure the correct result. 
  7. Database projects have an adjustable build order. The project can include all files of your solution and you can include only necessary files to the output in different configurations. 
  8. Database projects support convenient database deployment to the server. 
  9. Database projects can be compared with the required database directly to generate a synchronization script, using Schema Compare functionality.
  10. Database project is modern and dynamically developing technology. You have a chance to contribute to concept development.

Try a sample project that is distributed with the dbForge Studio for MySql Professional! You can find it in the “D:Documents and Settingsyour_login_nameMy DocumentsdbForge Studio for MySQLProjectsSakila”

 

 

Leave a Reply