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

Using Navicat to create a Key on 2 column

I can create a Primary Key using Navicat in the Design Table section of the software. However, I cannot seem to create a key on 2 columns, which in MySQL statements will be something like CREATE TABLE casting(movieid INTEGER, …
Nyxynyx
  • 61,411
  • 155
  • 482
  • 830
3
votes
2 answers

How can i see my created stored procedure in Navicat for MySQL

I create stored procedure in Navicat for MySQL as follow: CREATE PROCEDURE myloop() BEGIN DECLARE customerID INT DEFAULT 11; first_loop: LOOP SET customerID = customerID…
AKZap
  • 1,181
  • 6
  • 17
  • 31
2
votes
1 answer

Oracle STANDARD_HASH result show different result while using different platform

I get a problem when doing queries with different platforms using Oracle. The results of the query indicate the difference in output. First I used the "Toad for Oracle Database" application and the results like this: The results showed perfect…
Kusnadi
  • 75
  • 1
  • 10
2
votes
1 answer

mySQL Table Sync

I am looking for suggestions on the best way to sync mySQL tables (myISAM) from 2 different databases. Currently we use Navicat to sync tables from our production server to our test server but we have been running into many problems. Just about…
Bobby
  • 113
  • 1
  • 12
2
votes
1 answer

How can I change the name of the query result tabs in Navicat?

I'm running multiple queries at once and was wondering if I can assign different names to each of the tabs, so that the names are more useful than "Result 1", "Result 2", etc.
Luis Perez
  • 27,650
  • 10
  • 79
  • 80
2
votes
0 answers

How to use a Function in a View

I am trying to declare variables in my view, which i am finding out is not allowed. I need to be able to set each row a specific number based on an ID field. So if an ID field shows up 3 times it should count each Row as (1, 2, 3) and then when the…
Ezzy
  • 79
  • 1
  • 8
2
votes
3 answers

How to view tables in sql?

Hai i am a beginner of Database, i have a .sql file which contains some tables of data, i want to know how to import them and how to view the list of tables. presently im using the following:- software or editor : navicat lite server :…
Santosh Kumar
  • 21
  • 1
  • 2
2
votes
2 answers

First time installing but expiration date is in past Navicat

I just downloaded navicat, I did not use it before 101% so why I have expiration date in past? Is there a file on system where can I delete something if it somehow contains something that moves expiration date to 25.6.?
user8190318
2
votes
1 answer

Locking Navicat icon to Launcher

I am using navicat premium on ubuntu 15.10 with Wine. To Run navicat, every day I have to run the ./start_navicat bash file from terminal. How can I lock it on the Launcher ? and open with only one click in future.
user5620899
2
votes
3 answers

How to convert 2 digit CNT codes or full CNT names to 3 digit CNT codes in MySQL

I have a MySQL database table that contains a column named Country. Sometimes it's a full CNT name, sometimes ISO 3 or ISO 2. CNT code is depending on the source file used for this table. The country names are always written in uppercase (CANADA,…
Adela
  • 21
  • 1
2
votes
1 answer

Digital ocean on Laravel Forge - Unable to load key (navicat)

Im pulling my hair out with this one. I've managed to get a site running on Digital Ocean through Forge and also SSH into the server so I know that the SSH keys are setup correctly. But when trying to connect via Navicat, I keep getting the error…
Luke Snowden
  • 4,056
  • 2
  • 37
  • 70
2
votes
1 answer

How to use Navicat to connect to Postgresql socket via SSH?

While the SSH tunnel functionality in Navicat seems to work well if postgresql is running on a TCP port, it seems impossible for me to make it work when postgresql is accessible using a file socket?! Is this true, or I am missing something?
sorin
  • 161,544
  • 178
  • 535
  • 806
2
votes
0 answers

How to link oracle instant client to navicat

I am trying to link oracle client instant with navicat premium. I have a MacBook Pro 15 inches (64 - bit). I followed the instructions mentioned in these two links. 1) http://wiki.navicat.com/wiki/index.php/Instant_client_required 2)…
kimoturbo
  • 41
  • 1
  • 1
  • 8
2
votes
0 answers

Navicat not connecting to LocalDB

Suddenly, Navicat stopped connecting to LocalDB v11.0 database after working fine for a long time. If I move the same .mdf to SQL server, Navicat connects to it just fine, but not when the file is on LocalDB. Microsoft SQL Server Management Studio…
Nuts
  • 2,755
  • 6
  • 33
  • 78
2
votes
1 answer

Sql Server query executes insert twice instead of once

I am running a sql query INSERT INTO Items(ID,Name) VALUES (1,'test') INSERT INTO ItemsExtended(LanguageId,ItemId,IsMain,Name,IsVerified) VALUES (1,1,1,'test',1) the first statement fails with: [Err] 23000 - [SQL Server]Violation of PRIMARY KEY…
atikot
  • 4,761
  • 4
  • 26
  • 34
1 2 3
…
24 25