Questions tagged [navicat]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
2answers
66 views

why I couldn't use my sub query as a table

I want to use a sub query as a table, but I have a problem with that because it shows an error that say Table 'alias-name' doesn't exist. SELECT * , find_in_set( `negative_marks`, (...
-1
votes
1answer
190 views

Navicat: import data from another server without problems

I have a table on another server that is formatted with millions of rows like this. +-------+-----+------+ | Name | Age | Type | +-------+-----+------+ | Adam | 29 | A | | Bob | 18 | B | |...
2
votes
1answer
1k views

Unable to Connect LocalDB Server in Navicat Premium

I've installed LocalDb server on my PC. I am trying to create a connection to the LocalDB server in Navicat Premium. I am unable to get the correct Host Name/IP Address for the LocalDB server. I ...
1
vote
1answer
39 views

Database migration program, that can analyze source and target db, and tell diff [closed]

I'm looking for a program that can help with migration of both database schema and data from a source db, to a target db. And it has to be able to do it while target db stays live, all the time. So ...
1
vote
1answer
639 views

How to resolve TNS error in Oracle 11g when connect with Navicate) [closed]

I want to connect Oracle11g with Navicate, but when I make a connection he display a error Ora-12514: TNS: Listener does not currently know of service requested in connect descriptor.
2
votes
2answers
1k views

What's the fastest way to execute a MySQL Dump of a large Database?

I currently have a rather large database that I create dumps from the our websites Live Server to my Test Server (and vice versa). Creating the dump is fairly quick (takes about 30 seconds). However, ...
2
votes
1answer
102 views

Why might a query not run until after I restart the MySQL server?

Why might MySQL not execute a query? Why might it freeze? It simply sits there and does nothing. Show processlist gives a result of "sending data" for as many hours as it takes for me to give up and ...
1
vote
1answer
452 views

How do I in “Navicat for PostgreSQL” run a simple PL/pgSQL script like I would in MS SQL Server Management Studio?

I don't want a function or anything. I just want to run/test a simple script with some PL/pgSQL features in it. Something like the following: IF 1=1 THEN SELECT concat('Hello', 'World'); END IF; ...