Altova DatabaseSpy 2009

Altova DatabaseSpy 2009 offers an effective tool which helps connect to all major databases, easing SQL editing and database structure design, 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 even 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 easily write SQL scripts that 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 or duplicate existing structures in differing database types.

DatabaseSpy supports Microsoft SQL Server, IBM DB2, Oracle, Sybase, MySQL, PostgreSQL, and Microsoft Access. DatabaseSpy lets you compare and merge the contents of 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 the 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. With all this capability and more, DatabaseSpy is sure to save you time, simplify your work, and ensure accuracy for all your data.

It is the one tool to finally liberate data management. Download Altova DatabaseSpy 2009 today, and try it free for 30 days.

Major Features:

1. Connectivity to all major databases
2. Quick connect wizard
3. Database project manager
4. Online database browser
5. Database content editor
6. SQL editor with SQL auto-completion
7. SQL formatting and SQL refactoring
8. Graphical database design tool
9. Database table compare and merge tool
10. Support for XML in databases
11. Support for editing views and stored procedures
12. Data export and import tool
13. Support for Altova Global Resources
    

Enhancements:

• Database content comparison and merging
• Native support for additional databases
• Support for XML fields in SQL Server
• Asynchronous Query Execution
  

Requirements:

• Pentium III processor
• 800 MHz recommended
• 64MB RAM
• 50MB available on hard-disk