|
Win
|
Win
|
Win
|
Mac
|
Mac
|
Mac
|
||||
|
^Enterprise Edition. #Standard Edition. *Essentials Edition. |
|||||||||
| SQL Server 2000 or above |
|
|
|
|
|
|
| Amazon RDS, SQL Azure |
|
|
|
|
|
|
| Multiple local/remote server connections |
|
|
|
|
|
|
| Connect server through SSH |
|
|
|
|
|
|
| Keep connection alive |
|
|
|
|
|
|
| Export/import connection settings |
|
|
|
|
|
|
| Collaboration: create projects, add members |
|
|
|
|
|
|
| Synchronize connections |
|
|
|
|
|
|
| Synchronize queries |
|
|
|
|
|
|
| Synchronize models |
|
|
||||
| Synchronize virtual groups |
|
|
|
|
||
|
|
||||||
| UUID/GUID Generator |
|
|
|
|
|
|
| Grid view |
|
|
|
|
|
|
| Form view |
|
|
|
|
||
| Text, Hex and BLOB viewer/editor |
|
|
|
|
|
|
| Code-highlight in Memo viewer |
|
|
|
|||
| Web viewer for HTML codes data |
|
|
|
|||
| Box selection and multi-cell editing |
|
|
|
|||
| Copy and paste selected records |
|
|
|
|
|
|
| Copy selected records as INSERT/UPDATE statements |
|
|
|
|
|
|
| Customize display formats |
|
|
|
|||
| Incremental search, sort and format table grid |
|
|
|
|
|
|
| Search columns |
|
|
|
|
|
|
| Find and replace |
|
|
|
|
|
|
| Raw mode editing: apply SQL Server built-in function |
|
|
|
|
|
|
| Foreign key data selection: locate the available values from the reference table |
|
|
|
|
||
| Filter records |
|
|
|
|
|
|
| Set number of records showing on each page |
|
|
|
|
|
|
|
|
||||||
| Visual SQL Builder |
|
|
|
|
||
| Create parameter queries |
|
|
|
|
|
|
| Code completion |
|
|
|
|
Code outline |
|
|
|
|
| SQL Code Beautifier/Minifier |
|
|
|
|
||
| Multiple SQL editors with syntax highlighted feature |
|
|
|
|
|
|
| Code folding, highlighted matches words and brackets |
|
|
|
|
|
|
| Copy SQL with quote |
|
|
|
|
|
|
| Word Wrap |
|
|
|
|
|
|
| Zoom in/out for SQL editors |
|
|
|
|
|
|
| Enhanced find and replace options in SQL editors |
|
|
|
|
|
|
| Preview SQL before execution |
|
|
|
|
|
|
| Return multi-resultsets |
|
|
|
|
|
|
| Open query files in an external editor |
|
|
|
|
|
|
| SQL console |
|
|
|
|
|
|
|
|
||||||
| Reverse engineering |
|
|
||||
| Build model with multiple schemas |
|
|
||||
| Several diagram notations like Crow's Foot, IDEF1x and UML |
|
|
||||
| Create/edit/drop database objects, visually set relationships between them |
|
|
||||
| Align and distribute database objects |
|
|
||||
| Search objects in diagram |
|
|
||||
| Auto layout |
|
|
||||
| Add vertices, layers, images, notes, labels and shapes |
|
|
||||
| Zoom in/out for ER diagram |
|
|
||||
| Compare and synchronize database/model |
|
|
||||
| Generate complex SQL/DDL |
|
|
||||
| Multi-page print preview |
|
|||||
| Print database diagrams to PDF file |
|
|
||||
| Save database diagrams as a graphic file, i.e. PNG, SVG |
|
|
||||
|
|
||||||
| Import data from ODBC |
|
|
|
|
||
| Import data from MS Excel |
|
|
|
|
||
| Import data from MS Access |
|
|
|
|
||
| Export data to MS Excel |
|
|
|
|
||
| Export data to MS Access |
|
|
|
|
||
| Export data to HTML |
|
|
||||
| Import/export data from/to plain text file formats: TXT, CSV, XML, JSON etc |
|
|
|
|
|
|
| Import/export data from/to most popular formats: DBF etc |
|
|
|
|
||
|
|
||||||
| Data transfer |
|
|
|
|
||
| Transfer data to SQL script as INSERT statements |
|
|
|
|
||
| Transfer data to a SQL file with designated SQL format and encoding |
|
|
|
|
||
| Data synchronization |
|
|
|
|
||
| Structure synchronization |
|
|
|
|
||
| SQL Server Backup |
|
|
|
|
||
| SQL Server Restore |
|
|
|
|
||
| Set schedule on query execution, import/export, data transfer and data synchronization |
|
|
|
|
||
| Schedule report printing |
|
|||||
| Schedule to print report to files: PDF, Excel, HTML etc |
|
|||||
| Send notification e-mail for schedule task |
|
|
|
|
||
| Attach Export Wizard/Report result files in Batch Job notification email |
|
|
|
|
||
| Notification email supports SSL/TLS |
|
|
|
|
||
| Visual user management |
|
|
|
|
|
|
| Visual privilege manager |
|
|
|
|
|
|
| Duplicate user, role, etc |
|
|
|
|
|
|
| Maintain database/schema objects |
|
|
|
|
|
|
| Server Monitor |
|
|
|
|
||
| Report Builder |
|
|||||
| Report Viewer |
|
|||||
| ER Diagram view |
|
|
|
|
||
| Customize connection colorings |
|
|
|
|
|
|
| Show active connections/objects |
|
|
|
|
|
|
| Database wide search |
|
|
|
|
||
| Connection tree filter and objects search filter |
|
|
|
|
|
|
| Backup schema/table to SQL script |
|
|
|
|
|
|
| Execute SQL script |
|
|
|
|
|
|
| Duplicate/empty tables |
|
|
|
|
|
|
| Create table/view shortcut on desktop |
|
|
|
|
|
|
| Favorites list |
|
|
|
|
||
| Auto-save for Query, Function, etc |
|
|
|
|
|
|
| Print database/table structure |
|
|
|
|
||
| Dock/tab windows |
|
|
|
|
|
|
| Virtual grouping: provide logical organization over connections and objects |
|
|
|
|
||
| Run profile from command line |
|
|
|
|
||
| Log files: keep track on the actions have been performed in Navicat |
|
|
|
|
|
|
| Copy Connection Information into Clipboard |
|
|
|
|
|
|