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
2
votes
4 answers

2003 - Can't connect to MySQL server on 'localhost' (10038)

I installed mysql server in my ubuntu virtual machine, then I use Navaicat for Mysql to connet mysql, but failed. Navicat for Mysql is installed on Windows 7, Navicat version is 11.0.10, enterprise edition mysql is installed in my virtual machine,…
Y.L.
  • 1,274
  • 6
  • 23
  • 39
2
votes
1 answer

Using variables in PostgreSQL function

I get this error when I try to run a custom PostgreSQL function: ERROR: query has no destination for result data PostgreSQL functions are very new for me. I am working with Navicat for PostgreSQL 11.0.17. I have a table named translations with…
James Newton
  • 6,623
  • 8
  • 49
  • 113
2
votes
2 answers

Do length and decimals settings matter for datetime or int columns?

I use the Navicat MySQL GUI and have noticed there are Length and Decimal settings for all columns: I understand the how the length and decimals settings work for float and decimal data types, but do they matter for other column types such as int…
Nate
  • 26,164
  • 34
  • 130
  • 214
2
votes
1 answer

NTILE function error in Navicat MySQL

I am trying to using the NTILE function to create deciles in a dataset using Navicat for MySQL. My query is: select NTILE(10) over (order by 'amount') decile, * from dataframe d order by 'amount'; I get the error [Err] 1064 - You have an error in…
user3491704
  • 23
  • 4
2
votes
2 answers

Restoring Navicat backup files

I have made the backup from Navicat files in following formats: *.backup *.nppb *.ncx How can I restore the tables?
A Kntu
  • 689
  • 2
  • 8
  • 13
2
votes
2 answers

SQL Query - Adding total amounts from multiple tables

I'm working on a project for a client and require the total sum of 3 different columns on 3 different tables where the status of these amounts is stated as "Cleared". The three tables are (as an example): PAYMENT1 ID | Amount | Status 1 | 200 …
James
  • 165
  • 1
  • 3
  • 8
2
votes
2 answers

How to make Navicat mySQL (Non-Commercial) tables default to InnoDB engine?

I have Navicat mySQL Non-Commercial version. Whenever I create a table, it defaults to the myISAM storage engine for each new table , how do I make tables default to InnoDB engine without having to explicitly select these for each new table…
SobiborTreblinka
  • 575
  • 6
  • 21
2
votes
2 answers

Simple way to duplicate a record in Navicat

The natural instinct would be to copy/paste the entire row as one would do in MS Excel or other spreadsheet app. But: Unique primary key / UNIQUE INDEX fields cannot be duplicated. If one of the fields has line breaks in it (e.g. a chunk of HTML…
Geo
  • 12,666
  • 4
  • 40
  • 55
2
votes
1 answer

can't connect to remote mysql database via navicat

I have a mysql database on an unmanaged rackspace cloud server. I can connect to phpmyadmin with no issues. I checked if port 3306 is listening and it is. /etc/mysql/my.conf shows bind-address = 127.0.0.1. When I use navicat to connect via ssh, it…
Jared Eitnier
  • 7,012
  • 12
  • 68
  • 123
2
votes
0 answers

Navicat Premium reports syntax error while MySQL works?

Hi when i was using Navicat premium for my database it reported syntax error for this sql file : SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `mounts_id` -- ---------------------------- DROP TABLE IF EXISTS…
StaticNova
  • 21
  • 4
1
vote
2 answers

How to check if a foreign key is created

I have created a foreign key with NaviCat (a MySQL application), but the instant I create it, it disappears from the foreign key list and a new Index get added. Does that mean something went wrong or is that normal to happen? I have tried using the…
Gijs P
  • 1,325
  • 12
  • 28
1
vote
0 answers

How to begin an Oracle transaction in Navicat

I'm trying to have a transaction for simple queries written in Navicat Premium, when using a Oracle database: ALTER TABLE "APPLICATIONS_EXTENSION" ADD CONSTRAINT "APPLICATIONS_EXTENSION_F01" FOREIGN KEY ("APPLICATION_ID") …
Teejay
  • 7,210
  • 10
  • 45
  • 76
1
vote
3 answers

error in navicat lite mysql gui : Unknown column in 'field list'

I am using navicat lite with mysql database. my database is test and i have a table named transactions with schema: date, sharename,buyORsell,quantity,finalrate I am trying to create a new procedure which takes some input and outputs some results,…
xyz
  • 8,607
  • 16
  • 66
  • 90
1
vote
1 answer

Navicat MySQL MacOS Code Complete on keypress?

I find Auto-complete very good on Navicat, but how I can show autocomplete on keypress? (I mean shortcut for it?) I see it just need to wait.. but I want to press some keys and activate it.. Can I? And How?
woozly
  • 1,363
  • 1
  • 14
  • 24
1
vote
2 answers

Can't connect Navicat to SQL Server database

I've installed NAVICAT app to connect to a Microsoft SQL Server database. When I try to connect, it says ODBC driver not found: If I try to connect using HEIDI app, I have no issues. Settings in Heidi: Can you help me please?
UcanDoIt
  • 1,775
  • 7
  • 20
  • 27
1 2 3
…
24 25