ProductsDatabaseSpyFeature Matrix

The table below lists all the features included DatabaseSpy® 2008.

Download a free trial of DatabaseSpy® 2008.

		Altova
Feature		DatabaseSpy® 2008
Database Quick Connect Dialog
	Create a connection (ADO or ODBC)	•
	Load a project from a directory or from the recent project list	•
	Option to connect or add to the connection to the project	•
	Access Quick Connect dialog with short-cut key (Ctrl+Q)	•
Project Window
	Application always works with a project	•
	Project toolbar, to create new, open, or save a project	•
	Store Data Sources, SQL Files, Design Files, and/or Favorites	•
	Connect to data sources directly from the data source folder	•
	Execute SQL directly from a file in SQL Folders	•
	Open Files directly from the project	•
	Customizable User-defined tools menu	•
Online Database Browser
	Browse multiple data sources at the same time	•
	View data in five different layouts	•
	User-selectable filter view of data source	•
	Object Locator to find data objects	•
	Display only Favorite objects	•
	Export database data to XML, HTML, CSV, and Excel files	•
	Import CSV files into a database	•
	Dynamically retrieve data directly in the Online Browser	•
	Identify columns containing XML data in the expanded tree view	•
	Display XML Schemas registered in the database in tree view (IBM DB2 9 only)	•
	Identify views and stored procedures contained in the database	•
SQL Editor
	Tab-based result window with custom target names and layouts	•
	Data Inspector helper window for fields with long entries	•
	Color coded display of XML in databases	•
	Edit database content	•
	Organize SQL scripts into regions	•
	Individually collapse or expand regions	•
	Autocompletion of SQL statements	•
	Customize the list of SQL autocompletion suggestions	•
	Easily transform Select statements into Create View statements	•
	Generate SQL statements from the Online Database Browser	•
	Navigate through multiple SQL Statements	•
	Execute entire SQL script or selectively execute SQL statements	•
	Selectable SQL formatting configurations for supported databases	•
	Customize or create new SQL formatting configurations	•
	Choose SQL formatting configuration from drop-down menu	•
	SQL refactoring menu to easily reformat existing SQL statements and scripts	•
Design Editor
	Drag and drop tables from Online Database Browser	•
	Hierarchical table layout	•
	Identify columns containing XML data with a unique icon (IBM DB2 9)	•
	Compact view available	•
	Collapsible compartments	•
	Unique layout showing Indexes and Constraints in table objects	•
	Inline column, index, and constraint editing	•
	Graphically design or modify table relationships	•
	Color-coded table connector lines to identify relationships	•
	Properties window column, index, and constraint editing	•
	Keyboard navigation	•
	Generate database change SQL script instantly or on demand	•
	Script displayed in the SQL preview window	•
	Execute design change script immediately, or save as SQL file	•
Access to Global Resources
	Configure multiple target deployment environments	•
	Switch between configurations with one click	•
	Define a system of resource aliases	•
	Configure files, folders, databases as Global Resources	•
	Share files, folders, and database connections efficiently between products	•
Platforms
	Microsoft Windows application (2000, XP, Server 2003, Vista)	•