XZ

Xiao Z's blog

Learn, build, share

DBeaver: A Powerful Tool for Cross-Database Management

dbeaverdatabase management toolnavicat alternativefree database softwaredatabase configuration migration
Published·Modified·

Many developers are familiar with Navicat Premium, an efficient database management tool. However, since Navicat Premium is paid software with a high price, users often have to choose between purchasing the legitimate version or using an unauthorized cracked version. Using cracked software can pose serious security risks and is therefore not recommended. As an alternative, xiaoz recommends DBeaver—a powerful free universal database management tool. Its functionality is on par with Navicat Premium, making it an excellent substitute.

Database Types Supported by DBeaver

DBeaver supports a wide range of database types, including MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, and many others, covering both common and less common databases. The number of supported databases is extensive; for a detailed list, please refer to the screenshot below.

Downloading DBeaver

DBeaver is available in Community and Enterprise editions. The Community edition is free to use and supports the three major operating systems: Windows, macOS, and Linux. You can download it from the following link:

Configuring a Proxy for DBeaver Downloads

DBeaver does not include database drivers by default. When connecting to a database, it will automatically prompt you to download the necessary drivers. However, downloading drivers within China can be very slow due to network restrictions. You can improve the download speed by setting up an HTTP proxy.

Open the "Window" menu, go to "Preferences" > "Connections" > "Drivers", and configure the HTTP proxy as shown in the image below.

Configuring Migration

To back up your DBeaver database connection configurations and import them to another computer, follow these steps:

  1. Backup Configuration Files:

    • Open DBeaver.
    • Locate the workspace directory. This is usually specified when DBeaver is installed. If you are unsure of the location, you can check it in Window > Preferences > General > Workspace.
    • Inside the workspace directory, find the .metadata folder under the General folder.
    • Copy the .metadata folder. This folder contains all your database connection configurations.

  2. Restore Configuration on Another Computer:

    • Install DBeaver on the new computer and open it to create a new workspace.
    • Close DBeaver.
    • Paste the copied .metadata folder from the original computer into the same workspace directory on the new computer, overwriting the existing .metadata folder.
    • Reopen DBeaver. You should now see all your original database connection configurations.

  3. Important Notes:

    • Ensure DBeaver is closed before performing any file operations to avoid conflicts with active configuration files.
    • After backup and restoration, verify the connection configurations, especially those involving specific paths or requiring specific permissions.

By following the steps above, you can easily migrate your DBeaver database connection configurations from one computer to another.

Cost Savings

The above is a basic introduction to DBeaver, recommended for developers and operations personnel. Whether you are looking for a cost-effective alternative to Navicat or a management tool that supports multiple databases, DBeaver is an ideal choice.