DtSQL

DtSQL is a straightforward and complete software solution that provides database administrators with a reliable means of managing multiple database connections, regardless of their type. It is, by definition, a program that can access most databases and can be used on all major operating systems.

The application comes bundled with various features and tools that can be used to search for specific objects such as tables, columns, primary keys, indexes, triggers, functions and sequences. Optionally, you are able to edit table data including binary / BLOB and CLOB data types.

Irrespective of the database you choose to work with, here referring to Firebird, Oracle, PostgreSQL, SQL Server, MySQL, SQLite, Derby, Informix or HSQLDB, to name a few, you need to make sure that all the ODBC drivers are properly installed. Because each database works only if the right drive JAR files are specified, you will surely need to know how these drivers actually work.

By accessing the ‘ODBC Data Sources’ option from the ‘Administrative Tools’ snap-in, you are able to choose a driver for which you want to set up a data source. However, there are some databases such as PostgreSQL, Oracle and SQL Server that have their own default configurations and login information, so novice users might get stuck when connecting to such databases.

The program’s interface matches the main idea behind the product: an intuitive and user-friendly GUI wrapped around a practical and reliable application that helps users to quickly manage and open multiple database connections.

After the connection is made, the left panel displays all of the available tables, views, indexes, constraints, functions and procedures, while the right panel allows you to view information about the selected database, included data types, keywords and functions.

Professional users can take advantage of DtSQL as well, considering that DML (Data manipulation language) and DDL (Data definition language) syntaxes are also supported. Executing SQL statements, restoring deleted database table rows, creating, renaming and dropping sequences become easier tasks when this program is used. And this is not only because of its intuitive window and well-organized menus, but also because of the complex database tools that it provides you with.

To conclude, DtSQL allows you to browse objects such as tables, columns and primary keys, execute SQL scripts, as well as export data to various formats such as CSV, XML, HTML or XLS.