Table of Contents - Navicat GUI

[Pages:308]Table of Contents

Getting Started

9

System Requirements

10

Registration

10

Installation

11

Maintenance/Upgrade

12

End-User License Agreement

12

Connection

19

Navicat Cloud

20

General Settings

23

Advanced Settings

26

SSL Settings

30

SSH Settings

31

HTTP Settings

32

Server Objects

34

MySQL/MariaDB Objects

34

MySQL/MariaDB Tables

34

MySQL/MariaDB Table Fields

35

MySQL/MariaDB Table Indexes

37

MySQL/MariaDB Table Foreign Keys

38

MySQL/MariaDB Table Triggers

39

MySQL/MariaDB Table Options

40

MySQL/MariaDB Views

43

MySQL/MariaDB Functions/Procedures

44

MySQL/MariaDB Events

46

Oracle Objects

47

Oracle Data Pump (Available only in Full Version)

47

Oracle Data Pump Export

48

Oracle Data Pump Import

51

Oracle Debugger (Available only in Full Version)

55

Oracle Physical Attributes/Default Storage Characteristics

57

Oracle Tables

58

Oracle Normal Tables

59

Oracle Table Fields

59

Oracle Table Indexes

61

Oracle Table Foreign Keys

62

Oracle Table Uniques

62

Oracle Table Checks

63

Oracle Table Triggers

63

Oracle Table Options

65

Oracle External Tables

66

2

Fields for Oracle External Tables

66

External Properties for Oracle External Tables

67

Access Parameters for Oracle External Tables

67

Oracle Index Organized Tables

68

Options for Oracle Index Organized Tables

68

Oracle Views

69

Oracle Functions/Procedures

70

Oracle Database Links

71

Oracle Indexes

72

Oracle Java

74

Oracle Materialized Views

75

Oracle Materialized View Logs

78

Oracle Packages

79

Oracle Sequences

80

Oracle Synonyms

81

Oracle Triggers

82

Oracle Types

85

Oracle XML Schemas

86

Oracle Recycle Bin

87

Oracle Directories

87

Oracle Tablespaces

88

Oracle Public Database Links

90

Oracle Public Synonyms

91

PostgreSQL Objects

91

PostgreSQL Debugger (Available only in Full Version)

91

PostgreSQL Schemas

93

PostgreSQL Tables

93

PostgreSQL Normal Tables

94

PostgreSQL Table Fields

94

PostgreSQL Table Indexes

96

PostgreSQL Table Foreign Keys

97

PostgreSQL Table Uniques

98

PostgreSQL Table Checks

99

PostgreSQL Table Excludes

100

PostgreSQL Table Rules

101

PostgreSQL Table Triggers

102

PostgreSQL Table Options

103

PostgreSQL Foreign Tables

104

Fields for PostgreSQL Foreign Tables

104

Checks for PostgreSQL Foreign Tables

106

Triggers for PostgreSQL Foreign Tables

106

Table Options for PostgreSQL Foreign Tables

108

3

PostgreSQL Views

108

PostgreSQL Functions

110

PostgreSQL Aggregates

112

PostgreSQL Conversions

113

PostgreSQL Domains

114

PostgreSQL Indexes

115

PostgreSQL Materialized Views

117

PostgreSQL Operators

118

PostgreSQL Operator Classes

119

PostgreSQL Sequences

121

PostgreSQL Triggers

122

PostgreSQL Trigger Functions

123

PostgreSQL Types

125

PostgreSQL Tablespaces

129

PostgreSQL Casts

129

PostgreSQL Foreign Servers

130

PostgreSQL Languages

130

SQLite Objects

131

SQLite Tables

132

SQLite Table Fields

132

SQLite Table Indexes

134

SQLite Table Foreign Keys

135

SQLite Table Uniques

136

SQLite Table Checks

137

SQLite Table Triggers

138

SQLite Table Options

139

SQLite Views

139

SQLite Indexes

140

SQLite Triggers

141

SQL Server Objects

142

SQL Server Backup/Restore (Available only in Full Version)

148

SQL Server Backup

148

SQL Server Restore

150

SQL Server Schemas

151

SQL Server Tables

152

SQL Server Table Fields

152

SQL Server Table Indexes

154

SQL Server Table Foreign Keys

155

SQL Server Table Uniques

156

SQL Server Table Checks

157

SQL Server Table Triggers

157

SQL Server Table Options

159

4

SQL Server Table Storage

160

SQL Server Views

160

SQL Server Functions/Procedures

161

SQL Server Indexes

163

SQL Server Synonyms

168

SQL Server Triggers

169

SQL Server Backup Devices

171

SQL Server Linked Servers

171

SQL Server Server Triggers

173

SQL Server Assemblies

174

SQL Server Database Triggers

175

