Tuesday, March 30, 2010

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:

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

Thursday, March 11, 2010

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.

Thursday, March 4, 2010

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.