A portable database manager and SQL client that helps you to connect to the database you want, then manage its tables and triggers with ease
What’s new in DBeaver Portable 21.0.0:
- Main changes since 7.3:
- Big number of improvements in data transfer tool (insert or update, types mapping, ordering, etc)
- Spatial viewer: 3D objects support, custom tiles, SQLite support
DBeaver Portable is a straightforward and reliable piece of software geared towards users who need to manage multiple SQL databases, execute SQL scripts, migrate connections and view diagrams.
Compatible with multiple database systems
Irrespective of which database you choose to connect to, be it MySQL, Firebird, MS Access, PostgreSQL, SQLite or DB2, to name a few, the application supports multiple connections so you can easily manage and organize tables, views, triggers and procedures.
When you launch DBeaver Portable for the first time, you can choose a new connection type, then specify the information that allows you to connect to the selected database. After that, the ‘Database Navigator’ panel, located in the left pane of the application, displays all of the available databases alongside their triggers, indexes and tables.
In case you select a table, you are able to view general details about it such as columns, foreign keys, used triggers, partitions and even DDL syntaxes (which are used to define data structures, especially database schemas).
Create SQL scripts with ease
The ‘Projects’ panel allows you to view all of the available connections, as well as the created scripts. Additionally, you can create new SQL scripts by using the proper option from the ‘SQL Editor’ menu.
By accessing the ‘Database’ menu you are able to add a new connection, change the transaction mode to ‘Serializable’, ‘Repeatable read’ or ‘Read committed’. Also, you can manage the ODBC driver for each database by using the ‘Drive Manager’ option. This way, you can specify the driver name, select its category, set its sample URL address, then add new libraries. Such drives work as a translation layer between the application and the DBMS so you can connect to specific databases with ease.
Being a portable utility, you can carry the application with you wherever you go on a removable drive and use it on any computer. Hence, it does not create registry entries and you can remove it simply by deleting its containing folder.
To wrap it up, DBeaver Portable proves to be a steady and effective solution when it comes to managing multiple database connections, triggers, procedures and views, as well as executing SQL scripts, from simple to complex.