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
6
votes
1 answer

Setting auto increment id in Postgres with Navicat

I'm rather new to Postgres and Navicat is the only fully functional GUI that I've come across. That said, I'm trying to implement a simple auto increment for an id. Navicat doesn't seem to support bigserial or serial, or have anything in place to…
Nick Parsons
  • 8,377
  • 13
  • 48
  • 70
5
votes
1 answer

Open connection to SQLite secured database with navicat

I have a SQLite database and i managed to set a password from c#. _connection.ChangePassword("test"); and then i connect like: _connection = new SQLiteConnection("Data Source=" + Properties.Settings.Default.ConnectionString + …
ddarellis
  • 3,912
  • 3
  • 25
  • 53
5
votes
1 answer

MySQL sync between 2 databases and primary key clash

I have an issue with a development and production environment MySQL database. I want to merge the 2 databases, but since content authors have been adding records to the production environment, there are about 20 overlapping records with the same…
Anthony
  • 163
  • 1
  • 1
  • 6
5
votes
2 answers

SQL exclude rows matching all of multiple criteria

I currently have a query merging two tables to create a new one for analysis. After getting some funny results when trying to chart it for presentation, I learned that some of it is fake data that was never cleaned up. I've been able to identify the…
Minadorae
  • 301
  • 3
  • 5
  • 13
5
votes
3 answers

MySql stored procedure else if and multi queries

In the following stored procedure I encountered an error: DROP PROCEDURE IF EXISTS `SP_DeleteFileInfo`; CREATE PROCEDURE `SP_DeleteFileInfo`(pFileID int) Set @FileRef= null; select filesinfo.ReferenceID into @FileRef FROM filesinfo where…
Raed Alsaleh
  • 1,581
  • 9
  • 27
  • 50
4
votes
2 answers

Table relations in Navicat

How do I add table relations in Navicat without using SQL queries? Is there some kind of wizard or helper to do this?
steavy
  • 1,483
  • 6
  • 19
  • 42
4
votes
0 answers

NaviCat Data synchronization crashes

I have a database that contains around 170 tables and some of those tables can contain up to 300 million rows! When I launch the data synchronization, it uses so much RAM that it ends up crashing my laptop. Do you know if there's any solution by…
Oussama Boussif
  • 811
  • 2
  • 8
  • 13
4
votes
2 answers

Mysql remote connect over ssh to a kubernetes pod

Many devops use mysql connect over ssh to access to production database for various reasons and queries after successfull deploy mysql container to a digital ocean kubernetes cluster im able to ssh into the pod via : kubectl…
Sina Miandashti
  • 2,087
  • 1
  • 26
  • 40
4
votes
1 answer

PostgreSQL database not available through Navicat

I'm new to Postgres, not to SQL. I generally use Navicat to connect to my databases, so I've set up a connection to a remote Postgres DB the same way I normally would. I'm able to: Connect successfully List databases When I click on the database…
carbide20
  • 1,717
  • 6
  • 29
  • 52
4
votes
1 answer

Navicat for MySQL - How to copy fields name quickly?

In phpMyAdmin, I can highlight any fields name quickly to copy and paste it in the script (eg: php files) How do I do same process in Navicat?
I'll-Be-Back
  • 10,530
  • 37
  • 110
  • 213
4
votes
2 answers

How to get Navicat to ONLY show Default PostgreSQL Database

I have successfully connected to my PostgreSQL Database from Navicat Premium. However, when I open the connection I see a ridiculously long list of databases. I only need (and am only able!) to access one of these databases. I have it listed under…
TWGerard
  • 885
  • 1
  • 10
  • 24
4
votes
3 answers

Navicat utf8 not working on mysql database

I'm currently trying to merge data changes between two out of sync expressionengine databases. For this i have opted to use navicat. The website makes heavy use of the greek character set in templates. When I view greek table field data in…
Dimitri Shukuroglou
  • 363
  • 1
  • 5
  • 13
4
votes
2 answers

Navicat SSH Issues

I'm having trouble connecting to Navicat using an SSH Tunnel and seem to have all my ducks in a row, so wondering if anyone else who had done this has had success: I set up a normal (TCP) user and checked the connection (host, port, user, password,…
Mark H
  • 259
  • 2
  • 10
4
votes
1 answer

Navicat can't connect mysql server via ssh

I can connect the server via ssh and login the mysql via mysql -u root -h localhost -p without any problem. But why Navicat's ssh login doesn't work? Server Environment: Ubuntu 10.04.1 LTS mysql Ver 14.14 Distrib 5.1.67, for debian-linux-gnu (i486)…
Yad Smood
  • 2,752
  • 2
  • 24
  • 37
4
votes
1 answer

Some PostgreSQL databases not visible through clients like Navicat or pgAdmin

When I log in to see my remote PostgreSQL databases with pgAdmin or Navicat, I can connect without any problems, and the first three databases in the list below show up fine. But for some reason I can't get the last two databases ("template0" and…
jball037
  • 1,780
  • 1
  • 14
  • 18
1
2
3
…
24 25