With Navicat Data Modeler, you can create models using existing tables or views in databases.
In this tutorial, we will show you how to import existing tables to create a model.
First, select "Import from Database" from the "File" menu. Click "New Connection" button to setup connections.
If you want to import tables through ODBC, you should download and install a suitable ODBC driver from the web and create a data source. Then, setup the connection here.
In addition, you can import connections that established in other Navicat software to Navicat Data Modeler. Choose "Import Connections from Navicat" and select connections to import.
Then, select a connection from the list. In the next step, choose the objects you want
With Navicat Data Modeler, you can create models using existing tables or views in databases.
In this tutorial, we will show you how to import existing tables to create a model.
Navicat Data Modeler allows you to send the diagram to your printer or output a PDF or an image file. This tutorial will show you how to print the diagram and change the page setup, diagram dimension, etc.
If the canvas doesn’t contain enough space to add other objects, you can set a larger Diagram Dimension. Control-click anywhere on the canvas and choose ‘Diagram Dimension’. In the popup window, edit the Height and Width of the diagram. Or, you can change the paper size of the canvas. Simply choose ’Page Setup’ from the ‘File’ menu and set a larger paper size.
Finally, you can choose ’Print’, ‘Print PDF’, ‘Print PNG’ or ‘Print SVG’ from the ‘File’ menu to print out the diagram.
Navicat Data Modeler allows you to send the diagram to your printer or output a PDF or an image file. This tutorial will show you how to print the diagram and change the page setup, diagram dimension, etc.
If the canvas doesn’t contain enough space to add other objects, you can set a larger Diagram Dimension. Right-click anywhere on the canvas and choose ‘Diagram Dimension’. In the popup window, edit the Height and Width of the diagram. Or, you can change the paper size of the canvas. Simply choose ’Page Setup’ from the ‘File’ menu and set a lager paper size.
Before printing, you can click ‘Print Preview’ to preview the diagram. In preview, you can press and hold down the ‘Shift’ key and click the page to jump to the corresponding page in canvas.
Finally, you can choose ’Print’ or ‘Print As’ from the ‘File’ menu to print out the diagram.
Starting from Navicat Data Modeler 2.0, you can use our Navicat Cloud service to synchronize models and virtual group information with different machines and platforms. You can access them anytime and anywhere.
You will need a Navicat ID to use this service. It is the email you use to login to Navicat Customer Center. If you do not have a Navicat ID, you can create a new one. Click “Create Navicat ID” and enter the required information. Then, click “Sign Up”. A verification email will send to your email address.
In this tutorial, I will show you how to synchronize model files between different platforms.
Navicat Data Modeler allows you to add layers, notes, labels, images and shapes to help organize objects and embellish the diagram. In this tutorial, I will show you how to make your diagram visually attractive and informative. First, open a model file in Navicat Data Modeler. In the model, you can click the ‘Auto Layout’ button to automatically arrange the objects in canvas.
Now, click the ‘Layer’ icon and add a new layer to the diagram. You can group the related objects into one layer. Resize the layer to fit the objects. And then, click the ‘Label’ icon to add a meaningful diagram title. You can also add a company logo to your diagram. Simply click the ‘Image’ icon and browse the image file. Also, you can add some shapes to the diagram. For example, lines, arrows, users, triggers, databases, etc.
Navicat Data Modeler allows you to add layers, notes, labels, images and shapes to help organize objects and embellish the diagram. In this tutorial, I will show you how to make your diagram visually attractive and informative.
First, open a model file in Navicat Data Modeler. In the model, you can click the ‘Auto Layout’ button to automatically arrange the objects in canvas.
Now, click the ‘Layer’ icon and add a new layer to the diagram. You can group the related objects into one layer. Resize the layer to fit the objects. And then, click the ‘Label’ icon to add a meaningful diagram title. You can also add a company logo to your diagram. Simply click the ‘Image’ icon and browse the image file. Also, you can add some shapes to the diagram. For example, lines, arrows, users, triggers, databases, etc.
With Navicat Data Modeler, you can synchronize tables and views from a physical model to a database or export them to a script file.
In this tutorial, we will show you both ways to transfer model objects.
Assume we have imported some tables and views from a PostgreSQL schema into a physical model, made a few changes and added a new table.
Then we will transfer the model into a MySQL database. To change server type of a model, select "Model Conversion" from the "File" menu and choose the desired database type and version. Navicat Data Modeler will convert fields to relevant field types, according to the server type. You may need to change the SQL syntax of the views after the conversion.
With Navicat Data Modeler, you can synchronize tables and views from a physical model to a database or export them to a script file.
In this tutorial, we will show you both ways to transfer model objects.
Assume we have imported some tables and views from a PostgreSQL schema into a physical model, made a few changes and added a new table.
Then we will transfer the model into a MySQL database. To change server type of a model, select "Model Conversion" from the "File" menu and choose the desired database type and version. Navicat Data Modeler will convert fields to relevant field types, according to the server type. You may need to change the SQL syntax of the views after the conversion.
Navicat Data Modeler supports a simple and cosy way to add tables or entities in physical and logical models. One great feature is field type prediction. It reduces the amount of time spent on design. In this tutorial, I will show you how to design a table without opening the table designer and how the field type prediction works.
Navicat Data Modeler supports a simple and cosy way to add tables or entities in physical and logical models. One great feature is field type prediction. It reduces the amount of time spent on design. In this tutorial, I will show you how to design a table without opening the table designer and how the field type prediction works.
First, open a physical model in Navicat Data Modeler. In the model, click the ‘Table’ icon to add a new table to the diagram. You can simply edit the table name here. Then, press either the ‘Tab’ or ‘Down Arrow’ key. Now, you can start to enter the field name. Navicat Data Modeler will predict field types based on the field names entered. For example, if you enter ‘id’, it predicts as a primary key and sets to ‘int’. If a name contains ‘date’, it sets to ‘datetime’ type. Or, you can simply enter an ‘asterisk’ before the field name to recognize as a primary key and enter a ‘colon’ after the field name to customize the field type.
Navicat allows you to share models in a project to other Navicat ID accounts. In this tutorial, I will show you how to add members to a project and how the members can work together using Navicat Cloud Collaboration.
Navicat allows logical grouping of connections, tables, views, functions, events, queries, backups, schedules, etc, by using the “Virtual Grouping” feature. In this tutorial, we will show you how to use virtual grouping to manage your database objects logically.
To create a new group, control-click and select “New Group” from the “Manage Group” option, and then give a group name. If you can't see connection groups, you can uncheck the “Flatten Connection” option in “View” from the main menu. Alternatively, if you can't see object groups, you can uncheck the “Flatten Object List” option in “View” from the main menu.
To move an object into a group, control-click the object and select “Add to Group” from the “Manage Group” option, then select the target group. On the other hand, control-click the object and select “Remove From Group” from the “Manage Group” option to move the object out of the group.
Navicat allows logical grouping of connections, tables, views, functions, events, queries, backups, schedules, etc, by using the “Virtual Grouping” feature. In this tutorial, we will show you how to use virtual grouping to manage your database objects logically.
If you cannot see or add object groups, you can uncheck the “Flatten Object List” option in “View” from the main menu. Alternatively, if you cannot see or add connection groups, you can uncheck the “Flatten Connection” option in “View” from the main menu.
To create a new group, right-click and select “New Group”, and then give a group name. To move an object into a group, right-click the object and select “Move To” from the “Manage Group” option and select the target group. On the other hand, right-click the object and select “Exclude from Group” from the “Manage Group” option to move an object out of the group.
History Log
The QueryExec.log file in Navicat stores all SQL statements of all operations executed over databases and database objects. To open the log, simply press Cmd-L.
Finding Records
You can find records in a table by pressing Cmd-F and entering a search keyword to perform the search.
Allow Navicat Multiple Instances
You can open multiple Windows for your Navicat. Choose “Preferences” from Navicat Premium menu, and then check the “Allow opening multiple instances” option under the “General” tab.
7. Set variable - Server Monitor
You can edit values for the variables in MySQL and Oracle servers directly in Navicat. To do so, select “Server Monitor” for your target server from the “Tools” menu. Under the “Variables” tab, click the button next to the value to open it for editing.
Table shortcut
You can open a table faster by simply dragging and dropping the table from Navicat to the desired location.
1.You can open the “Settings Location” folder easily in Navicat. Windows Explorer window will open by selecting the target connection and pressing Ctrl+G.
2. History Log
The LogHistory.txt file in Navicat stores all SQL statements of all operations executed over databases and database objects. To open the log, simply press Ctrl+H. Please note that the log will be overwritten when Navicat restarts.
3. New query
When you open a database, you can open a query editor in Navicat directly by pressing Ctrl+Q to build your own queries.
4. Finding Records
You can find records in a table by pressing Ctrl+F and entering a search keyword to perform the search.
5. Allow Navicat Multiple Instances
You can open multiple Windows for your Navicat. Choose “Options” from the “Tools” menu, then check “Allow Multiple Form Instances” and “Allow Multiple Navicat Instances” under the “General” option.
Our Navicat Cloud service allows you to synchronize connection settings, queries, models and virtual group information with different machines and platforms.
In this tutorial, I will show you how to synchronize connection settings and queries between Navicat Windows version and Mac version.
First, in Windows version of Navicat, log in to the Navicat Cloud service. Create a connection in Navicat Cloud. Double-click to open it. Then, click new query to write a query and save it.
After that, switch to Mac version and log in to Navicat Cloud with the same Navicat ID. Then, you can see the connection that you synchronized to cloud. Open the connection and the query is there. Now, we can continue to work on the query.
Navicat supports connection to SQL Azure, a cloud-based relational database server built on SQL Server technologies.
In order to begin using your SQL Azure server, you must create server administration credentials and specify one or more firewall rules that enable access to your SQL Azure server.
Similar to the settings for a SQL Server connection, in Navicat, click the “Connection” and select “SQL Server” to start a new connection. Enter the domain name of your SQL Azure server in the Host Name/IP Address field. Each SQL Azure server has a fully qualified unique domain name such as “servername.database.windows.net”. The “servername” refers to the name of your SQL Azure server.
Finally, click 'Test Connection' to check the connection and click 'OK' to save the connection settings.
Navicat supports connection to SQL Azure, a cloud-based relational database server built on SQL Server technologies.
In order to begin using your SQL Azure server, you must create server administration credentials and specify one or more firewall rules that enable access to your SQL Azure server.
Similar to the settings for a SQL Server connection, in Navicat, click the “Connection” and select “SQL Server” to start a new connection. Enter the domain name of your SQL Azure server in the Host Name/IP Address field. Each SQL Azure server has a fully qualified unique domain name such as “servername.database.windows.net”. The “servername” refers to the name of your SQL Azure server.
Finally, click 'Test Connection' to check the connection and click 'OK' to save the connection settings.
A special feature of Navicat Batch Job is to be able to send exported files with notification emails. In this tutorial, we will send attachments for exporting files.
First, click the “Schedule” button to open the schedule panel. Then, click “New Batch Job” to open the batch job design window. To select jobs, simply double-click the jobs from the “Available Jobs” list in the “General” tab.
Next, select the “Advanced” tab and enable the “Send email” option. Specify the sender, the recipients’ email, and the SMTP server. If your SMTP server requires authentication to send emails, you need to check the “Use Authentication” option and fill in the log-in information. Check the “With Attachment(s)” option.
A special feature of Navicat Batch Job is the ability to send exported files and print reports with notification emails. In this tutorial, we will send attachments for both exporting files and report printing.
Navicat Report Builder allows you to set search criteria in your reports. In this tutorial, we will create a search report to filter the report data.
First, open an existing report in design view and go to the “Data” tab. Click on the “Search” icon of the data pipeline to launch the “Query Designer”. Under the “Search” tab, drag the field which you would like to set search criteria on and select the operator.
You can click on the “AutoSearch” option if you would like to set up search fields so that the users who open the report can enter their own search values. Another option is to fill in a value if you would like to set it as the default. For example, here we will enable the “AutoSearch” option.
Now, click the “Preview” tab to view the report. A “Search Data” icon will appear if the “AutoSearch” option has been enabled. Click the “Search Data” icon and a search window will pop-up for entering search criteria. Finally, click OK to show the result.
Navicat not only allows you to create reports, but also allows you to print reports in other file formats such as PDF, HTML, etc. In this tutorial, we will export a report file in the PDF format.
First, select the report and choose “Design Report”. Under the “Design” tab, enable the “Allow Print to File” option in report properties. It will enable the “Print To File” option in the printing dialogue.
Then, you can choose “Print” in the “File” option from the main menu. In the Print dialogue, check the “Print to File” option and select the type of file output. Then, click on this button to locate the path and enter the file name. Finally, click OK to print out the file.
A simpler way to print the reports is to right-click the report in the Navicat main window and choose “Print Report As”.
Starting from Navicat 11.1, you can use our Navicat Cloud service to synchronize connection settings, queries, models and virtual group information with different machines and platforms. You can access them anytime and anywhere.
To start using Navicat Cloud, click “Sign In” in the main window. You will need a Navicat ID to use this service. It is the same email you use for login to Navicat Customer Center. If you do not have a Navicat ID, you can create a new one. Click “Create Navicat ID” and enter the required information. Then, click “Sign Up”. A verification email will send to your email address.
After sign in to Navicat Cloud, the connection pane is split into 2 parts: Navicat Cloud and My Connections.
Starting from Navicat 11.1, you can use our Navicat Cloud service to synchronize connection settings, queries, models and virtual group information with different machines and platforms. You can access them anytime and anywhere.
Navicat allows you to send the diagram to your printer or output a PDF or image file. This tutorial will show you how to print the diagram and change the page setup, diagram dimension, etc.
If the canvas doesn’t contain enough space to add other objects, you can set a larger Diagram Dimension. Control-click anywhere on the canvas and choose ‘Diagram Dimension’. In the popup window, edit the Height and the Width of the diagram. Or, you can change the paper size of the canvas. Simply choose ’Page Setup’ from the ‘File’ menu and set a larger paper size.
Finally, you can choose ’Print’, ‘Print PDF’, ‘Print PNG’ or ‘Print SVG’ from the ‘File’ menu to print the diagram.
Navicat allows you to send the diagram to your printer or output a PDF or image file. This tutorial will show you how to print the diagram and change the page setup, diagram dimension, etc.
If the canvas doesn’t contain enough space to add other objects, you can set a larger Diagram Dimension. Right-click anywhere on the canvas and choose ‘Diagram Dimensions’. In the popup window, edit the Height and the Width of the diagram. Or, you can change the paper size of the canvas. Simply choose ’Page Setup’ from the ‘File’ menu and set a larger paper size.
Before printing, you can click ‘Print Preview’ to preview the diagram. In preview, you can press and hold the Shift key and click the page to jump to the corresponding page in canvas.
Finally, you can choose ’Print’ or ‘Print As’ from the ‘File’ menu to print the diagram.
Model allows you to add layers, notes, labels, images and shapes to help organize objects and embellish the diagram. In this tutorial, I will show you how to make your diagram visually attractive and informative.
First, open a model file in Navicat. In the model, you can click the ‘Auto Layout’ button to automatically arrange the objects in canvas.
Then, click the ‘New Layer’ icon and add a new layer to the diagram. You can group the related objects into one layer. Resize the layer to fit the objects. Then, click the ‘New Label’ icon to add a meaningful diagram title. You can add a company logo to your diagram. Simply click the ‘New Image’ icon and browse the image file. Also, you can add some shapes to the diagram. For example, lines, arrows, users, triggers, databases, etc.
Last, you can change the diagram notation according to your needs. Simply control-click anywhere on the canvas and choose ‘Diagram Notation’. Select the desired notation from the popup.
Model allows you to add layers, notes, labels, images and shapes to help organize objects and embellish the diagram. In this tutorial, I will show you how to make your diagram visually attractive and informative.
First, open a model file in Navicat. In the model, you can click the ‘Auto Layout’ button to automatically arrange the objects in canvas.
Then, click the ‘Layer’ icon and add a new layer to the diagram. You can group the related objects into one layer. Resize the layer to fit the objects. Then, click the ‘Label’ icon to add a meaningful diagram title. You can add a company logo to your diagram. Simply click the ‘Image’ icon and browse the image file. Also, you can add some shapes to the diagram. For example, lines, arrows, users, triggers, databases, etc.
Last, you can change the diagram notation according to your needs. Right-click anywhere on the canvas and choose ‘Diagram Notation’. Select the desired notation from the popup.
Navicat supports a simple and cosy way to add table in Model. One great feature is field type predication. It reduces the amount of time spent on table design. In this tutorial, I will show you how to design a table without opening the table designer and how the field type predication works.
Navicat supports a simple and cosy way to add table in Model. One great feature is field type predication. It reduces the amount of time spent on table design. In this tutorial, I will show you how to design a table without opening the table designer and how the field type predication works.
Mailing labels, name labels, and other useful labels can be created easily with Navicat. In this tutorial, we will create mailing labels with data from a MySQL server.
Navicat allows you to set the number of records shown on each page of the table viewer. In this tutorial, we will show you how to set the Limit Record Settings for an individual table and for all tables.
First, open the table to set the record limit for that table. Click the “Limit Record Settings” button and input the number of records allowed to be displayed in each page and press Enter. By default, it is set to 1000. After that, you can click the “Next Page” button to show the next page of records.
To set the Limit Record Settings globally, simply select “Preferences” from Navicat’s main menu. In “Preferences”, select the “Grids” tab. Then, enable the “Limit records” option and enter the number of records per page value. For our example, we will enter 3 as the value. Now, open a table and it will show only 3 records per page. Please note that global settings will not affect tables with individual Limit Record Settings.
Navicat allows you to set the number of records shown on each page of the table viewer. In this tutorial, we will show you how to set the Limit Record Settings for an individual table and for all tables.
First, open the table to set the record limit for that table. Click the “Limit Record Settings” button and input the number of records allowed to be displayed in each page and press Enter. By default, it is set to 1000. After that, you can click the “Next Page” button to show the next page of records.
To set the Limit Record Settings globally, simply select “Options” from the “Tools” menu. In the “Options” form, select the “Data & Grid” section. Then, enable the “Limit Records” option and enter the number of records per page value. For our example, we will enter 3 as the value. Now, open a table and it will show only 3 records per page. Please note that global settings will not affect tables with individual Limit Record Settings.
Navicat supports the importing of data from ODBC data source. In this tutorial, we will show you how to set up an ODBC data source connection and import MSSQL data to a MySQL database using Navicat.
You should download and install a suitable ODBC driver from the web.
First, start the Import Wizard in Navicat and select “ODBC” as the import type.
Now, set the connection, username, and password to connect the server.
If the connection was successful, you can see all available tables in the list. Now simply select the tables you wish to import.
After that, you can continue the wizard and click the “Start” button to finish.
You can now open the imported table in Navicat.
Navicat supports the importing of data from ODBC data source. In this tutorial, we will show you how to set up an ODBC data source connection and import MSSQL data to a MySQL database using Navicat.
Navicat provides a user-friendly way to import fixed length data.
In this tutorial, we will show you how to import a text file with fixed length data.
To begin, start an import wizard in Navicat and select the source text file.
You will need to define the data delimiter in step 3.
Select the “Fixed Width” option and you can preview data in the wizard immediately.
Then, you can delimit the source column bounds on the wizard directly. Click on the desired position to create a break line on it.
To move the break line to your preferred location, you can simply drag the break line.
Or, you can just double-click the break line to have it removed.
After that, you can continue with the wizard and click the “Start” button in the last step.
Now, you can open the imported table in Navicat.
Navicat supports cross platform import and export connection settings. In this tutorial, we will show you how to export connection settings from the Mac version of Navicat, and then import these settings into the Windows version.
First, in the Mac version of Navicat, control-click the connection pane and choose “Export Connections”. Select the connection and click OK. Choose the export path.
Afterwards, copy the exported file to the machine with the Windows operating system. Now, in the Windows version of Navicat, choose “Import Connections” from the “File” menu and select the settings file. The connections will then be imported.
Before opening the connection, we can change the connection’s “Settings Location” to a desired location.
Navicat provides an easy way to import and export binary data. The BLOB Editor allows viewing, updating, inserting or deleting BLOB field data in the table. In this tutorial, we will show you how to perform these tasks.
First, open the table. If the images do not show up in the table grid, you can check the “Show Image in Grid” option from the “Edit” menu. Then, select the BLOB field in the table and click the “Image” icon to open the editor at the bottom.
To import an image file to the table, just click the “Load” button and locate the image file path. If you want to export the BLOB field data to an image file, simply click the “Save to disk” button and specify the export path. Last, you can click the “Clear” button to remove the data from the table.
Navicat provides an easy way to import and export binary data. The “BLOB Editor” allows viewing, updating, inserting or deleting BLOB field data in the table. In this tutorial, we will show you how to perform these tasks.
First, open the table. If the images do not show up in the table grid, you can check the “Show Image in Grid” option from the “View” menu. Then, select the BLOB field in the table and click the “Image” icon to open the editor at the bottom.
To import an image file to the table, just click the “Load” button and locate the image file path. If you want to export the BLOB field data to an image file, simply click the “Save to disk” button and specify the export path. Last, you can click the “Clear” button to remove the data from the table.
Mac (FileZilla)
In this tutorial, we will employ FileZilla to upload the php script file and establish a connection to a MySQL server using HTTP tunnel in Navicat.
First, startup FileZilla, then enter the FTP server information and connect to the server. You can extract the php script file in Navicat. Control-click the ntunnel_mysql.php on the local system and choose Upload. Then, check to see whether or not the file was uploaded successfully.
Windows (FileZilla)
In this tutorial, we will employ FileZilla to upload the php script file and establish a connection to a MySQL server using HTTP tunnel in Navicat.
First, startup FileZilla, then enter the FTP server information and connect to the server. The php script file is available in the Navicat installation folder. Right-click the ntunnel_mysql.php on the local system and choose Upload. Then, check to see whether or not the file was uploaded successfully.
Foreign Key Data Selection is a useful tool that allows you to easily get the foreign key value from the reference table. It significantly reduces the time that would take to look for available values from the master table.
In this tutorial, we will show you how to employ this feature.
Navicat offers searching data within a database or schema.
In an opened database or schema, control-click and select “Find in Database” or “Find in Schema” option.
Enter the search keyword, choose the search criteria and click the “Find” button.
Results will be displayed at the bottom area.
Double-click a table or view to open and view the matched records.
Navicat offers searching data or structure within a database or schema.
To do this, select “Find in Database/Schema” from “Tools” menu.
Choose the target connection, database or schema. Then, enter the search keyword, choose the search criteria and click the “Find” button.
Double-click an object to open and view the matched records or structure.
Navicat simplifies the data manipulation process. In this tutorial, we will show you how to modify data easily.
You can replace data by the Find and Replace feature. To do this, select “Find and Replace” from “Edit” in menu. Then, enter keywords to find and replace in the text boxes respectively. You can first look for the desired cells before replacing data directly.
Navicat simplifies the data manipulation process with just a few clicks. In this tutorial, we will show you how to modify data in multiple cells easily.
To select a range of cells, now you can directly drag on the first cell, and drop to the target cell.
Moreover, you can directly edit data in multiple cells. To do this, enter a new value directly in the highlighted cells. To save the changes, click the bottom toolbar or move to another row.
Besides this, you can update the data by the Find and Replace feature. To do this, select “Replace” from “Edit” in menu. Then, enter keywords to find and replace in the text boxes respectively. You can first look for the desired cells before replacing data directly.
It is hard to find something you want when you have lots of connections and objects. Starting from version 11, Navicat provides tree filter for searching objects. In this tutorial, I’ll show you how this works.
Simply enter a search string. Navicat will immediately filter the connections. If connections, databases or schemas are opened, it will also filter their objects.
This filter can apply on all tree-structure lists in Navicat. For example: data transfer, query builder and schedule. Now, you can see how easy it is to find objects in Navicat.
In step 1, you can select the file type of the text file.
In the next step, check the tables that you want to export. Set the same export location and file name for them. In step 3, select the table fields to be exported. By default, all the fields in the list are selected. Select the “Append on output file(s)” option in step 4 to append the records in the output file. Then, click the “Start” button in the last step. Messages will follow to display the success or failure of the process. Finally, click the “Save” button to save the export wizard profile and close the window when the process is completed.
In step 1, you can select the file type of the text file.In the next step, check the tables that you want to export and select the “Export selected to same file” option from the “Select All” button’s dropdown list. Choose the export location and enter the file name in the “Save As” dialog. In step 3, select the table fields to be exported. By default, all the fields in the list are selected. Select the “Append” option in step 4 to append the records in the output file. Then, click the “Start” button in the last step. Messages will follow to display the success or failure of the process. Finally, click the “Save” button to save the export wizard profile and close the window when the process is completed.