You could now use keyboard to navigate between tables and connections. We have implemented tab preview mode, which is used for quick preview of table or view data, stored procedure definition etc.

There are also singificant improvements in connection and database quick search. You could search by server or database name, even if server is not connected. You could use prefixed/partial search.

We added lot of new options to compare database models tool, you could ignore case, schema name, foreign key actions or data types. There is also new option to “soft delete” missing objects - marking with “deleted” prefix. The database comparison tool enables you to evaluate differences in database structure, making it an invaluable asset for maintaining consistency across various environments.

Unlike other database administration tools, DbGate has API for majority of lower-level operations. This feature could be used for various automation tasks, like imports, exports or deploying database model changes. DbGate API could be used without installation of DbGate, you could export scripts from DbGate and use the separately. New version brings huge improvements of this API, and also new documentation.

DbGate now supports parameters of stored procedure and functions. You could browse them in SQL objects tree, and even generate SQL template, which will ask user for missing parameters when executing.

There is much more improvements in recent 6.0 release. Thanks to the valuable feedback and reports from our users and the community on GitHub, we’ve resolved many issues and implemented lot of improvements.