For other common FAQs, please refer to Navicat Technical FAQs.

Pre-Sales ›

• What is Navicat ID?
• What is Navicat Customer Center?
• What is the difference between Software Maintenance and Upgrade License?
• If I can't purchase via Braintree, what can I do?
• How can I place an order?
• What is Non-commercial License?

See all 20 articles

Maintenance ›

• What is Software Maintenance?
• How to Purchase Navicat Software Maintenance?
• Why should I subscribe the Software Maintenance Plan?
• What's included in the Maintenance Plan?
• How can I check the expiry date of my Maintenance Plan?
• How can I renew my Software Maintenance Plan?

See all 10 articles

Order ›

• Can I enter different billing and delivery addresses?
• What will happen after I place my order online?
• Can I use my free e-mail address?

Upgrade/Retrieve ›

• If I lost my password/registered email, what can I do?
• What is the Password for existing customer?
• How to retrieve my license key?
• Can I purchase upgrade license for Navicat Essentials?

Delivery ›

• What exactly will I receive if the product is delivered by e-mail?
• When will I receive my Backup CD?
• When will I receive my product to be delivered by e-mail?
• When will I receive my product to be delivered by postal mail or parcel service?

Billing ›

• How will I receive my invoice?
• I did not receive the key file even though my credit card was billed, can you resend it?
• What is your Upgrade Policy?

License ›

• Where can I purchase Navicat iOS?
• Can I deploy one license for both Desktop and Laptop?
• Can I transfer my Navicat license to a different platform?
• How long does my license last?
• What is Navicat Lite?
• Can I upgrade from Standard Version to Enterprise Version?

See all 14 articles

Data protection and data security ›

• How secure is the order process?
• Will my personal data be passed on to third parties?
• I interrupted my online order - has my data been saved?

For other common FAQs, please refer to Navicat Technical FAQs.

Installation ›

• Can I run Navicat on 64-bit Windows?
• Can I install Navicat in a silent installation mode?
• How to get the connection information when migrating Navicat to new computer?
• Can I run Navicat on 64-bit Linux?
• How can I install Navicat in Linux?
• I realize that Navicat has been applied WINE rather than actually creating a Linux/Gnome version. Is that truth?

Security ›

• How secure is Navicat?

Connection ›

• Does Navicat support forks of MySQL?
• Does Navicat support Google Cloud SQL?
• Does Navicat support Amazon Redshift?
• Does Navicat support Amazon RDS for MySQL, PostgreSQL, SQL Server, Oracle and MariaDB?
• Does Navicat support Amazon Aurora?
• How can I connect Oracle 8i using Navicat Mac version 11?

See all 21 articles

Database / Schema ›

• What SQLite database encryption method does Navicat support?

Table ›

• How can I do Find and Replace in Navicat?
• Why does Navicat only display MEMO/TEXT in data grid? How can I see the actual text?
• Why I cannot successfully create the foreign keys?
• Is there a way that I can get the table names to be saved in the case that I enter them in?
• How do I insert pictures into my table?
• Can I copy a table by Drag and Drop?

See all 21 articles

View ›

• Why all the format of the Views disappear after Run or Save the Views?

Function / Procedure ›

• How can I create function or procedure / input values with more than one input parameter?
• How can I use wizard in creating function/procedure?
• Why my MySQL Server crashes after saving a blank Stored Procedure?

Query ›

• Does Navicat support running multiple query statements?
• Can I add comments to the Queries?
• Can I directly edit the data from a result of a query?
• Can I do a Union query in Navicat?
• Can I stop a query which is running?
• Return large query result sets

See all 7 articles

Data Modeling ›

• What are the differences between Model tab and Diagram tab in the left pane?
• How many Diagram Notation Navicat provided?
• Does Navicat support forward/reverse engineering?
• Is the Synchronize feature in model a two-way process?
• How can I synchronize a model to different server types?
• How do we design table without using table designer?

See all 8 articles

Import Wizard ›

• When I try to import xlsx and accdb files, I get "Cannot Open xxx files" and "Invalid Variant operation" errors. How to solve it?
• I received "Cannot open this file for writing" error when importing. Why?
• How can I import data into a new table?
• How can I import data into an existing table?
• Why my Import Wizard jumps from Step 2 to Step 5 to Step 8? Where are Step 3 and 4?
• The Import Wizard (on step 7) doesn't allow anything but replacing or inserting data, why?

See all 14 articles

Export Wizard ›

• What is the difference between Excel Spreadsheet & Excel File during export?
• How to export filtered records after applying Filter Wizard on a table?
• Can I export query results and set schedule?
• Export Formats available
• I got this error "Invalid variant type conversion" when I was trying to export a MySQL table into MS Access format. Why is this?

Data Transfer ›

• Can I transfer my table/data to my remote Server?
• Can I specify the location of the Data Transfer Log file?

Data & Structure Synchronization ›

• How can I set the Data Synchronization as two-way process?

Backup & Restore ›

• How to backup particular database objects instead of the whole database?
• How to backup the database structure only?
• I cannot backup one of the databases among the others
• I received an error 'Finished Unsuccessfully - Failure Opening File'
• Why there is hex code when I extracted the SQL from the backup file?
• Will Navicat lock tables during backup?

See all 9 articles

Schedule ›

• How can I add files to the batch job/schedule as attachment?
• Where to locate Data Synchronization and Data Transfer profiles when creating a batch job?
• Why my schedule does not work?
• Why the Set Task Schedule/Setup Schedule button does not work?
• I tried to set a schedule but received this error "An error has occurred while attempting to set task account information.".
• Batchjob xxx not found

See all 7 articles

Report ›

