About Altova DataBaseSpy Enterprise Edition

A multi-database data management, query and design tool.

Altova DatabaseSpy is a multi-database query, design, and database comparison tool that even generates elegant charts directly from query results. It connects to all major databases, easing SQL editing, database structure design, database content editing, database schema and content comparison, and database conversion all for a fraction of the cost of single-database solutions.

Altova DatabaseSpy includes these robust and highly-flexible components and capabilities:

  • Connectivity to all major databases
  • Quick connect wizard  
  • Database project manager
  • Online database browser  
  • SQL editor
  • Database design editor  
  • Export and import functions 

Altova DatabaseSpy is designed to be the database professional’s multi-purpose tool, since it connects to all of the following database types:

  • Microsoft SQL Server
  • Microsoft Access
  • Oracle
  • IBM DB2
  • MySQL
  • Sybase

In fact, DatabaseSpy is designed to work with any database that uses an ADO or ODBC connection.

Once you have connected to a database, Altova DatabaseSpy lets you browse data or examine the database structure. You can select any table and retrieve all rows or select just a sample to inspect the table structure. You can even open multiple databases of different types at the same time to analyze their contents.

Simplify SQL Development

DatabaseSpy includes a built-in SQL Editor with auto-completion, syntax checking, color coding, and drag and drop editing to make generation of SQL statements faster, easier, and more accurate. The SQL Preview function lets you test single SQL statements or complex SQL scripts and see the results without risking permanent changes to your databases. DatabaseSpy also features a graphical Database Design Editor that permits visual design and creation of the structure of a database without the need for any knowledge of SQL syntax. You can drag and drop existing database tables into the Design Editor to modify them, or you can construct brand new tables from scratch. DatabaseSpy makes it convenient to organize database connections, SQL files, design files, and favorites into projects for easy management. Projects are organized into files and saved for quick reloading and reuse.

Databases to XML and other export and import options

DatabaseSpy includes export and import functionality that lets you export database data to any of five different file formats: XML, XML Structure, CSV, HTML, and Excel, and import database data from CSV files.

DatabaseSpy has special features to help database professionals migrate existing database content for use in XML-based applications. Besides exporting databases to XML files, DatabaseSpy lets you export database tables directly into Altova XMLSpy. You can then use all the advanced features of XMLSpy to accelerate your multi-faceted development project.

Third-party applications such as accounting software packages and other business tools often contain underlying databases but do not provide full-featured database access or functionality. Altova DatabaseSpy can give a progressive user access to the underlying database to better understand the application, or to drill into the data to perform maintenance tasks that would otherwise be cumbersome if not impossible.

As you might expect, DatabaseSpy connects to your relational databases via existing user names and passwords, so functionality for a given user is dependent on the privileges configured for that user’s particular database account. A read-only user can employ DatabaseSpy simply to view, locate, and sort data. A database administrator with a fully-authorized user ID, on the other hand, can use DatabaseSpy to modify existing database tables and their relationships, or design, create, and populate a new relational database from scratch.