SQL Server Partition Functions

176

SQL Server Partition Schemes

177

SQL Preview

177

Maintain

177

Maintain MySQL/MariaDB

177

Maintain Oracle

178

Maintain PostgreSQL

183

Maintain SQLite

184

Maintain SQL Server

184

Table Viewer

186

Grid View

186

Using Navigation Bar

186

Editing Records

188

Sorting/Finding/Replacing Records

192

Filtering Records

194

Manipulating Raw Data

194

Formatting Table Grid

195

Form View (Available only in Full Version)

196

Assistant Editors

197

Filter Wizard

197

Query

200

Query Builder (Available only in Full Version)

200

Query Editor

202

Editor Advanced Features

202

Query Results

206

Query Parameters

207

Debugging Oracle Query (Available only in Full Version)

207

Model (Available only in Navicat Premium and Enterprise Version)

208

Model Sidebar

208

Model Explorer Pane

208

Model History Pane

209

5

Model Properties Pane

209

Model Overview Pane

212

Diagram Canvas

212

Create Tables

212

Create Views

213

Create Foreign Keys

214

Create Labels

215

Create Notes

216

Create Images

217

Create Shapes

217

Create Layers

219

Format Diagram

219

Preview and Print Model

220

Reverse Engineering

221

Script Generation

221

General Settings for Export SQL

221

Advanced Settings for Export SQL

221

Forward Engineering

223

Selecting Synchronization Type

223

Selecting Schemas/Objects and Connection

223

Selecting Compare and Execution Options

223

Viewing Comparison Result

225

Model Conversion

226

Model Hints and Tips

226

Advanced Tools

228

Import Wizard

228

Setting Import File Format (Step 1)

228

Setting Source File Name (Step 2)

228

Setting Delimiter (Step 3) - TXT, XML

229

Setting Additional Options (Step 4) - TXT, XML, Excel, HTML

230

Setting Target Table (Step 5)

231

Adjusting Field Structures and Mapping Fields (Step 6)

231

Selecting Import Mode (Step 7)

232

Saving and Confirming Import (Step 8)

233

Export Wizard

233

Setting Export File Format (Step 1)

234

Setting Destination File Name (Step 2)

234

Selecting Fields for Export (Step 3)

235

Setting Additional Options (Step 4)

235

Saving and Confirming Export (Step 5)

236

Data Transfer (Available only in Full Version)

236

General Settings for Data Transfer

236

6

Advanced Settings for Same Server Type Data Transfer

237

Advanced Settings for Cross Server Data Transfer (Available only in Navicat Premium)

239

Data Synchronization (Available only in Full Version)

241

General Settings for Data Synchronization

242

Advanced Settings for Data Synchronization

242

Structure Synchronization (Available only in Full Version)

242

General Settings for Structure Synchronization

242

Structure Synchronization Result

244

Backup/Restore (Available only in Full Version)

245

Backup

246

Restore

246

Extract SQL

248

Batch Job/Schedule (Available only in Full Version)

248

General Settings for Batch Job/Schedule

249

Advanced Settings for Batch Job/Schedule

249

Batch Job Converter (Available only in Navicat Premium)

250

Dump SQL File/Execute SQL File

250

Print Database/Schema/Table Structure (Available only in Full Version)

251

Console

251

Report (Available only in Navicat Premium and Enterprise Version)

252

Report Data

252

Report Query Wizard

253

Report Query Designer

253

Report Design

255

Report Wizard

255

Report Design Toolbars

255

Report Dialogs

264

Report Layout

267

Report Preview

269

Server Security

270

MySQL/MariaDB Security

270

MySQL/MariaDB User Designer

270

Oracle Security

272

Oracle User Designer

272

Oracle Role Designer

274

PostgreSQL Security

275

PostgreSQL Server 7.3 to 8.0

275

PostgreSQL User Designer

275

PostgreSQL Group Designer

276

PostgreSQL Server 8.1 or above

277

PostgreSQL Role Designer

277

SQL Server Security

278

7

SQL Server Login Designer

280

SQL Server Server Role Designer

283

SQL Server Database User Designer

283

SQL Server Database Role Designer

284

SQL Server Application Role Designer

285

SQLite Security

286

SQLite User Designer

286

Privilege Manager

286

Useful Tools

287

List/Detail/ER Diagram View

287

Object Information

289

Server Monitor (Available only in Full Version)

290

Virtual Grouping (Available only in Full Version)

291

Connection Colorings

291

Favorites (Available only in Full Version)

291

Find in Database/Schema (Available only in Full Version)

292

Search Filter

292

Options

294

General Options

294

Appearance Options

295

Model Options (Available only in Full Version)

301

Miscellaneous Options

301

Commands (Available only in Full Version)

303

Hot Keys

305

Log Files

308

8

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download