Manipulate Raw Data 90 Format Data View 91 View Field Comments 92 MongoDB 93 MongoDB Data Viewer 93 Use Navigation Bar 93 Grid View 94 Tree View 100 JSON View 102 Sort / Find / Replace Connections & Comparing Options (Step 1) 180 Choose Table / Collection Mapping (Step 2) 181 View Data Comparison Results (Step 3) 181 Edit & Execute Selected Scripts (Step 4) 182 Structure 183 About Structure Synchronization 183 Choose Connections & Comparing Options (Step 1) 183 View Structure Comparison Results (Step 2) 185 6 Edit & Execute Selected Scripts (Step 3) 187

Manipulate Raw Data 89 Format Data View 89 View Field Comments 90 MongoDB 90 MongoDB Data Viewer 90 Use Navigation Bar 91 Grid View 92 Tree View 97 JSON View 99 Sort / Find / Replace Documents Connections & Comparing Options (Step 1) 175 Choose Table / Collection Mapping (Step 2) 175 View Data Comparison Results (Step 3) 175 Edit & Execute Selected Scripts (Step 4) 176 Structure 177 About Structure Synchronization 177 Choose Connections & Comparing Options (Step 1) 178 View Structure Comparison Results (Step 2) 180 6 Edit & Execute Selected Scripts (Step 3) 181

Manipulate Raw Data 89 Format Data View 89 View Field Comments 91 MongoDB 91 MongoDB Data Viewer 91 Use Navigation Bar 92 Grid View 93 Tree View 98 JSON View 100 Sort / Find / Replace Connections & Comparing Options (Step 1) 179 Choose Table / Collection Mapping (Step 2) 180 View Data Comparison Results (Step 3) 180 Edit & Execute Selected Scripts (Step 4) 181 Structure 182 About Structure Synchronization 182 Choose Connections & Comparing Options (Step 1) 182 View Structure Comparison Results (Step 2) 184 6 Edit & Execute Selected Scripts (Step 3) 186

28 Add Views 30 Add Views to Physical Model 30 Work with View Builder (Available only in Non-Essentials Version) 31 Edit View's Definition 37 Add Foreign Keys to Physical Model 40 Chapter files, or model files in Navicat Cloud / On-Prem Server. If the Navigation pane is hidden, choose View -> Show Navigation Pane from the menu bar. Content Pane The Content pane contains the models are in the selected section of the Navigation pane. Use the Detail or Icon buttons to change the view. Information Pane The General tab shows the general information of the model or the selected

28 Add Views 30 Add Views to Physical Model 30 Work with View Builder (Available only in Non-Essentials Version) 31 Edit View's Definition 37 Add Foreign Keys to Physical Model 40 Chapter files, or model files in Navicat Cloud / On-Prem Server. If the Navigation pane is hidden, choose View -> Show Navigation Pane from the menu bar. Content Pane The Content pane contains the models in the selected section of the Navigation pane. Use the Detail or Icon buttons to change the view. Information Pane The General tab shows the general information of the model or the selected

27 View Usage 28 Change Navicat Cloud Plan 28 Navicat On-Prem Server 29 Manage Account Information 29 Change / Reset Password 30 Enable / Disable Two-Step Verification 30 View Usage Set Up Notifications 40 Chapter 6 - Projects 43 Work with Projects 43 Manage Members 44 View Project Details 45 Chapter 7 - Navicat Objects 48 Connections 48 Queries 48 Models 48 - SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, CREATE VIEW on all database objects PostgreSQL - Can login, Can create database and Superuser SQL Server -

43 Add Query 43 Query Editor 43 Query Builder 46 Modify Data Source Connections 52 View Data 53 Filter / Sort / Project Data 54 Add Custom Fields 55 Chapter 6 - Chart 58 About or workspace files in Navicat Cloud / On-Prem Server. If the Navigation pane is hidden, choose View -> Show Navigation Pane from the menu bar. Content Pane The Content pane contains the workspaces in the selected section of the Navigation pane. Use the Detail or Icon buttons to change the view. Information Pane The General tab shows the general information of the workspace or the selected

41 Add Query 41 Query Editor 41 Query Builder 45 Modify Data Source Connections 50 View Data 51 Filter / Sort / Project Data 52 Add Custom Fields 54 Chapter 6 - Chart 56 About or workspace files in Navicat Cloud / On-Prem Server. If the Navigation pane is hidden, choose View -> Show Navigation Pane from the menu bar. Content Pane The Content pane contains the workspaces in the selected section of the Navigation pane. Use the Detail or Icon buttons to change the view. Information Pane The General tab shows the general information of the workspace or the selected

42 Add Query 42 Query Editor 42 Query Builder 45 Modify Data Source Connections 51 View Data 52 Filter / Sort / Project Data 52 Add Custom Fields 54 Chapter 6 - Chart 57 About or workspace files in Navicat Cloud / On-Prem Server. If the Navigation pane is hidden, choose View -> Navigation Pane -> Show Navigation Pane from the menu bar. Content Pane The Content pane in the selected section of the Navigation pane. Use the Detail or Icon buttons to change the view. Information Pane The General tab shows the general information of the workspace or the selected

hidden, choose View -> Show Navigation Pane from the menu bar. Content Pane The Content pane contains the workspaces that are in the selected section of Navigation pane. To change the view, click the the members. Click + to add members to the project. If the Information pane is hidden, choose View -> Show Information Pane from the menu bar. 13 Workspace Window Dashboard List Pane hidden, choose View -> Show Dashboard List from the menu bar. Pages Pane The Pages pane shows thumbnail images of each page in the dashboard. If the Pages pane is hidden, choose View -> Show Pages