Stack Overflow
Stack Overflow

Questions tagged [navicat]

Navicat is a series of graphical database management and development software produced by PremiumSoft CyberTech Ltd. for MySQL, MariaDB, Oracle, SQLite, PostgreSQL and Microsoft SQL Server.

Navicat has an Explorer-like graphical user interface and supports multiple database connections for local and remote databases.

It's design is made to meet the needs of a variety of audiences, from database administrators and programmers to various businesses/companies that serve clients and share information with partners.

Navicat is a cross-platform tool and works on Microsoft Windows, Mac OS X and Linux platforms. Upon purchase, users are able to select a language for the software from eight available languages: English, French, Spanish, Japanese, Korean, Polish, Simplified Chinese and Traditional Chinese.

Versions

Navicat Premium

In 2009, PremiumSoft released Navicat Premium, a series of Navicat software that combines all previous Navicat versions into a single version and can connect to different database types including MySQL, Oracle, and PostgreSQL simultaneously, allowing users to do data migration between cross databases. Navicat Premium version also supports cross-platform administration, serving Windows, Mac OS X and Linux. In April 2010, version 9 of Navicat Premium was released, which added the connectivity of SQLite database to Navicat Premium, allowing Navicat Premium to connect to MySQL, Oracle, PostgreSQL and SQLite in a single application. In November 2010, support for Microsoft SQL Server was added. In January 2011, SQL Azure was included. In November 2013, added the support of MariaDB.

Navicat Essentials

Navicat Essentials was officially released in November 2011. This is a simple Navicat version for commercial use. The Essentials editions of Navicat lack several features found in the Standard/Enterprise editions, including form view, record filtering, visual query building, data modeling and options for import, export and backup of data, etc.

Navicat Data Modeler

Navicat Data Modeler Windows version was officially released in March 2012. Then, Mac OS X and Linux version were released in May 2012 and June 2012. This is a standalone product for developers to create data models for MySQL, SQL Server, Oracle, PostgreSQL and SQLite databases. Navicat Data Modeler allows users to visually design database structures, perform reverse/forward engineer process, import table structures from ODBC data sources, generate SQL files and print models to files, etc.

Navicat iOS

In August 2014, PremiumSoft released a new product - Navicat iOS. It is a database administration tool developed for iOS with features included object viewer & designer, query builder & editor, Navicat Cloud, server monitor, etc. MySQL was supported in the first release. Then, Navicat for PostgreSQL iOS version was released in January 2015.

Features

Navicat's features include:

  • visual query-builder
  • SSH and HTTP tunneling
  • data and structure migration and synchronization
  • import and export and backup of data
  • report builder
  • task scheduling and wizards tool

There are differences in the features available across operating systems. Navicat also supports forks of MySQL such as Drizzle, OurDelta, and Percona.

Navicat is shareware tool with 30-day trial. Latest version is 12.*.

367 questions
4
votes
3 answers

What's a quick way to comment/uncomment lines in Navicat query editor?

In Navicat, how do I enclose a selection in a comment? Is there a keyboard shortcut for this action?
abg
  • 2,002
  • 7
  • 39
  • 63
4
votes
4 answers

How to get auto increment work on NAVICAT

I am using NAVICAT to make tables for MYSQL and I am unable to find the auto-increment attribute option for my primary key column. id integer(10)(auto_increment)primary key Anyone pls help me out!
rahul
  • 205
  • 3
  • 6
  • 12
3
votes
1 answer

how to connect navicat to mysql on aws EC2?

When I tried to use navicat to connect mysql on AWS, it always reject the connection. I'm sure my IP address is correct and the port is correct as I checked on EC2 for several times. Also the username and password are correct too because I can log…
BKBK
  • 31
  • 3
3
votes
2 answers

MySQL server has gone execute large script files

