Altova DatabaseSpy

Category
Information Management
Automotive Information Databases

Review

Altova DatabaseSpy 2010 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 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 and convert existing structures in the same or 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. Easily load binary data from an external file, or save binary data from the database. 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.


Search

Recent searches