Altova DatabaseSpy Professional Edition

Altova DatabaseSpy Professional Edition is complex, yet easy to use tool for database management and manipulation. The software features advanced functions that allow you to create queries, design new tables or add SQL commands in source code format. The software can display the detailed structure of any database.

Altova DatabaseSpy Professional Edition allows you to connect to one of the supported database servers, load the desired tables, then proceed to editing them. The software facilitates the table and column editing by offering you a graphic manipulation tool, which allows you to create or modify any structure within a database. You may easily create new relationships, convert existing tables or data types.

Of course, you may change the structure of a database using the SQL script editor, as well as edit the tables with the help of the visual representations. The software can automatically adjust syntax and display pop-up boxes with suggestions or selection options. The SQL statements are automatically adjusted by the software, when you make changes in the graphical editor.

Altova DatabaseSpy Professional Edition also allows you to generate queries or compare the data in tables columns, even entire databases. Moreover, the software supports automatic or manual table/column mapping. You may save the changes created in the graphic designer or in the SQL editor in individual files, or export the desired tables to one of the supported formats: XML, XML Structure, CSV, HTML or Microsoft Excel.

Altova DatabaseSpy Professional Edition allows you to access a multitude of database servers, using either the ADO or ODBC direct connections. The main database servers are supported: Microsoft Access, SQL Server, Oracle, MySQL, IBM DB2, IBM Infomix, Sybase, PostgreSQL. However, you may create custom connections, using ADO, ODBC or JDBC methods.

Altova DatabaseSpy Professional Edition allows you to access any database and manipulate the information, data types, even tables contained within. The software allows you to work with the SQL script editor, as well as with a graphic designer and synchronize the changes in both cases. In other words, advanced programming skills are not required.

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