Navicat feature tips – #4 “Allow Navicat Multiple Instance”

Sometimes we need to open an application more than one copy for ease of use. Navicat supports multiple instances in Windows, Mac and Linux versions. To enable this option in Navicat, you just need to set it by an easy step.

Step 1: Select “Options” from “Tools” menu. For Mac version, select “Preferences” from “Navicat Premium” menu.

Step 2: Checked the option “Allow Multiple Navicat Instances” and click “OK” button.



Step 3: You can then open more than one Navicat windows in your operating system.



With this feature enabled, you can open more than one Navicat to do multipule tasks, for example working with different servers.

Navicat feature tips – #3 Drag and Drop Import Files to Navicat (Windows and Mac support)

Navicat supports to import data from various file formats such as text files, excel files and CSV files, etc. To simplify the import steps, both Windows and Mac version can allow you to drag and drop a file to Navicat to launch the Import Wizard automatically. This feature applies to the import formats supported by Navicat. If an existing table is selected in Navicat, Navicat will import the file to the selected table; otherwise, it will import the file to a new table.

Step 1: In Navicat, simply drag and drop a file to the table object pane or a database/schema in the connection tree.

Step 2: Then, the Import Wizard is pop-up.

Step 3: Continue the remaining steps and start the process.

Using the drag and drop method, Import Wizard sets the import file type and locates the file path automatically. No need to waste time to set them by yourself.

Navicat feature tips – #1 Create Desktop Table Shortcuts (Windows and Mac support)

In the coming five weeks, we will bring you a series of Navicat tips and discover features which you may not actually know in Navicat.  This week, we will talk about creating desktop shortcuts in Navicat.

Did you experience any difficulties to find out a table or a view in a large number of connections and databases? If you have many connections and databases and need to access some tables or views frequently, you simply create Navicat table or view shortcuts in your desktop to open your tables or views directly. Both Navicat Windows and Mac versions support this feature. It can reduce the number of clicks to reach your tables or views, such as open Navicat, open connections, open databases and open schema, etc.

In Windows version:

Step 1: In Navicat, right-click a table or view and choose “Create Open Table Shortcut” or “Create Open View Shortcut”.

Step 2: Specify the location and file name.

Step 3: Double-click the shortcut to open the table.

In Mac version:

Step 1: Simply drag and drop a table or view from Navicat to a desired location.

Step 2: Double-click the shortcut to open the table.

With the desktop shortcut feature, you can open tables and views in a convenient way. You do not need to worry about which connection and database is your table stored in.

Navicat feature tips – #1 Create Desktop Table Shortcuts (Windows and Mac support)

In the coming five weeks, we will bring you a series of Navicat tips and discover features which you may not actually know in Navicat.  This week, we will talk about creating desktop shortcuts in Navicat.

Did you experience any difficulties to find out a table or a view in a large number of connections and databases? If you have many connections and databases and need to access some tables or views frequently, you simply create Navicat table or view shortcuts in your desktop to open your tables or views directly. Both Navicat Windows and Mac versions support this feature. It can reduce the number of clicks to reach your tables or views, such as open Navicat, open connections, open databases and open schema, etc.

In Windows version:

Step 1: In Navicat, right-click a table or view and choose “Create Open Table Shortcut” or “Create Open View Shortcut”.

Step 2: Specify the location and file name.

Step 3: Double-click the shortcut to open the table.

In Mac version:

Step 1: Simply drag and drop a table or view from Navicat to a desired location.

Step 2: Double-click the shortcut to open the table.

With the desktop shortcut feature, you can open tables and views in a convenient way. You do not need to worry about which connection and database is your table stored in.

The new Navicat.TV

Recently, we have luanched a  new site Navicat.tv. We aim at giving our users a different way to experience our products. In this new site, we are showing various feature demos, tutorials, and product tips, you can find all you need to know about Navicat.

Our videos are also carefully categorized, so you can check out the topics which you are interested in.

Come check out our new site at http://www.navicat.tv now!

Navicat now comes in new colors

If you have noticed, we have revamped our website with a new style few months ago and today we have published the new look for Navicat boxsets too. This changes give Navicat a more clean and fresh feeling.

Our team has always been very devoted on delivering the best products to the market. Our idea to launch a new brand identity for Navicat, is to recognize the progression of our products and the Company as we entering the 10th year of our business. 

