19
Jun 13

Time-limited Promotion! 20% off on Navicat new licenses

To celebrate the launch of Navicat 11, we are offering a 24 Hours Promotion* on Navicat new licenses.

For every purchase of Navicat new licenses, customer will enjoy 20% discounts, ends on June 19, 2013 (11:59PM ET).

Don’t miss this offer, visit our Online Store and shop now!

New key features in Navicat 11

  • Native 64-bit version #
  • Brand new UI design
  • Enhanced Connection Tree with filter
  • Multi-cell Edit and Box Selection ^
  • Docking system, support Aero Snap ^
  • Over 100+ new features and improvements

# Only available in Windows and Mac OS X version.
^ Only available in Windows version.

*Promotion ends on June 19, 2013 (11:59PM ET).
*The discounts only valid on buying new license of Navicat, including Commercial and Non-Commercial versions.
It does not apply to Essentials license, Navicat Report Viewer, Upgrade license, and software maintenance license.

Copyright © 1999 – 2013. PremiumSoft™ CyberTech Ltd. All rights reserved.


{ 4 comment }
MySQL, Navicat Premium, Oracle, PostgreSQL, SQL Server, SQLite

29
Apr 09

New versions of Navicat are released for Mac Users

New versions of Navicat for Mac Users are released on April 27. The three new releases on Mac are:

• Navicat for Oracle (Mac OS X) Version 8.0.6
• Navicat for PostgreSQL (Mac OS X) Version 8.0.6
• Navicat for MySQL (Mac OS X) Version 8.0.6

Navicat for Oracle v8.0.6 is a major release from PremiumSoft.

Below shows the major enhancements in the new release of Navicat for Oracle (Mac OS X) Version 8.0.6:
• Support of exporting Excel file
• Support of ODBC Import
• Support of Form View
• Support of Simple Code Completion in SQL Editor
• Ability to send notification e-mail for schedule task, with an option to attach file from Export Wizard
• Support of creating table, view, import/export profile shortcuts on desktop

Besides, the release of Navicat for PostgreSQL v8.0.6, also marks another enhanced user experience of database administration on PostgreSQL databases. In this new version, the following enhancements have been made:
• Enhanced support of PostgreSQL version 7.3 to 8.3
• Support of Form View
• Support of Code Completion in all SQL Editor
• Support of ODBC Import
• Support of exporting data to Excel file
• Support of View, Store Procedure, Sequence, etc, in Structure Synchronization
• Ability to send notification e-mail for schedule task, with an option to attach file from Export Wizard
• Support of creating table, view, import/export profile shortcut on desktop
• Support of SQL Preview for object design forms

For more details on software releases, please see the release notes at http://oracle.navicat.com/soft_update_mac.html

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

{ 0 comment }
MySQL

25
Feb 09

Navicat for MySQL (Mac OS X) version 8 is released

 Here is a great news for Mac users. We have released Version 8 of Navicat for MySQL (Mac OS X) last week. The new release enhances the user experience of database administration such as support of Form View and Code Completion, this version also now supports import of data from ODBC source and supports the export of data to Excel spreadsheets.

Major new features include: 
- Enhanced support of new MySQL server versions
- Partitioning support for MySQL 5.1
- Support of Form View
- Support of Code Completion in all SQL Editor
- Support of ODBC Import
- Support of exporting Excel file
- Support of View, Store Procedure and Event in Structure Synchronization
- Ability to send notification e-mail for schedule task, with an option to attach file from Export Wizard
- Support of creating table, view, import/export profile shortcut on desktop
- Support of SQL Preview for all object design forms
- More table/column properties can be adjusted in Table design form

For more details, please see the release notes at:
http://mysql.navicat.com/release_notes_mac.html.

To upgrade your existing license, please go to our Upgrade Center: http://support.navicat.com/upgrade.php

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

{ 0 comment }
MySQL

5
Nov 08

Connecting to your MySQL Database at GoDaddy with remote client, Navicat

Connecting to your MySQL Database at GoDaddy with Navicat

By default, remote access to MySQL database server is disabled for security reasons. However, some time you need to do remote connection to your database server from home, from web server or standalone clients.

With HTTP Tunneling, you will be able to connect to your remote MySQL Server easily when your hosting company does not allow remote connection and does not provide SSH Tunnel.

