Navicat™ Version 9 is released!!!

We are glad to announce the immediate release of version 9 for the whole Navicat™ family, including:

- Navicat™ Premium
- Navicat™ for MySQL
- Navicat™ for SQLite
- Navicat™ for Oracle
- Navicat™ for PostgreSQL

To meet the wishes of Navicat customers and the demand of managing SQLite database server through a GUI, Navicat for SQLite is introduced to the Navicat family in this launch. Navicat for SQLite provides SQLite users a tool for administering and managing database objects as well as for database migration, data import, export, synchronization, reporting, and more.

With the launch of Navicat for SQLite, database connectivity to SQLite servers is also added to Navicat Premium. Navicat Premium unites all Navicat family members for database administration and development, into one powerful and easy-to-use work environment. With the new Navicat Premium version 9, users can connect to 4 of the most common databases including MySQL, Oracle, PostgreSQL and SQLite within one single application, making cross-database data management feasible.

In addition to the introduction of Navicat for SQLite, another significant feature improvement to version 9 is the introduction of PL/SQL debugger in Navicat for Oracle. The PL/SQL debugger lets users debug their code easily, it helps to avoid tedious PL/SQL debugging tasks, saving time and improving the overall quality of applications.

New Key features:

- Support of SQLite
- Oracle PL/SQL Debugger
- Enhanced Code Completion
- Code Formatter
- Code outline
- Recovery of Documents from crashes
- Shortcut to open official online documents
- Option to show query results below query editor
- Storing favorite actions as shortcut
- Enhanced User Interface

Navicat Premium starts from US$199, currently available for Microsoft Windows, Mac OS X, Linux supporting simultaneous connections to MySQL, PostgreSQL, Oracle and SQLite databases.

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

Beta version of Navicat Premium

Beta version of Navicat Premium is now ready for download. New features in version 9 includes:

- support of SQLite
- Oracle PL/SQL Debugger
- Enhanced code completion
- Code formatter
- Code outline
- Document recovery from crashes
- Shortcut to open official online doc
- Option to show query results below query editor
- Storing favorite actions as shortcut
- Beautified user interface
and more …

Download the 30-day Free Trial
========================================================================
To test drive the new version of Navicat Premium, please download the trial version at:

Windows URL
http://download2.navicat.com/download/navicat9_premium_en_beta.exe

Mac OS X URL

x86: http://download2.navicat.com/download/navicat9_premium_en_x86_beta.dmg 
PPC: http://download2.navicat.com/download/navicat9_premium_en_ppc_beta.dmg

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

We encourage you to send us your feedback at http://www.navicat.com/en/support/survey.html.

Should you have any question and require any assistance during the testing, please do not hesitate to contact our Support Center.

Navicat for SQLite Version 9 BETA Released!

We are glad to announce about the release of Navicat for SQLite version 9 BETA.

Major features at a glance:

- Support of SQLite version 2 and 3
- Management of SQLite objects
- Data Transfer between different SQLite databases
- Synchronizing data between different SQLite databases
- Importing to SQLite from various formats
- Exporting from SQLite to various formats

Try Now?

Please download the trial version at:

Windows URL: http://download.navicat.com/download/navicat9_sqlite_en_beta.exe

Mac OS X URL: http://download.navicat.com/download/navicat9_sqlite_en_beta.dmg

Should you have any feedback, please don’t hesitate to tell us at http://www.navicat.com/en/support/survey.html.

Navicat feature tips – #2 Create Virtual Groups (3 versions support)

When you have more connections created in Navicat, sometimes it may not be easy to find a particular one in the navigation panel. With Virtual Grouping feature which is supported in Windows, Mac and Linux version, you can manage your connections into logical groups upon your preferences. This feature also applies to tables, views, functions, events, queries, reports, backups and schedules for your database. Thus, you can view connections and database objects in the navigation panel more convenient.

Step 1: Before adding connection and object groups, ensure the options “Flatten Connection Tree” and “Flatten Object List” are selected.

Step 2: To create a new group, right-click and select “New Group” from the “Manage Group” option.

Step 3: To move an object into a group, right-click the object and select “Move To” from the “Manage Group” option and select the target group.

Step 4: To move an object out of a group, right-click the object and select “Exclude from Group” from the “Manage Group” option.

Example: Connection Group (“Master Office”) and Object Groups (e.g. table group “Pets” and query group “Main_Query”) displayed in the navigation panel.

With the virtual groups created, you can organize your connections, or database objects is a more structured way and increase operational efficiency.

Navicat feature tips – #5 Transfer Database Objects between Different Servers by Drag and Drop Method (Windows and Mac support)

Have you ever concerned how to migrate your data from one server to other server without difficulties? Navicat can help you to do this. Navicat’s Data Transfer helps you to transfer your data in a convenient way. In Windows and Mac environments, you can simply use the drag and drop feature to start the Data Transfer process by just a few clicks. For Navicat Premium, you can also transfer data across different types of servers, for example, transfer data from a PostgreSQL server to a MySQL server.

Step 1: Select those tables you wish to transfer and drag them onto your desired server in Navicat main windows. Choose either to transfer those table structures with or without data.

Example: Migration of data from an Oracle server to a MySQL server.

Step 2: A Data Transfer window shows. You can also define the transfer behaviors under the “Advanced” tab.





Step 3: Click Start when everything is ready.



With the drag and drop feature and cross server transfer feature, you do not need to worry about how to set the transfer setting and the structure difference of data between servers. Navicat can do this for you.

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.