Please help me to get rid of this errors While i run some large number of mysql scripts at once i got this kind of errors ERROR: 2006 MySQL server has gone away Error: 1153 Got a packet bigger than 'max_allowed_packet' bytes How to get rid of…
thechoosenone
  • 129
  • 2
  • 8
  • 16
3
votes
0 answers

Docker-compose postgres table not showing up on Navicat

I have a docker running and everything is okay, my app running well. but, I can't show my table on Navicat. even though it's showed up on pgAdmin. I've no idea what to do. Edit I can do a query, but the table still not showing.
Ananda Bayu Putra Yudhistira
  • 321
  • 4
  • 14
3
votes
0 answers

ERROR: column "increment_by" does not exist - Postgres 10 and Navicat for Postgres

I recently upgraded my Postgres version from 9.4 to Postgres 10. All the apps that interact with the database behave themselves except my Navicat for Postgres. When I try to do any with sequences in Navicat, I get this error: SELECT last_value,…
adrian
  • 2,786
  • 2
  • 18
  • 33
3
votes
1 answer

How to connect MySQL 8.0.x using Navicat?

I have installed MySQL 8.0.4, but my Navicat for MySQL can not connect it, the warning is: 1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client. How do I fix it?
Richard Tian
  • 73
  • 1
  • 5
3
votes
1 answer

Where I can choose the unique value when I add a field in table - Navicat

In my navicat, I want to add a field, but I think its value should be unique. But in navicat, I can not find a way or option to choose, like Not Null or Character Set. So, where is the unique option in Navicat for a field?
s-n-2
  • 405
  • 1
  • 6
  • 24
3
votes
1 answer

PostgreSQL: column "rolcatupdate" does not exist error?

I installed PostgreSQL on new server. When I try create new table or new data base, get this error: column "rolcatupdate" does not exist. How can I fix it?
igorb0214
  • 67
  • 2
  • 2
  • 9
3
votes
4 answers

Higher speed options for executing very large (20 GB) .sql file in MySQL

My firm was delivered a 20+ GB .sql file in reponse to a request for data from the gov't. I don't have many options for getting the data in a different format, so I need options for how to import it in a reasonable amount of time. I'm running it on…
Jonogan
  • 31
  • 1
  • 2
3
votes
1 answer

How do I connect to NearlyFreeSpeech-hosted MySQL database remotely?

What URL/hostname/IP address to I use to connect to a MySQL database hosted by NearlyFreeSpeech? What port? I want to use Navicat or a similar program to do this. I know the username and password.
Generic_User_ID
  • 1,067
  • 2
  • 13
  • 16
3
votes
1 answer

Navicat - Beautiful SQL keyboard shortcut

Is there a short cut to Beautiful Query in Navicat ? I could not find any in the documentation. Still wondering, if there is any
Ajeesh Joshy
  • 1,387
  • 2
  • 18
  • 32
3
votes
1 answer

Navicat vs. Toad SSH Tunneling

I am trying to connect to a MySQL server on an AWS instance, using Toad w. SSH. For reference, I have the following configuration setup in Navicat for MySQL: General Tab: ---------- - Connection Name: localhost_3306 - Host Name/IP Address:…
user1997614
  • 97
  • 1
  • 9
3
votes
1 answer

Install Navicat on Linux Ubuntu 12.04

How do I install Navicat on Ubuntu Desktop 12.04? I have just configured a new Ubuntu 12.04. Because I'm not so familiar with the command line, I prefer to use Ubuntu Desktop so that I can have a GUI. Now I need to install a front-end to connect…
DanielAttard
  • 3,467
  • 9
  • 55
  • 104
3
votes
1 answer

Using Navicat to login to Postgresql via SSH - what are the correct settings?

I am trying to log into PostgreSQL on my EC2 server via SSH using Navicat. I get the following error message: "80070007: SSH Tunnel: Socket error on connecting. WSAGetLastError return 10061($274D)" On the server, the "role" postgres already exists,…
user1760025
  • 287
  • 1
  • 4
  • 10
1 2
3
…
24 25