Altova DatabaseSpy Professional Edition

This is a database tool that lets you query, design and to compare databases.

Altova DatabaseSpy 2015 is a unique multi-database tool useful for designers, developers and administrators. This is a tool that will let you query, design, and compare databases. It presents value added charts directly from query results. The tool is designed to connect to all major databases. It is easy to edit SQL queries and design database structure quite easily. Database content can be edited with this utility while comparison of the schema as well as data is possible. SQL editor has auto completion features that make query creation quite simple. When the query is executed, you could view the results in multiple windows that are tabbed or are presented as a set of stacked windows. Format configurations for each supported database is provided and automatically applied. If the database is switched, appropriate information will be applied.

Colorful and professional charts are used to communicate the meaning of the data. A wide variety of charting features are available that make graphical presentation of data quite meaningful. Line charts, bar charts, pie charts, area charts, and many more options are available. The graphical design editor lets you view and edit the structures of all your databases through its GUI. Tables and relationships in an existing database could be examined, tables can be edited, a complete table could be added by specifying all the column attributes and relationships to other tables, etc. This tool has a comparison tool that lets you locate changes, migrate differences, or synchronize versions of databases. Table contents and database schemas could be compared and merged easily. Most well-known databases are supported. This is a very good product.

Altova DatabaseSpy 2016 Professional Edition is the unique multi-database data management, query, design, compare, and convert tool from the creators of XMLSpy. DatabaseSpy connects to all major databases, easing SQL editing and other database tasks for a fraction of the cost of single-database solutions. DatabaseSpy provides a straightforward database connection wizard and organizes connections and related project files to make accessing your databases and their components effortless. You can open connections to multiple databases at once, even databases of different types. It clearly presents tables, views, stored procedures, and data in convenient windows, and it also lets you directly edit database content. DatabaseSpy's SQL Editor facilitates query writing with code completion, syntax coloring, drag & drop editing, and more. You can retrieve data from multiple tables and display results in individual, named windows for maximum clarity. DatabaseSpy's powerful Design Editor enables graphical design and visualization of database structures or schemas. You can also use it to compare and convert existing structures in the same or differing database types. DatabaseSpy lets you compare and merge data in database tables, whether they are the same database type or equivalent tables in different databases. XML support includes advanced capabilities to inspect XML data in database tables and to manage XML Schemas used to validate that data. It exports data in five formats, including XML, XML Structure, CSV, HTML, and Excel, and imports data from CSV and XML files. DatabaseSpy connects to Microsoft SQL Server, PostgreSQL, Oracle, MySQL, IBM DB2, Informix, Oracle, Sybase, Firebird, MySQL, PostgreSQL, and Microsoft Access via ADO, JDBC, or ODBC drivers. With all this capability and more, DatabaseSpy is sure to save you time, simplify your work, and ensure accuracy for all your data. DatabaseSpy is available in 32-bit and 64-bit versions.