Thursday, February 25, 2010

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.

Thursday, February 18, 2010

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.

Thursday, February 11, 2010

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.

Wednesday, February 3, 2010

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.