Altova DatabaseSpy Enterprise 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.
- Support for SQL queries that contain parameters (SQL Templates).
- Edit views and stored procedures.
- Display query results in multiple named or stacked results tables.
Charts of SQL Query Results
- Line charts
- 2D and 3D bar charts
- Stacked bar charts
- 2D and 3D pie charts
- Area charts
- Stacked area charts
- Round gauge charts
- Bar gauge charts
- Candlestick charts
- Chart overlays
- Chart background images and color gradients
- Customize chart titles, axis ranges, colors, fonts, and sizes
- Save charts as .png, .bmp, .gif, and .jpg image files
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