HTTP Tunneling is a method for connecting to a MySQL server that uses the same protocol (http://) and the same port (port 80) as a webserver does. This can be used when your ISPs do not allow direct connections to their MySQL server, but allows by establishing HTTP connections.

Using Navicat with HTTP Tunneling
With HTTP tunneling, you can establish a connection with your remote MySQL database server, and enjoy a set of useful features from Navicat which a web-based administration application cannot provide, including:

  • Ability to import data from various file types including Access, Excel, CSV, Txt, HTML, XML, Paradox, QuattroPro and data from ODBC Source, directly to your MySQL database without a touch of SQL query.
  • Building a query visually with the help of Query Builder.
  • Making use of the data in your database to generate Reports.
  • Synchronizing the data or schema between servers.
  • Scheduling of database operational tasks.


Establishing a HTTP Connection to your Remote MySQL Server with Navicat
To use this connection method, first thing you need to do is to upload the tunneling script – ntunnel_mysql.php to the webserver where your MySQL Server is located.To upload the script to your webserver, you will need a FTP client.Uploading the Tunneling ScriptStartup WS_FTP and configure the Session Profile Information.

    Profile Name:
    This is the name of the FTP session profile, and can be anything you desire to identify the connection you are creating.Host name/Address:
    The hostname for your webserver.

    Host Type:

    If you know the host type, select it from the drop down list. Otherwise, try Automatic detect.
    User ID:
    Username of your webserver.Password:
    Password of your webserver.


Select the Startup tab and enter Initial Directories for both Local and Remote system.

To upload the tunneling script:

    1) Browse the ntunnel_mysql.php on the source system.2) Open the directory to which you want to transfer files on the destination system.

Transfer the files using the left and right arrow buttons located between the list boxes, i.e. Click the right arrow button to transfer files from the local to the remote system.

GoDaddy Control Panel
In your GoDaddy Control Panel, Select Database > MySQL , you will then see the Database hostname in this page. This address will be the hostname you will need to place in the Connection Setting inside Navicat.
NavicatIn Navicat, Click the Connection button to new a connection.In the General Tab of the Connection Setting box:

    Connection Name: A which best describe your connection.
    Host name/IP address:
    A host where your MySQL Server is located.
    Port:
    The port of MySQL Server on Remote Host, by default, it is 3306.
    User name:
    MySQL Server user name.
    Password:
    Password of the MySQL user.

In the HTTP Tab in the Connection Setting box:

    1) Enable Use HTTP Tunnel.
    2) Enter URL of the tunneling script.

If the ntunnel_mysql.php is hosted in a password protected server or you have to access internet over a proxy server, you will need to provide the required authentication details.To test if the Connection settings are correct, you may click the “Test Connection” button to check.Connecting to your MySQL Database from remote client Navicat offers you a greater flexibility on working with your data in MySQL. With Navicat, you can easily import your data in to your MySQL database from various file formats, build queries visually, set a schedule to perform backup, generate report from your raw data and more.For more information on how Navicat helps you to manage your MySQL database effectively, please visit here: http://mysql.navicat.com/details.html


{ 3 comment }
MySQL

15
Oct 08

Connecting to your Remote MySQL Server in Dreamhost with Navicat SSH Tunneling

Connecting to your Remote MySQL Server in Dreamhost with Navicat SSH Tunneling

From time to time, we have received some support tickets to question about the exact connection settings to make a SSH Connection with their remote MySQL Server. The steps involve changes in the settings of your MySQL Server as well as the user account with your hosting company.

In today’s post, we’ll look into the configurations needed in MySQL and your hosting account to make a SSH Connection. We’ve used Dreamhost as an example and the steps are more or less similiar to any other hosting companies which provide SSH Connection.

Why we need to connect with SSH?
Many of the web hosting companies has blocked port 3306 to prevent access from outside, to defend against from security threats. As a consequence, users are required to use web-based client to access their MySQL Server provided by the hosting companies. These web-based clients are usually not visually appealing with annoying page refreshes. However, with the increasing demand from users to connect from remote MySQL clients, some web hosting companies provides SSH Connection which allows user to login remotely across the Internet and support connection through the software based clients.

SSH stands for Secure Shell and is a communication protocol for connecting to remote computers over TCP/IP. Encryption provides confidentiality and data integrity, and SSH uses public-key cryptography to authenticate the remote computer and to allow the remote computer to authenticate the user if necessary.

DreamHost provides shell access to all of its customers, but it needs to be specifically enabled for each user added to a customer’s account. By default, the Type of the user is set to be “FTP”, you will need to enable the shell access before you can connect through SSH.

Enabling the Shell access for an existing user:
1) In your Control Panel, Visit User > Manage Users.
2) Click the [ edit ] link located next to the user you’d like to enable shell access for.

