Released: May 2, 2013

Updates in this release

Updates in V6.0

Database Refactoring

• Rename objects in a database and automatically update links to these objects.

Query Builder

• Visually build INSERT, UPDATE and DELETE statements.
• Convert SELECT queries into INSERT statements.
• Execute separate sub-queries to check correctness without leaving the diagram interface.
• Query type is now indicated on the diagram surface.

SQL Statements Export

• Export data to INSERT, UPDATE and MERGE statements.
• Export query results as well as data directly from tables.
• Generate INSERT statements from the data grid.

Improved Database Object Editors

• Full-text search in columns.
• Schema changes can now be viewed before updating the database.
• View the designer and SQL table simultaneously.

Data Comparison Tool

• New data comparison reports now contain table data (not just a summary).
• Comparison of custom query results (along with tables and views).
• Full-text search in comparison results.