A SQL editor and multi-database tool.
Altova DatabaseSpy 2015 is a multi-database query, design, and database comparison tool. It is capable of generating elegant charts directly from query results. This tool connects to most major databases easily. Activities like SQL editing, database structure design, database content editing, database schema and content comparison, and database conversion can all be done quite easily with this tool. It contains a customizable SQL auto-completion editor that helps SQL query development. These queries can be executed and they provide immediate results in one or more windows. The windows may be tabbed or stacked one on top of another. So that, appropriate formatting can be applied immediately you connect to a database, SQL formatting configurations are provided for each supported database. DatabaseSpy provides a wide variety of charting. These charts display the query results in a graphical manner. Line charts, bar charts, pie charts, area charts, and and other advanced formatting options are available.
A graphical design editor helps to view and edit the structure of all your databases. It lets you examine tables and relationships in an existing database. You can edit the tables to exactly suit your needs. Entire tables can be added and their column attributes specified. Relationships to other tables could be defined too. Data base compare and merge features are available. This helps locate changes, migrate differences, or synchronize versions of databases. Table contents, and or database schemas can be compared and merged. It will let you migrate entire database structures from one database type to another. The SQL editor automatically adjusts for syntax differences between databases.