This also show our team dedication  on making new things and have new ideas as always.

Our new website provides  user with a clearer and easier navigation, allowing users to find information quicker than before.  The content is also simplified and important information is emphasized, to let you understand our product within the shortest time.

In the new site, we also include a guided product tour for people to have a quick overview on how Navicat can help in managing their database.

Our next plan is to work on a Navicat.tv part, which will include many useful video clips to introduce features which you may not know inside Navicat, and to introduce some popular features in Navicat.

Please keep an eye on us and we will announce when the Navicat.tv is launched.

We are extending our product offerings for Linux Users

We are happy to extend our support to Linux users of Oracle and PostgreSQL Databases and released the following new versions for users who are looking for a comprehensive database administration tools under Linux platform:

• Navicat Premium v.8.2.12 (Linux)
• Navicat for MySQL v.8.2.12 (Linux)
• Navicat for Oracle v.8.2.12 (Linux)
• Navicat for PostgreSQL v.8.2.12 (Linux)

These releases mark a complete Navicat product offering to the Linux users. Linux users can now experience the comprehensive database administration for MySQL, PostgreSQL and Oracle with Navicat.

Navicat Premium is a multi-connections Database Administration tool allowing you to connect to MySQL, PostgreSQL and Oracle databases simultaneously within a single application, making database administration to multiple kinds of database so easy. Navicat Premium combines the functions of other Navicat members together with below great features:

- Support of multi-connections to MySQL, PostgreSQL and Oracle servers.
- Support of transferring data across various database systems.
- Ability to transfer data to a text file with designated SQL format.
- Support of running profiles from different servers in a single schedule job.

New Features:

Support of latest MySQL versions

- Compatible with any MySQL server version.
- Support all MySQL objects: tables, views, stored procedures/functions and events.
- Support all sub-objects: fields, indices, foreign keys and triggers.
- Support of partitioning.
- Support of Unicode / Character Set.

Support of latest Oracle versions

- Support Oracle version 8.1, 9i, 10g and 11g.
- Support all Oracle objects: tables (Normal, External and Index Organized), views, procedures/functions.
- Support all sub-objects: fields, indices, foreign keys, uniques, checks and triggers.
- Managing directories, tablespaces, public database links and public synonyms.
- Managing database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin.

- Support of physical attributes.
- Support of Unicode/Character Set.

Support of latest PostgreSQL versions

- Support PostgreSQL Server version 7.3 to 8.3.
- Support all PostgreSQL objects: tables, views and functions.
- Support all sub-objects: fields, indices, foreign keys, uniques, checks, rules and triggers.
- Managing tablespace, cast and languages.
- Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types.
- Support of character set and Unicode.

Connection options

- Support of password and public/private key for SSH Tunnel.
- Support of HTTP Tunnel for MySQL and PostgreSQL Servers.
- Support SSL secure connection for MySQL and PostgreSQL 8.4 above.

Well-designed user interface

- Grid View and Form View support.
- Virtual Grouping for connections and objects.

Powerful Data Manipulation Tools

- Import and Export tool.
- Data Transfer tool.
- Data and Structure synchronization.
- Backup and Restore.
- Ability to set schedule on backup, query execution, import/export, data transfer and data synchronization.
- Ability to attach Export Wizard/Report result files in Batch Job notification email.

SQL Processing

- Visual query/view builder to facilitate the process of building complicated queries.
- Ability to create parameter queries.
- Multiple SQL editors with syntax highlighted feature.
- Code completion for SQL editors.
- Ability to preview SQL before execution.
- Support to return multi-resultsets.

Download the 30-day Free Trial

========================================================================
To try the new Linux version of Navicat, please download the trial version at:

Navicat Premium v8.2 (Linux)
URL 1: http://download.navicat.com/download/navicat8_premium_en.tar.gz

Navicat for MySQL v8.2 (Linux)
URL 1: http://download.navicat.com/download/navicat8_mysql_en.tar.gz

Navicat for Oracle v8.2 (Linux)
URL 1: http://download.navicat.com/download/navicat8_ora_en.tar.gz

Navicat for PostgreSQL v8.2 (Linux)
URL 1: http://download.navicat.com/download/navicat8_pgsql_en.tar.gz

========================================================================

For more details, please see the release notes at http://www.navicat.com/products/navicat_premium

Or, download the 30-day fully functional free trial at: http://www.navicat.com/download