• How do I create Report?
• How can I create a report based on a query?
• Can I include procedures/functions into the Report Builder?
• Can I export my report to other formats e.g. HTML, Excel, Words?
• Where are the reports stored?
• Can I perform searching in reports?

See all 9 articles

Useful Tips ›

• How can I remote access Navicat from another Linux computer?
• How can I find the saved queries, reports and backups in Windows Vista?
• How do I import SQL file into the server?
• Can I keep track on my activity in Navicat?
• How can I stop a process which is running?
• How can I open a non-dockable window?

See all 20 articles

Navicat Commands ›

• Windows Commands
• Mac Commands
• Linux Commands

For other common FAQs, please refer to Navicat Technical FAQs.

Connection ›

• Why is my localhost connection failed after upgraded to Navicat 11 in Mac App Store?
• How to connect Oracle servers using TNS in Mac App Store version?
• Some old version files cannot be accessed (e.g. public key files) in Mac App Store version. How can I deal with it?
• I have setup some connections in Navicat 10 and the connections cannot be shown in Navicat 11 after upgraded through App Store. How can I do?

Schedule ›

• After I upgraded from Navicat 10 to Navicat 11 through App Store, my schedule is not running anymore. Why?

For other common FAQs, please refer to Navicat Technical FAQs.

Connection ›

• How to add SSH/SSL key files or certificate files to Navicat iOS?
• How to close, edit or delete the connection?
• Does Navicat iOS support Google Cloud SQL?
• Does Navicat iOS support Amazon Redshift?
• Does Navicat iOS support Amazon RDS for MySQL, PostgreSQL and MariaDB?
• Does Navicat iOS support Amazon Aurora?

See all 11 articles

Table ›

• How can I sort or filter data?
• How can I view/edit image data in the table?
• How to set the column width in the table grid?
• How do I insert pictures into my table?
• How can I set the number of records displayed per page in the Table view?
• How to view table structure of a table?

See all 11 articles

Query ›

• How can I change to use Query Builder when I construct query?
• Does Navicat support running multiple query statements?
• Can I add comments to the Queries?
• Can I do a Union query in Navicat?
• Return large query result sets
• Can I directly edit the data from a result of a query?

Useful Tips ›

• Can I see which connection and database I am currently working in?
• How can I monitor the processes which are running on the server?
• How can I stop a process which is running?
• What is MySQL's default DATE/DATETIME format?
• What is PostgreSQL's default Date/Time Type?

For other common FAQs, please refer to Navicat Technical FAQs.

Installation ›

• Can I run Data Modeler on 64-bit Windows?

Connection ›

• Can I import existing Navicat (e.g. Navicat Premium) connection settings to Navicat Data Modeler?

Diagram Canvas ›

• Does Navicat Data Modeler support views?
• Why I receive "Diagram is not large enough to hold all objects" error when reducing the diagram dimension?
• How to change the diagram's database type in Data Modeler?
• How many Diagram Notation Modeler provided?
• Why some options is not disabled in the Modeler table designer?
• Does Navicat Data Modeler support multiple schemas in one model?

See all 7 articles

Reverse Engineering ›

• Why I receive "Auto layout dimension is too large" error when using Import from Database feature?
• How can I import tables from other data sources in Data Modeler (e.g. Access)?

Forward Engineering ›

• Can I generate a SQL file without defining the server type?
• Is the Synchronize feature in model a two-way process?
• How can I synchronize a model to different server types?
• What is the difference between synchronizing with selected schemas and tables?
• How can I synchronize new tables to existing connection?

Useful Tips ›

• What are the differences between Model tab and Diagram tab in the left pane?
• How do we design table without using table designer?
• How is the field prediction work?
• Can I hide toolbar in Data Modeler?
• Can I know what models opened in Data Modeler recently?

For other common FAQs, please refer to Navicat Technical FAQs.

Two-Step Verification ›

• How to enable Two-Step Verification?
• What Authenticator Apps do you support?
• What is a backup code?
• I lost my backup code, how do I revoke it?
• What do I do if I lost my phone or can't sign in using two-step verification?
• How do I disable two-step verification?

General ›

• What is Navicat Cloud?
• What is Navicat Cloud Portal?
• If I upgrade to Navicat v11.2, will my connection and other information automatically sync to Navicat Cloud?
• Can I share my project to a teammate who doesn’t have a Navicat ID?
• Why I can see _conflict followed by my object name?

Security and Privacy ›

• How secure is Navicat Cloud?
• I have a firewall list for my computer, how to setup Navicat Cloud?
• How can I sign out of all the sessions that are currently logged in?

Account Management ›

• Member roles overview.
• Can I change the project owner?
• How do I leave a project?
• Why can't I delete my project?

Space and Storage ›

• How much storage do I get from Navicat Cloud?
• Is there a limit or maximum to how big my query/model can be?
• Will my units are used if I join someone else's project?

For other common FAQs, please refer to Navicat Technical FAQs.

MySQL / MariaDB ›

• 1005 - Can't create table 'xxx' (errno: 150)
• 1006 - Can't create database xxx (errno. 13)
• 1026 - Error writing file '\WINNT\TEMP\xxx ' (errcode: 28)
• 1044/1045 - Access denied for user 'username'@'yourhost'...
• 1060 - Duplicate Column Name
• 1129 - Host 'host_name' is blocked because of many connection errors...

See all 14 articles

Oracle ›

• ORA-01031 insufficient privileges
• ORA-01045: user xxx lacks CREATE SESSION privilege; logon denied
• ORA-01536: space quota exceeded for tablespace xxx
• ORA-06413: Connection not open
• ORA-12737: Instant Client Light: unsupported server character set

PostgreSQL ›

• Password authentication failed for user xxx