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

How to find matching values in two different tables SQL

I am trying to write a statement to find matching values from two different tables and set table 1 suppression to 1 if person_id from table 2 matches person_id from table 1 in SQL. Table 1 = id_num, person_id, phone_number, supression table 2 =…
Kyle
  • 29
  • 6
-1
votes
1 answer

SQL query to calculate age

I am trying to calculate someones age based off of birthday, birthMonth and birthYear. I would like to create an age column and calculate their age based off the 3 other columns stated above. Thank you
Kyle
  • 29
  • 6
-1
votes
1 answer

TypeError: not enough arguments for format string for my MYSQL Database

I have researched this question and I know what's wrong, it's just that I don't know how to reformat the "%s", sorry I am new to python. @app.route("/edit_camera", methods = ["GET", "POST"]) def editcamera(): camera_id = request.args.get('id')#…
whatshisname
  • 1
-1
votes
1 answer

pymysql.err.OperationalError: (1364, "Field 'CameraID' doesn't have a default value")

I am having a problem with MYSQL code. I cannot get my database to run when I try to enter a new camera into the database. Here is what I do: Then upon clicking submit, I am presented with the 1364 Error: Field "------" doesn't have a default…
markiplier
  • 23
  • 9
-1
votes
1 answer

Connect to Heroku Postgres through external application

I have a Heroku Ruby app, and I want to access the DB through Navicat, or pgAdmin, or similar. However, the thing that Heroku gives me as a DB URL doesn't seem to be a valid URL. Heroku tells me to use: heroku config:get DATABASE_URL -a your-app…
Brian Postow
  • 11,709
  • 17
  • 81
  • 125
-1
votes
1 answer

Syntax Error when retrieving data from database by joining two tables in Hibernate Sql

String query ="From transaction JOIN outlet transaction.outlet_ref_id = outlet.outletid WHERE(transaction.added_date_time between'"+sdate+"' and '"+edate+"') and (outlet.merchant ="+merchantId+")"; This is the query I'm using to retrieve data from…
Toshan
  • 23
  • 2
  • 9
-1
votes
3 answers

check the manual that corresponds to your MySQL server version for the right syntax to use near 'AUTO_INCREASE PRIMARY KEY

In my Navicat Premium: I run the below code in Query Editor: CREATE TABLE employee( id INT AUTO_INCREMENT PRIMARY KEY, empName VARCAHR(20), deptName VARCAHR(20) ); But I get the error: Error : You have an error in your SQL syntax;…
lme
  • 59
  • 3
  • 17
-1
votes
1 answer

Why is this my sql statement wrong in the navicat?

INSERT INTO ry_useraccount ( 'Id', 'UserId', 'FreeAmount', 'PayFrozenAmount', 'WithdrawFrozenAmount', 'CurrentAsset', 'CreateTime', 'UpdateTime' ) VALUES ( '1', '52501', '600', '0', '0', '0', NOW(), …
Farb
  • 468
  • 6
  • 11
-1
votes
1 answer

how can i join the two different query statement,which contain different table ,column name

SELECT bookingReference, SUM(amount) FROM rates_Booking WHERE date BETWEEN '2016-09-01' AND '2016-09-30' GROUP BY bookingReference; SELECT booking_type.`name` as booking_type FROM booking_type LEFT JOIN booking ON…
P.Sam
  • 1
  • 1
-1
votes
1 answer

How to connect to the SQLite database password using Entity Framework

my question is very similar to an already answered previously, the only diferncia is that I use Entity Framework. I developed an application in C # and I use SQLite with Navicat and I need to protect my database password. I was reviewing the answers…
Carlos Luis Peguero Cáceres
  • 7
  • 1
-1
votes
3 answers

Can't save and display data correctly

When I'm trying to add data in database and fetch it in data-grid, all the Sindhi characters turn in "???????????" as shown in figure. i think its because of coding i.e Unicode, ASCII etc, i don't know what coding is compatible for Sindhi and how to…
sam
  • 29
  • 5
-1
votes
1 answer

how to see existing trigger in nvaicat for oracle

i am trying to create a trigger like CREATE trigger trg_DEPT_ORGS_id before insert on DEPT_ORGS for each row begin select DEPT_ORGS_id_seq.nextval into :new.dep_id from dual; end; but it is showing…
Rashid Jabbar
  • 11
  • 1
-1
votes
2 answers

Using comma/space in variable output

I'm trying to output a SELECT with comma or even space but I can't design the database structure to use commas och space. Database: Cash Varchar 255 Decimals 0 and Default 50000 (I want it to be 50 000 or 50,000) PHP: $id =…
Samuel Masih
  • 54
  • 1
  • 8
-1
votes
1 answer

Mysql queries extremely slow on my laptop

Hello everybody I have this kind of problem. I have downloaded and activated Mysql on my laptop, which is a normal notebook, and then I use a GUI and I am trying to learn how to use Mysql. I actually am at the very beginning so now I am importing…
user1951561
  • 119
  • 1
  • 1
  • 9
-1
votes
1 answer

mySql :: error in general variable error

Possible Duplicate: MySQL - Syntax Error in Strored Procedure Thanks, but if use variable :::::like this : IF NOT EXISTS( SELECT ReferenceID as ExistedRefID FROM filesrefrences WHERE RefrenceKey= pRefrenceKey) THEN INSERT INTO…
Raed Alsaleh
  • 1,581
  • 9
  • 27
  • 50
1 2 3
…
24
25