recently, we are studying NAVICAT premium, a third-party software. He is a three-party database management software. I used this software to call the database on the server in the previous internship, just. There was no detailed study at that time. Encounter this software again. I decided to summarize it in detail.
What does it do?
Navicat Premium is a multi-connection database management tool that allows you to connect to MySQL, Oracle, PostgreSQL, SQLite, and SQL Server databases at the same time as a single program, making it easier to manage different types of databases.
Navicat Premium combines the functionality of other NAVICAT members.
With the connectivity capabilities of different database types, Navicat Premium supports data transfer between MySQL, Oracle, PostgreSQL, SQLite, and SQL Server.
It supports most of the features of MySQL, Oracle, PostgreSQL, SQLite, and SQL Server.
Navicat Premium allows you to easily and rapidly transfer data between various database systems. or transfer a plain text file that specifies SQL format and encoding. This simplifies the process of migrating data from one server to a type that also has a single server. batch jobs for different databases can also be scheduled and executed at a specified time.
batch jobs for different databases can be scheduled and executed at a specified time. Other features include Import Wizard, Export Wizard, query creation tool, report creation tool, data synchronization, backup, work plan, and many others.
That is, we can connect multiple databases at the same time through Navicat Premium. or multiple servers on the database, in our cooperation in the development of the time, very useful.
How to use it?
First, download the software and install it. (This very easy, online has a lot of this software, as well as different version numbers.) Choose one you like, download use)
Then, open the software and go to the main interface, for example, as seen. Select the database you want to connect to (here is the MySQL example).
Select MySQL. And then. Fill in the database name and password you want to connect to. Test the connection first, assuming success. is determined. Otherwise, change your input.
(for example, connect a local database.) For example, as seen)
Summary:
Macro understanding and understanding, is the first step to use, Navicat is a more useful software. The space is relatively small, useful and more convenient. Manipulating databases through Navicat is faster. function is also more intact. Other strengths. I am still in the excavation ...
Navicat Premium uses--navicat to connect to MySQL database