Pour une aide personnalisée ou une livraison plus rapide
+32 2 558 30 00
DatabaseSpy Professional Edition is the unique multi-database data management, query, design, and database table comparison tool from the creators of XMLSpy.
- 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
- Export data in XML, CSV, HTML, or Excel formats
- Supported Databases
- Microsoft® SQL Server® 2000, 2005, 2008, 2012
- PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1
- Oracle® 9i, 10g, 11g
- MySQL® 5, 5.5
- IBM DB2® 8, 9, 9.5, 9.7, 10.1
- IBM DB2 for iSeries® v6.1, 7.1
- Informix® 11.70
- Sybase® 12, Sybase ASE 15, 15.7
- Microsoft AccessT 2003, 2007, 2010, 2013