DatabaseSpy Professional Edition is the unique multi-database data management, query, design, and database table comparison tool from the creators of XMLSpy.
Specs
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
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
Database Comparison and Merging
Compare contents of tables of the same or different database types
Automatically map tables and columns with the same names
Permit manual mapping of tables and columns
Show comparison results with options to show/hide equal or different
rows
Merge differences in database content directly or via change script
Compare database schemas of the same or different database types
with multiple mapping options
Create merge scripts to components to update structures and
components between schemas
Save database data and schema comparison settings in files for reuse
Data Import and Export
Import data from XML or CSV formats
Import data directly or generate a SQL import script