1
Table of Contents
Chapter 1 - Introduction 7
About Navicat 7
Installation 9
End-User License Agreement 10
Chapter 2 - User Interface 16
Main Window 16
Navigation Pane 17
Object Pane 18
Information Pane 20
Chapter 3 - Navicat Cloud 21
About Navicat Cloud 21
Manage Navicat Cloud 22
Chapter 4 - Connection 25
About Connection 25
General Settings 26
RDBMS 26
MongoDB 27
SSL Settings 28
SSH Settings 30
HTTP Settings 31
Advanced Settings 32
Databases / Attached Databases Settings 34
Chapter 5 - Server Objects 36
About Server Objects 36
MySQL / MariaDB 36
Databases 36
Tables 36
Views 37
Procedures / Functions 38
Events 38
Maintain Objects 39
Oracle 39
Schemas 39
Tables 39
Views 40
Materialized Views 41
Procedures / Functions 41
Packages 42
Recycle Bin 43
Other Objects 44
2
Maintain Objects 44
PostgreSQL 46
Databases & Schemas 46
Tables 47
Views 48
Materialized Views 48
Functions 49
Types 50
Foreign Servers 50
Other Objects 51
Maintain Objects 51
SQLite 51
Databases 51
Tables 52
Views 52
Other Objects 53
Maintain Objects 53
MongoDB 54
Databases 54
Collections 54
Views 54
Functions 55
Indexes 55
MapReduce 55
GridFS 56
Maintain Objects 57
Chapter 6 - Data Viewer 58
About Data Viewer 58
RDBMS 58
RDBMS Data Viewer 58
Use Navigation Bar 58
Edit Records 59
Sort / Find / Replace Records 64
Filter Records 66
Manipulate Raw Data 67
Format Data View 67
MongoDB 69
MongoDB Data Viewer 69
Use Navigation Bar 69
Grid View 70
Tree View 76
JSON View 78
3
Sort / Find / Replace Documents 78
Assistant Editors 81
Filter Wizard 82
Chapter 7 - Query 85
About Query 85
RDBMS 86
SQL Editor 86
SQL Builder (Available only in Non-Essentials Edition) 90
Query Parameters 92
Debug Oracle Query (Available only in Non-Essentials Edition) 92
Query Results 92
MongoDB 93
Script Editor 93
Find Builder (Available only in Non-Essentials Edition) 97
Aggregate Builder (Available only in Non-Essentials Edition) 98
Query Results 98
Code Snippets (Available only in Non-Essentials Edition) 99
Chapter 8 - Model (Available only in Navicat Premium and Enterprise Edition) 101
About Model 101
Model Window 101
Build Diagram 104
Add Tables 104
Add Views 104
Add Foreign Keys 105
Add Labels 106
Add Notes 106
Add Images 106
Add Shapes 107
Add Layers 108
Work with Diagram Canvas 108
Reverse Engineering 109
Forward Engineering 110
Synchronize to Database 110
Export SQL 113
Model Conversion 115
Preview and Print Model 115
Model Hints and Tips 115
Chapter 9 - Debugger (Available only in Non-Essentials Edition) 118
About Debugger 118
Oracle PL/SQL Debugger 118
PostgreSQL PL/pgSQL Debugger 119
Chapter 10 - Data Migration Tools 122
4
About Data Migration Tools 122
Import Wizard 122
About Import Wizard 122
Choose File Format 122
Choose Source File 122
Choose Delimiter - TXT, CSV, XML 122
Choose Additional Options - TXT, CSV, XML 123
Choose Target Table / Collection 124
Adjust Field Structures and Map Fields 124
Choose Import Mode 125
Save and Start Import 126
Export Wizard 127
About Export Wizard 127
Choose File Format 127
Choose Saving Path 127
Choose Columns / Fields for Export 128
Choose Additional Options 128
Save and Start Export 129
Data Transfer (Available only in Non-Essentials Edition) 130
About Data Transfer 130
Choose Connections & Advanced Options (Step 1) 130
Choose Objects & Start Data Transfer (Step 2) 133
Data Synchronization (Available only in Non-Essentials Edition) 134
About Data Synchronization 134
Choose Connections & Comparing Options (Step 1) 134
Choose Table / Collection Mapping (Step 2) 135
View Data Comparison Results (Step 3) 135
Edit & Execute Selected Scripts (Step 4) 136
Structure Synchronization (Available only in Non-Essentials Edition) 137
About Structure Synchronization 137
Choose Connections & Comparing Options (Step 1) 137
View Structure Comparison Results (Step 2) 139
Edit & Execute Selected Scripts (Step 3) 140
Dump & Execute SQL / Script File 141
Chapter 11 - Automation (Available only in Non-Essentials Edition) 142
About Automation 142
Create Batch Job (Step 1) 142
Schedule Batch Job (Step 2) 144
Chapter 12 - Backup & Restore 145
About Backup & Restore 145
Built-in Backup & Restore Tool (Available only in Non-Essentials Edition) 145
About Built-in Backup & Restore Tool 145