Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [navicat]

9 questions
2
votes
1 answer

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 postgres instance with same host, user and password with…
Jorius
  • 121
  • 1
  • 3
2
votes
1 answer

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 noticed by default LocalDB server always creates an…
Bikash Behera
  • 123
  • 1
  • 4
2
votes
2 answers

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, executing the dump file on my Test Server (or…
Ricky
  • 121
  • 2
2
votes
1 answer

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 restart MySQL after which the query runs in a…
Aunt Jemima
  • 133
  • 1
  • 9
1
vote
1 answer

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

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 clearing target db, and doing a full migration, is…
Djensen
  • 139
  • 4
1
vote
1 answer

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

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.
Nawaz Khan
  • 11
  • 2
1
vote
1 answer

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; I'm sure the syntax is correct, but it doesn't…
André Christoffer Andersen
  • 217
  • 1
  • 7
0
votes
1 answer

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 this diagram with my team, in any image or…
Liam
  • 111
  • 1
  • 6
-1
votes
1 answer

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 | | Carla | 25 | O | +-------+-----+------+ I…
ThatsANo
  • 1