3) Check the ‘Enable ssh/telnet?’ box for that user.
4) Leave the ‘Type’ as it is unless you need it to be something other than bash.
5) Click Save
Keep in mind that it takes about 20 minutes for this change to take effect.

After changing the user account to Shell Type, you’ll also need to grant rights for your local machine to connect to the database server, before you can connect remotely by Navicat. This must be done for all MySQL user accounts you plan on logging in from your local machine.

Granting rights for your SSH Host:

1) Login to your Dreamhost Control Panel
2) Select the Manage MySQL link under the Goodies section.
3) Under the Database(s) on this server section, find the desired database and click the username you wish to grant access to.
4) Under the section titled Allowable Hosts, type in the domain or subdomain or your IP Address the machine which your SSH Host identifies itself as on the public internet.
5) Click Save

You have completed the settings required in your Dreamhost account, now you will go to Navicat to create the Connection.

In Navicat, click the Connection button to New a Connection.

In the General Tab of the Connecting Setting box,

Hostname/IP address: the hostname of your mysql server at dreamhost, you can check this at Control Panel > Goodies > Manage MySQL
Port: 3306 (this is the default port number for the MySQL Server)
Username: username with access right granted in Manage MySQL section
Password: password

In the SSH Tab of the Connecting Setting box,

Hostname / IP Address: machine_name.dreamhost.com
Port: 22 (this is the port for SSH connection)
Username: username which you have changed the account to Shell type in Dreamhost
Password: password

To test if the Connection settings are correct, you may click the “Test Connection” button to check.

Connecting to your MySQL Database from remote client Navicat offers you a greater flexibility on working with your data in MySQL. With Navicat, you can easily import your data in to your MySQL database from various file formats, build queries visually, set a schedule to perform backup, generate report from your raw data and more.

For more information on how Navicat helps you to manage your MySQL database effectively, please visit here: http://mysql.navicat.com/details.html

{ 2 comment }
MySQL

7
Nov 07

PremiumSoft has achieved MySQL Gold Partner Status!

15 May 2007 – PremiumSoft, the developer of the World’s most popular MySQL GUI today announced it has joined the MySQL Partner Program (MECA) as a Gold Partner.

After a few inspiring years of cooperation with MySQL AB, the Gold Partner status is a recognition of the leading position of our database management tool.

Being a Gold Partner of MySQL, Navicat team will work closely with the MySQL community to ensure seamless compatibility between Navicat and MySQL and that Navicat will always be optimized to work with all versions of MySQL.

Joining the MECA program, we receive valuable training, support benefits, first hand information of innovative MySQL technologies and other benefits in the MySQL ecosystem, all these provide us with competitive advantage in the marketplace and enable us to offer the best support and quality product to million users of MySQL.

This partnership will give confidence to all new and existing Navicat users that Navicat team is committed to enhance and improve Navicat to maintains its No. 1 position in the database management software market.

{ 0 comment }
MySQL

6
Nov 07

PremiumSoft PARTNERS WITH SOLID

Hong Kong, 20 April 2007 – PremiumSoft CyberTech Ltd., developer of Navicat for MySQL, today announced that it has partnered with Solid Information Technology, the leading provider of fast, always-on and affordable databases used in more than 3,000,000 mission-critical deployments worldwide, as part of Solid? Technology Partner Program. As a Solid Technology Partner, PremiumSoft will work closely with Solid to ensure seamless compatibility between Navicat for MySQL and solidDB for MySQL.

As part of the partnership, the two companies have agreed to work together to provide industry leading database management solutions targeted to Enterprises. The companies will demonstrate the integration of solidDB for MySQL with Navicat, including support for solidDB tables and foreign keys, at the upcoming MySQL Users Conference 2007.

?artnering with the industry? leading MySQL solution providers PremiumSoft is the next step in expanding enterprise adoption of solidDB for MySQL and Navicat MySQL Enterprise,??said Paola Lubet, vice president, marketing, Solid Information Technology. ?hrough our formal Technology Partner Program, Solid is committed to contributing to our partners??success.??

?remiumSoft? partnership with Solid is a reflection of our ability to anticipate and meet growing demand for integrated MySQL tools and solutions that can support mission-critical applications,??said Ken Lin, CTO, PremiumSoft. ?his partnership additionally highlights PremiumSoft? leadership role in the broader open source community. We look forward to shared success with Solid.?

{ 1 comment }
MySQL

 
 
Copyright 1999 - 20011. PremiumSoft ™ CyberTech Ltd All rights reserved.