Altova DatabaseSpy Enterprise Edition

Various computers are now connected, and not just through the Internet. Sure enough, the information superhighway is currently the main method to establish such connection, and even reach databases of interest. As such, Altova DatabaseSpy Enterprise Edition comes with support for an abundance of database types, and thorough editing capabilities.

It’s a good idea to keep your Internet connection active to be able to reach the desired database, unless it is located on LAN. The first window which greets you wants to help you set up a first connection. This can be done through a wizard, or by manually establishing ADO, ODBC, JDBC, ADO.NET, Global Resources, and PostgreSQL connections.

Needless to say that all appropriate database credentials need to be provided. The application comes with support for an impressive variety of database types, such as MS Access, MS SQL Server, Oracle, MySQL, IBM DB2, IBM Informix, Sybase, PostgreSQL, Firebird, SQLite, and Progress. In case of a successful connection, the application even provides suggestions to which database you can connect.

Once everything is set up, you can start working on existing databases, but you can also load existing database files to continue your projects. The interface cleverly presents the edit area, which supports multiple windows or tabs, and even includes syntax highlighting for better understanding of lines of code.

The application pretty much acts as a programming languages, with a built-in editor, side panel for easy navigation through project items, as well as the corresponding set of properties. Multiple item types can be created, such as data sources, SQL, design, data diff, schema diff, and favorites.

When you consider the code is all prepared, you can choose to execute the script, with content delivered in the output panel. You can export your database under various file formats, and even link custom, external tools you might need to develop your projects.

All things considered, we can state that Altova DatabaseSpy Enterprise Edition is a fully-fledged database management solution. It comes with support for quite an impressive variety of database types, editing is intuitive, and the set of tools all make it worth your while.

NOTE: You need to request a trial key in order to obtain an evaluation license.