Altova DatabaseSpy Professional Features

SQL Editor       

• Generate a variety SQL statements in the Online Browser based on existing tables and columns, including SELECT, CREATE, INSERT, DROP, and more.
• Generate complete DDL scripts for a database schema.
• Open and save SQL statements in files for reuse.
• Color-coded auto-formatting with collapsible regions and named result windows.
• Customized appearance of SQL code for each supported database.
• Refactoring menu to add or remove semicolons and quotation marks, or automatically remove comments from SQL statements.
• Dynamic autocompletion window for SQL editing with options to display and insert names of tables, views, columns, functions, datatypes, procedures, and keywords.
• Edit views and stored procedures.
• Display query results in multiple named or stacked results tables.

Graphical Database Design

• Display tables and relationships in graphical view.
• Add or modify database tables.
• Add or modify columns with datatypes, lengths, nullable characteristics.
• Add or modify indexes, keys, and check constraints.
• Build database change script to execute immediately, send SQL editor, or save in a file.
• Save graphical database diagrams as .png or .emf image files.

Data Import and Export

• Import data from XML or CSV formats.
• Import data directly or generate a SQL import script.
• Export data in XML, CSV, HTML, or Excel formats.

Supported Databases

• Firebird
• IBM DB2 for iSeries®
• IBM DB2®
• Informix®
• MariaDB
• Microsoft Access
• Microsoft® Azure SQL
• Microsoft® SQL Server®
• MySQL®
• PostgreSQL
• Oracle®
• Progress OpenEdge
• SQLite
• Sybase® ASE
• Teradata