Questions tagged [navicat]
The navicat tag has no usage guidance.
9
questions
0
votes
1
answer
3k
views
Can Navicat for MySQL export ER Diagrams?
I am using Navicat for MySQL 16.0.14 - Standard, on macOS.
I have used the ER Diagram view to create a useful diagram of an old database.
Is there any way to export this diagram?
I would like to share ...
2
votes
1
answer
3k
views
Navicat Premium doesn't show/list tables in postgres database schema
I have a local instance of postgres in my Windows machine, when I explore the databases and schemas in PgAdmin4 I can see every table and make queries and etc.
But when I connect to this same ...
-1
votes
1
answer
272
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
1
answer
3k
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
1
answer
49
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
1
answer
731
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
2
answers
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
1
answer
374
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
1
answer
657
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;
...