#Create new database in navicat premium how to

Most organizations maintain model diagrams of their databases.

A popup menu will appear asking you whether to copy over the Structure and Data or the Structure only: To copy over the table structures without data, simply select all of the tables in the Objects pane and drag them over to the new DB. Hint: if you aren't sure what Character Set and Collation to use, you can open the Edit Database dialog on the source DB to see their values. Enter the database properties in the pop-up window:.In the Navigation pane, right-click your connection and select New Database:.Rather than copy the database, we can create a brand new one and then generate the test data for it. There are several ways to do it here are a couple: Create a New Database There is usually more than one way to accomplish a task in Navicat.

For the purposes of this tutorial, we'll use an instance of the MySQL classicmodels Sample Database as the source that is the basis for our test database. Duplicating a Production Databaseįor optimal testing, the best approach is to duplicate the structure of your production databases (DBs), while replacing the 'real' data with sanitized test values. In today's follow-up, we'll go through the process of creating a MySQL test database - all using Navicat 16. It can help produce a large volume of complex testing data over multiple related tables, all guided by a multi-step wizard.

#Create new database in navicat premium how to

Recently, we learned how to generate test data using Navicat 16's new Data Generation tool. Creating a Test Database with Navicat 16 by Robert Gravelle