• Online database browser – gives you the opportunity to explore your database content or structure. You can connect to multiple databases simultaneously so you can compare structures and content.
• Support of views and stored procedures – will let you edit and manage these resources the same way that you explore tables in the hierarchical display.
• SQL Refactoring menu – lets you reformat existing SQL statements and scripts to facilitate moving scripts between SQL dialects, for instance.
• SQL formatting dialog – lets you define personal preferences for formatting new SQL statements as they are entered.
• Graphical design editor – has been enhanced to add new operations to create keys, indexes, and constraints, making it easier to define table relationships in the design view.
DatabaseSpy provides simplicity at an affordable price. Its ability to work with both designing and editing tables, as well as the ability to write SQL, make it a must have product for someone who works with databases, and especially for those who work with multiple platforms of databases.
While it has the ability to export to XML, HTML, CSV, and Excel, the one thing that I wish it had was the ability to move data from one database/table to another in a direct manner. On the other hand, making connections is easy, working with and modifying the tables is easy, as is working with SQL editing.
The true power of DatabaseSpy is its ease of use, the ability to connect to many different types of databases without having to have a specific license, and its inexpensive price. If you work with databases, you will find that DatabaseSpy 2008 is a much needed tool.
DatabaseSpy 2008 is available from Altova for $149.00 USD. It is also part of the combination MissionKits that are available. Still unsure, you can download a 30-day trial version as well.
Article comments