SQL Examiner Suite 2008 R2 Release Notes
v2.2, Released June 26, 2008
SQL Examiner Suite 2008 R2 is the next generation of the industry standard database comparison and synchronization tool.
The updated SQL Examiner Suite 2008 R2 includes new versions of SQL Examiner 2008 and SQL Data Examiner 2008.
These Release Notes cover what's new for SQL Examiner Suite 2008 R2, download and installation instructions.
What’s new in SQL Examiner Suite 2008 R2
SQL Examiner 2008 R2
Comparison and synchronization with SQL scripts. Now it is possible compare and synchronize databases with the SQL script files created in, for example, SQL Management Studio or SQL Examiner. However, the following restrictions exist here:
- If no object schema is explicitly specified, dbo will be used by default.
- Dynamic SQL-queries are not supported.
SQL Data Examiner 2008 R2
Opportunity to update the results of SQL-queries. Now when comparing SQL-queries, it is possible to update data in the tables included in a query as well. There are some restrictions for the queries, which results you update:
- A query must consist of a single SELECT command. So it is not possible to update the results of executing stored procedures. Likewise, if a dataset was built from a temporary table, and then was returned by the SELECT command, this result cannot be updated.
- Only the tables specified after FROM, INNER/LEFT/RIGHT/CROSS JOIN and the fields which are specified in the list of returned columns may be updated.
- Table columns may be updated only if they are included in a query without conversions or calculations. For example, you cannot update MyTable.FirstName + ‘ ‘ + MyTable.LastName.
- You cannot update the results of a query that consists of several queries united by the UNION command.
- You cannot update tables that are used in sub-queries.
- You cannot update the results of a query that constains DISTINCT keyword.
- You cannot update the results of a query that constains GROUP BY clause.
- Dynamic SQL-queries are not supported.
Support of MySQL.
The new version of SQL Data Examiner supports not only SQL Server, Oracle and Access,
but also MySQL. As in previous versions, you can compare and synchronize data among different servers, for example SQL Server
with Oracle, or Access with MySQL etc.
Database Variance Report. Now there is a function that allows the user to save variance reports in a HTML-format.
Download and Installation
Download Instructions
You can download the full-featured 30-days demo version of SQL Examiner Suite 2008 R2 at:
http://www.sqlaccessories.com/download/sqlexaminer.msi
Registered users of any edition of SQL Examiner Suite 2008 are eligible to free upgrade, and can use the same link and password as for the previous version.
Installation Instructions
Please launch the .msi file and follow the instructions of the wizard to complete the installation.
If you previously installed the beta-version of SQL Examiner Suite 2008 R2, please remove the beta-version first.