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.