1 Table of Contents Chapter 1 - Introduction 4 About Navicat Data Modeler 4 Installation 5 Registration 6 Migration / Upgrade 7 End-User License Agreement 7 Chapter 2 - User Interface Version) 64 Import from Database 64 Chapter 11 - Forward Engineering (Available only in Non-Essentials Version) 65 Forward Engineer Physical Model 65 Synchronize to Database 65 Export SQL 69 71 Model Conversion 71 Auto Layout (Available only in Non-Essentials Version) 71 Print & Export Model 72 Virtual Grouping (Available only in Non-Essentials Edition) 72 Search Filter 73

1 Table of Contents Chapter 1 - Introduction 4 About Navicat Data Modeler 4 Installation 5 Registration 5 Migration / Upgrade 6 End-User License Agreement 7 Chapter 2 - User Interface Version) 63 Import from Database 63 Chapter 11 - Forward Engineering (Available only in Non-Essentials Version) 63 Forward Engineer Physical Model 63 Synchronize to Database 63 Export SQL 68 70 Model Conversion 70 Auto Layout (Available only in Non-Essentials Version) 70 Print & Export Model 71 Virtual Grouping (Available only in Non-Essentials Edition) 71 Search Filter 72

Object Editor Properties Editor Data Editor Navigation Data View and Format Data Filters Data Refresh Data Viewing and Editing Panels Managing Charts Data Search Data transfer SQL Generation Working Working with spatial/GIS data Working with XML and JSON Managing Data Formats Virtual column expressions SQL Editor Toolbar Customization SQL Templates User Guide Table of contents General User Variables panel Query Execution Plan Visual Query Builder Script Management Client Side Commands Export Command Debug PostgreSQL Debugger ER Diagrams Database Structure Diagrams Custom Diagrams Edit

78 Maintain Objects 79 Redis 80 Databases 80 Data 80 Chapter 6 - Data Viewer 81 About Data Viewer 81 RDBMS 81 RDBMS Data Viewer 81 Use Navigation Bar 81 Edit Records 82 Replace Records 88 Filter Records 90 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 Tree View 100 JSON View 102 Sort / Find / Replace Documents 102 Redis 105 Redis Data Viewer 105 Use Navigation Bar 105 Edit Keys 106 Sort Keys 106 Search Keys 107 Assistant Editors

76 Maintain Objects 77 Redis 78 Databases 78 Data 78 Chapter 6 - Data Viewer 79 About Data Viewer 79 RDBMS 79 RDBMS Data Viewer 79 Use Navigation Bar 79 Edit Records 80 Replace Records 86 Filter Records 88 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 Tree View 98 JSON View 100 Sort / Find / Replace Documents 100 Redis 103 Redis Data Viewer 103 Use Navigation Bar 103 Edit Keys 104 Sort Keys 105 Search Keys 105 Assistant Editors

mode Export and import settings Tabs display settings PDF Options Languages Web server settings Theme settings Design customization Text fields SQL query box settings Web server upload/save/import directories Developer Examples User Guide Transformations Bookmarks User management Relations Charts Import and export Other sources of information FAQ - Frequently Asked Questions Server Configuration Known limitations and read dumps of tables export [1] data to various formats: CSV, XML, PDF, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Microsoft Word 2000, and LATEX formats import data and MySQL structures from

mode Export and import settings Tabs display settings PDF Options Languages Web server settings Theme settings Design customization Text fields SQL query box settings Web server upload/save/import directories phpMyAdmin Two-factor authentication Transformations Bookmarks User management Relations Charts Import and export Custom Themes Other sources of information FAQ - Frequently Asked Questions Server Configuration and read dumps of tables export [[1]] data to various formats: CSV, XML, PDF, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Microsoft Word 2000, and LATEX formats import data and MySQL structures from

Explorer Query Manager Background Tasks Database Object Editor Data Editor Navigation Data View and Format Data Filters Data Refresh Data Viewing and Editing User Guide Table of contents DBeaver Desktop Page 3 of 700. Panels Managing Charts Data Search Data transfer SQL Generation Working with spatial/GIS data Working with XML and JSON Managing Data Formats Virtual column expressions Properties Client Side Commands Export Command Debug PostgreSQL Debugger Search File Search DB Full-Text Search DB Metadata Search Schema compare Using Liquibase in DBeaver Data compare MockData generation

mode Export and import settings Tabs display settings PDF Options Languages Web server settings Theme settings Design customization Text fields SQL query box settings Web server upload/save/import directories phpMyAdmin Two-factor authentication Transformations Bookmarks User management Relations Charts Import and export Custom Themes Other sources of information FAQ - Frequently Asked Questions Server Configuration and read dumps of tables export [[1]] data to various formats: CSV, XML, PDF, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Microsoft Word 2000, and LATEX formats import data and MySQL structures from

mode Export and import settings Tabs display settings PDF Options Languages Web server settings Theme settings Design customization Text fields SQL query box settings Web server upload/save/import directories phpMyAdmin Two-factor authentication Transformations Bookmarks User management Relations Charts Import and export Custom Themes Other sources of information FAQ - Frequently Asked Questions Server Configuration and read dumps of tables export [[1]] data to various formats: CSV, XML, PDF, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Microsoft Word 2000, and LATEX formats import data and MySQL structures from