Table of Contents Chapter 1 - Introduction 3 About Navicat Cloud Portal 3 About Navicat On-Prem Server 3 End-User License Agreement 3 Chapter 2 - Getting Started 10 Overview 10 Navicat Navicat On-Prem Server 11 Requirements 11 Offline Installation 13 Online Installation 14 Minor Version Upgrade 14 Initial Setup 16 Sign In & Sign Out Navicat On-Prem Server 21 Sign Sign In On-Prem Server In Other Navicat Software 22 Chapter 3 - User Interface 23 Overview 23 Navicat Cloud Portal 23 Main Page 23 Navicat On-Prem Server 24 Main Page 24 Navicat On-Prem

Chapter 3 - Collaboration 14 About Collaboration 14 Manage Cloud 14 Navicat Cloud 14 On-Prem Server 16 Push Synchronization 18 Cache and Local Copies 19 Projects 19 Work With Projects You can access local workspace files, or workspace files stored in Navicat Cloud or Navicat On-Prem Server. Navicat Charts Viewer allows you to share workspace files with someone who does not have Navicat Windows • Microsoft Windows 7, Windows 8, Windows 8.1, Windows 10, Windows 11, Server 2012, Server 2016, Server 2019, Server 2022 macOS • macOS 10.14 Mojave, macOS 10.15 Catalina, macOS 11 Big Sur

Chapter 3 - Collaboration 15 About Collaboration 15 Manage Cloud 15 Navicat Cloud 15 On-Prem Server 17 Push Synchronization 19 Cache and Local Copies 20 Projects 20 Work With Projects models. • Support various database systems: MySQL, MariaDB, Oracle, PostgreSQL, SQLite and SQL Server (including cloud databases like Amazon RDS, Amazon Redshift, Alibaba Cloud, Microsoft Azure). Navicat On-Prem Server. For details, visit our website: https://www.navicat.com System Requirements Windows • Microsoft Windows 7, Windows 8, Windows 8.1, Windows 10, Windows 11, Server 2012, Server

Chapter 3 - Collaboration 15 About Collaboration 15 Manage Cloud 15 Navicat Cloud 15 On-Prem Server 17 Push Synchronization 19 Cache and Local Copies 20 Projects 20 Work With Projects models. • Support various database systems: MySQL, MariaDB, Oracle, PostgreSQL, SQLite and SQL Server (including cloud databases like Amazon RDS, Amazon Redshift, Alibaba Cloud, Microsoft Azure). Navicat On-Prem Server. For details, visit our website: https://www.navicat.com System Requirements Windows • Microsoft Windows 7, Windows 8, Windows 8.1, Windows 10, Windows 11, Server 2012, Server

Chapter 3 - Collaboration 17 About Collaboration 17 Manage Cloud 17 Navicat Cloud 17 On-Prem Server 19 Push Synchronization 21 Cache and Local Copies 22 Projects 22 Work With Projects About Data Source 28 Create Data Source 29 Database Connection 30 Connect to Database Server 30 General Settings 31 Advanced Settings 32 Databases / Attached Databases Settings 33 Navicat On-Prem Server. For details, visit our website: https://www.navicat.com System Requirements Windows • Microsoft Windows 7, Windows 8, Windows 8.1, Windows 10, Windows 11, Server 2012, Server

Chapter 3 - Collaboration 16 About Collaboration 16 Manage Cloud 16 Navicat Cloud 16 On-Prem Server 18 Push Synchronization 20 Cache and Local Copies 21 Projects 21 Work With Projects About Data Source 27 Create Data Source 28 Database Connection 29 Connect to Database Server 29 General Settings 30 Advanced Settings 31 Attached Databases Settings 32 SSL Settings Navicat On-Prem Server. For details, visit our website: https://www.navicat.com System Requirements Windows • Microsoft Windows 7, Windows 8, Windows 8.1, Windows 10, Windows 11, Server 2012, Server

Chapter 3 - Collaboration 16 About Collaboration 16 Manage Cloud 16 Navicat Cloud 16 On-Prem Server 18 Push Synchronization 20 Cache and Local Copies 21 Projects 21 Work With Projects About Data Source 27 Create Data Source 28 Database Connection 29 Connect to Database Server 29 General Settings 30 Advanced Settings 31 Databases Settings 33 SSL Settings 33 Navicat On-Prem Server. For details, visit our website: https://www.navicat.com System Requirements Windows • Microsoft Windows 7, Windows 8, Windows 8.1, Windows 10, Windows 11, Server 2012, Server

Chapter 3 - Collaboration 29 About Collaboration 29 Manage Cloud 29 Navicat Cloud 29 On-Prem Server 31 Push Synchronization 33 Cache and Local Copies 34 Projects 34 Work With Projects 49 Compatibility Settings 50 Connect with Different Profiles 51 Chapter 5 - Server Objects 52 About Server Objects 52 MySQL / MariaDB 52 Databases 52 Tables 52 Views 53 2 67 Foreign Servers 68 Other Objects 68 Maintain Objects 68 Manage Extensions 69 SQL Server 69 Databases & Schemas 69 Tables 70 Views 71 Procedures / Functions 71 Other Objects

Chapter 3 - Collaboration 28 About Collaboration 28 Manage Cloud 28 Navicat Cloud 28 On-Prem Server 30 Push Synchronization 32 Cache and Local Copies 33 Projects 33 Work With Projects 48 Compatibility Settings 49 Connect with Different Profiles 49 Chapter 5 - Server Objects 51 About Server Objects 51 MySQL / MariaDB 51 Databases 51 Tables 51 Views 52 2 66 Foreign Servers 66 Other Objects 67 Maintain Objects 67 Manage Extensions 67 SQL Server 68 Databases & Schemas 68 Tables 68 Views 69 Procedures / Functions 70 Other Objects

Chapter 3 - Collaboration 28 About Collaboration 28 Manage Cloud 28 Navicat Cloud 28 On-Prem Server 30 Push Synchronization 32 Cache and Local Copies 33 Projects 33 Work With Projects 48 Compatibility Settings 49 Connect with Different Profiles 50 Chapter 5 - Server Objects 51 About Server Objects 51 MySQL / MariaDB 51 Databases 51 Tables 51 Views 52 2 66 Foreign Servers 66 Other Objects 66 Maintain Objects 67 Manage Extensions 67 SQL Server 68 Databases & Schemas 68 Tables 68 Views 69 Procedures / Functions 70 Other Objects