About Altova DataBaseSpy Enterprise Edition

Multi-database tool and SQL editor.

DatabaseSpy connects to all major databases, easing SQL editing, database structure design, content editing, and database conversion for a fraction of the cost of single-database solutions.

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