#Universal database connector install#
Here we are installing it as a snap package from Snap store using snap install dbeaver-ce command as shown below. There are multiple ways to install DBeaver package. If any of the packages requires an upgrade then run apt upgrade command as well. On our Ubuntu 20.04 LTS Server, we are running PostgreSQL DB Server on localhost with below configuration:-īefore proceeding with the steps, let's make sure system is synced with the latest available updates from all the enabled repo using apt update command as shown below.
#Universal database connector how to#
How to Install and Use DBeaver Universal Database Tool on Ubuntu 20.04 LTSĪlso Read: How to Install kubectl on Ubuntu 20.04 LTS (Focal Fossa) Step 1: PrerequisitesĪ) You should have a running Ubuntu 20.04 LTS Server.ī) You should have sudo or root access to run privileged commands.Ĭ) You should have apt and snap utility available in your System.ĭ) You should have PostgreSQL DB Server installed and running.Į) Database Port 5432 must be opened from the Firewall if you have any. Ability to analyze and execute complex queries.It has the feature of Mock Data Generator which can generate random data for tables.Ability to import data directly from CSV file into database table.Ability to modify most metadata entities depending on the availability of database drivers.Ability to edit/rename/delete database connections and objects.Capability to work with various extensions for integration with Excel, Git and others.Ability to monitor database connection sessions.Provides the ability of data and schema migration.We will see how to install and use this database management tool in below section with the help of an example. It supports more than 80 databases which includes all the popular DB like MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, etc. DBeaver is a free and multi-platform database management tool for database administrators, developers, programmers and to all the people working with databases. In this article, I will take you through the steps to install and use DBeaver Universal Database Tool on Ubuntu 20.04 LTS.
0 kommentar(er)
