Navicat Technical FAQs (Desktop version)

Installation

• Can I install Navicat in a silent installation mode?
• How to get the connection information when migrating Navicat to new computer?
• How can I install Navicat on Linux?

Security

• How secure is Navicat?

Connection

• Does Navicat Window Version support ssh agent or Pageant?
• How can I open Oracle connections with Navicat Premium on Mac computers with Apple Silicon?
• Why I receive this error "Oracle library is not loaded" when connecting Oracle servers?
• How can I specify the port for SQL Server connection?
• How can I connect to a SQL Server Instance?
• How can I connect if my server installed ModSecurity?
See all 16 articles

Database and Schema

• Why don't I see any databases in my Redis server?
• How to add more databases to my Redis server?
• What SQLite database encryption method does Navicat support?

Table and Collection

• Why I cannot successfully create the foreign keys?
• Can I preserve the capitalization of the table name I enter?
• How can I insert images into my table or collection?
• Can I copy tables or collections by drag and drop?
• Why am I receiving a 'No Primary Key' warning when I open my table?
• How to set the number of records or documents displayed per page in Table or Collection Viewer?
See all 15 articles

View

• Why do all formats disappear after I run or save a view?

Function and Procedure

• Why can't I use the PostgreSQL PL/PGSQL Debugger?
• How can I enable or disable Function Wizard?
• Why my MySQL Server crashes after saving a blank Stored Procedure?

Query

• Can I execute multiple query statements in a single run?
• Can I include comments in the queries?
• Can I directly edit the data from a result of a query?
• How to backup or restore queries?

Model

• How can I show the comments for tables or fields in the diagram?
• How many diagram notations are available in Navicat?
• Does Navicat support forward and reverse engineering?
• How can I synchronize a model to different server types?
• How do we design table without using table designer?
• How is the field prediction work?
See all 7 articles

BI

• When I try to establish connection to Snowflake server in Navicat (App Store Version), I get an error message saying Snowflake ODBC Driver is required. What is that and what should I do?
• When I try to establish connection to Snowflake server in Navicat, I get an error message saying Snowflake ODBC Driver is required. What is that and what should I do?
• Where are the workspace files stored?
• What are the differences between archive and live data sources?
• Can I use custom query results as a data source?
• How can I customize the format of the datetime data displayed on a chart?

Import Wizard

• How do I enable all the import modes available in the Import Wizard?
• Why do my 'yes/no' fields get converted to tinyint when I import my MS Access database into Navicat?
• Will all my primary key and foreign key settings from Access migrate to the table after Import?
• Why could I not successfully import the XML file?
• Why do I receive the error message "List index out of bounds (0)" when importing an Access file?

Export Wizard

• What is the difference between Excel Spreadsheet and Excel File during export?
• How do I export filtered records after applying a filter to a table or collection?
• Can I set a schedule for exporting query results?

Data Transfer

• Can I specify which columns or data to transfer to the target?
• How can I prevent connection timeouts during the transfer of large tables?

Data Synchronization

• Can I check for data differences between the source and target during synchronization?
• How can I set the Data Synchronization as two-way process?

Backup and Restore

• How can I backup MongoDB database?
• How to backup particular database objects instead of the whole database?
• How to back up the database structure only?
• Why can't I back up one of my databases?
• Why is there hex code when I extract SQL from a backup file?
• Will Navicat lock tables during backup?
See all 9 articles

Automation

• How to automatically wake my PC from sleep and run a batch job?
• How can I add files to the batch job as attachment?
• Why doesn't my schedule work?
• Why doesn't the 'Set Task Schedule' button enable?
• Why do I receive the 'Batch job xxx not found' error?
• Does Navicat need to be running in order for schedule tasks to work?

Useful Tips

• Does Navicat support Dark theme?
• Is there a way to open favorite tabs or previous tabs automatically when Navicat launches?
• How do I import SQL files, script files or command files into the server?
• Can I keep track on my activities in Navicat?
• How can I stop a process which is running?
• How can I open a non-dockable window?
See all 15 articles