Multi-database data management, query, and design tool

Altova DatabaseSpy

You can order this product Altova DatabaseSpy directly at the vendor now (list of items)

Altova DatabaseSpy 2008 is the unique multi-database query and design tool. It connects to all major databases, easing SQL editing and database structure design, for a fraction of the cost of single-database solutions. DatabaseSpy 2008 boasts an elegant user interface that simplifies querying, visualizing, managing, designing, and constructing relational databases. Features like table browsing, data editing, SQL auto-completion, visual table design, multiple export formats, and more, all save time and ensure accuracy. DatabaseSpy 2008 is the one tool to finally liberate data management.

---

New Features in DatabaseSpy 2008

• Creating and editing database views
  Allows users to create virtual tables from the result sets of database queries, thus organizing data in a convenient and customized manner.
• Support for Stored Procedures
  Allows users to examine, create, edit, and execute stored procedures in the SQL Editor.
• Database content editing
  Enables users to retrieve and edit the content of existing database tables, add new rows to insert data, or delete entire rows in all supported databases.
• New Data Inspector window
  Allows users to preview large XML and text fields in databases.
• Enhanced SQL auto-completion capability
  Provides customizable, context-sensitive entry-helpers for auto-completion of SQL statements.
• Editing indexes and constraints in the Design Editor

Altova DatabaseSpy 2007

Altova DatabaseSpy 2007 is a new application for database administrators (DBAs), database developers, and other database-oriented IT professionals featuring an intuitive, elegant user interface that simplifies querying, visualizing, managing, designing, and constructing relational databases. Morover, DatabaseSpy 2007 is uniquely beneficial when you need to interact with multiple databases created at different times by different developers.

---

Features

One tool unlocks them all
Altova DatabaseSpy 2007 is designed to be the database professional's multi-purpose tool, since it connects to all of the following database types:

• Microsoft SQL Server 2000 and 2005
• Microsoft Access 2003
• Oracle 9i and 10g
• IBM DB2 8.x and 9
• MySQL 4.x and 5.x
• Sybase 11

In fact, DatabaseSpy 2007 is designed to work with any database that uses an ADO or ODBC connection. Once you have connected to a database, Altova DatabaseSpy 2007 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 2007 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 2007 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 2007 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 2007 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. Many databases in use today were not developed with XML compatibility in mind. DatabaseSpy 2007 has special features to help database professionals migrate existing database content for use in XML-based applications. Besides exporting databases to XML files, DatabaseSpy 2007 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 2007 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 2007 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 2007 simply to view, locate, and sort data. A database administrator with a fully-authorized user ID, on the other hand, can use DatabaseSpy 2007 to modify existing database tables and their relationships, or design, create, and populate a new relational database from scratch.

back