Softpedia >Windows >Internet >Servers >Database Utils >SQL Examiner Suite >  Changelog

SQL Examiner Suite Changelog

What's new in SQL Examiner Suite 2023 (9.3.2.156)

Feb 28, 2024
  • Fixes:
  • SQLE
  • SQLES-1674: In some cases, when comparing a PostgreSQL database with PostgreSQL database scripts (script file, script folder), some functions are recognized as different.
  • SQLE
  • SQLES-1667: In some cases, when comparing a PostgreSQL database with PostgreSQL database scripts (script file, script folder), the program recognizes some procedures and functions as different, although they are identical.
  • SQLE
  • SQLES-1637: In some cases, if a PostgreSQL table has to be recreated during synchronization, its sequence is reset to the initial value. (reopen)
  • SQLE
  • SQLES-1669: In some cases, when comparing a PostgreSQL database with PostgreSQL database scripts (script file, script folder), the program recognizes triggers as different, although they are identical.
  • SQLDE
  • SQLES-1652: On the last step of the Export to Script wizard, the Output tab contains unreadable characters and the wrong path to the folder where the script is saved.
  • SQLDE
  • SQLES-1654: The transaction isolation level specified in synchronization settings is not taken into account.
  • SQLES
  • SQLES-1676: In some cases, an error with the "Format of the initialization string does not conform to specification starting at index N" message occurs when the password for a MySQL database connection contains special characters.

New in SQL Examiner Suite 2023 (9.3.2.139) (Nov 17, 2023)

  • Fixes
  • SQLE
  • SQLES-1674: In some cases, when comparing a PostgreSQL database with PostgreSQL database scripts (script file, script folder), some functions are recognized as different.
  • SQLE
  • SQLES-1667: In some cases, when comparing a PostgreSQL database with PostgreSQL database scripts (script file, script folder), the program recognizes some procedures and functions as different, although they are identical.
  • SQLE
  • SQLES-1637: In some cases, if a PostgreSQL table has to be recreated during synchronization, its sequence is reset to the initial value. (reopen)
  • SQLE
  • SQLES-1669: In some cases, when comparing a PostgreSQL database with PostgreSQL database scripts (script file, script folder), the program recognizes triggers as different, although they are identical.
  • SQLDE
  • SQLES-1652: On the last step of the Export to Script wizard, the Output tab contains unreadable characters and the wrong path to the folder where the script is saved.
  • SQLDE
  • SQLES-1654: The transaction isolation level specified in synchronization settings is not taken into account.
  • SQLES
  • SQLES-1676: In some cases, an error with the "Format of the initialization string does not conform to specification starting at index N" message occurs when the password for a MySQL database connection contains special characters.

New in SQL Examiner Suite 2023 (9.3.0.138) (Oct 10, 2023)

  • Fixes:
  • SQLE
  • SQLES-1637: In some cases, if a PostgreSQL table has to be recreated during synchronization, its sequence is reset to the initial value.
  • SQLDE
  • SQLES-1601: In some cases, if an error occurs during program work, temp files are not deleted. (reopen)
  • SQLDE
  • SQLES-1624: In some cases, NullReferencesException occurs while working in the Edit Project window.
  • SQLDE
  • SQLES-1625: In some cases, InvalidOperationException occurs after click on Finish in the Edit Project window.

New in SQL Examiner Suite 2023 (9.3.0.135) (Sep 5, 2023)

  • Fixes:
  • SQLES-1590: In some cases, an error occurs during creation of a foreign key when synchronizing PostgreSQL databases.

New in SQL Examiner Suite 2023 (9.2.0.122) (Jun 28, 2023)

  • In this release, we have implemented support for the following features of PostgreSQL 15 and 14:
  • Multirange types
  • COMPRESSION clause for table columns
  • OUT parameters in stored procedures
  • We also added support for previously unsupported features of earlier versions of PostgreSQL:
  • RULE objects
  • STORAGE (SET STORAGE in column definition) mode for columns:
  • Statistics-gathering target (SET STATISTICS in column definition) for columns
  • Per-attribute options for table columns:
  • Extensions:
  • Although SQL Examiner cannot compare and synchronize extensions, the program compares the list of extensions and their versions and warns if source and target databases differ.
  • Support of the UNLOGGED parameter for tables and sequences

New in SQL Examiner Suite 2023 (9.1.0.111) (Apr 19, 2023)

  • In this interim release, we have implemented support for SQL Server 2022 features, support for which we did not implement at the time of release of the 2023 version, including:
  • Ordered clustered columnstore indexes
  • Compression of XML columns and indexes
  • AUTO_DROP option for statistics IS [NOT] DISTINCT FROM language element
  • SELECT ... WINDOW clause
  • Ledger tables
  • GENERATED ALWAYS AS argument of the CREATE TABLE statement with TRANSACTION_ID and SEQUENCE_NUMBER parameters
  • Azure Active Directory authentication for SQL Server

New in SQL Examiner Suite 2023 (9.0.0.106) (Apr 6, 2023)

  • SQLES-1322: Synchronization output appearance: the text is too close to the Output tab borders.
  • SQLDE
  • SQLES-1323: Information about enabling triggers is displayed in the synchronization output even if they have not been disabled before.
  • SQLDE
  • SQLES-1324: In some cases, the program synchronizes only a few tables marked for synchronization, the rest is skipped and not synchronized.
  • SQLDE
  • SQLES-1331: If a user made a comparison with a new (<New>) target database and then created a database copy during synchronization, only the comparison with the database copy will be available in the Recent Comparison list. The comparison with the new target database cannot be repeated.
  • SQLDE
  • SQLES-1326: If the target database in a comparison from the Recent Comparison list has been replaced with a new (<New>) database, the comparison settings are completely reset and should be restored manually.
  • SQLDE
  • SQLES-1340: When generating a Database Variance Report the Custom ODBC Data Source connection string used as a database name can contain a password.
  • SQLES
  • SQLES-1349: FileNotFoundException occurs when starting SQL Examiner or SQL Data Examiner command-line tools.

New in SQL Examiner Suite 2023 (9.0.0.105) (Mar 15, 2023)

  • Support for new features of supported databases - SQL Examiner Suite 2023 adds support for SQL Server 2022, PostgreSQL 14, 15 and for previously unsupported objects of earlier versions of databases.
  • Cross-platform schema comparison enhancements - comparison and synchronization of views in cross-platform comparisons is now supported.
  • Reworked error handling makes data synchronization more user-manageable.
  • Reworked data synchronization UI leads more convenient synchronization.
  • Specify a TRANSACTION ISOLATION LEVEL when synchronizing data and speed up synchronization.
  • Speed up Variance Report generation after comparing data.
  • Git over SSH
  • UI improvements here and there that make working with the program more convenient and easier.

New in SQL Examiner Suite 2022 (8.0.0.156) (Feb 28, 2023)

  • Fixes:
  • SQLE
  • SQLES-1286: In some cases, when parsing PostgreSQL creation scripts, an error with the "Incorrect syntax near 'main'" message occurs.
  • SQLDE
  • SQLES-1287: In some cases, when loading the schema, ArgumentException with the "[Spep 10, db ] cannot change status from 1 to 1" error message occurs in the New Data Comparison wizard.

New in SQL Examiner Suite 2022 (8.0.0.133) (Jul 30, 2022)

  • Fixes:
  • SQLDE
  • SQLES-1079: Under certain conditions, NotSupportedException occurs with "Unsupported Oracle data type 101 encountered" message when the program loads data from an Oracle table which contains BINARY_DOUBLE or BINARY_FLOAT columns.

New in SQL Examiner Suite 2022 (8.0.0.128) (Jul 15, 2022)

  • Fixes:
  • SQLE:
  • SQLES-1025: In some cases, when the Use CREATE OR REPLACE option is enabled, the program generates an incorrect synchronization script for FUNCTION objects in PostgreSQL databases.
  • SQLDE:
  • SQLES-1027: In rare cases, when a string columns are used as comparison key, the Perform case-sensitive comparison of strings option can be mistakenly applied which leads to incorrect comparison results.

New in SQL Examiner Suite 2018 (7.1.8.321) (Jul 9, 2021)

  • New features:
  • Support for SQL Server 2017 (including Linux)
  • New look and feel
  • SQLDE: Added CSV export
  • Improvements:
  • SQLDE: Improved work with flat files (CSV, TSV)
  • SQLDE: Ability to work with several files (by mask), and not with just one
  • Various usability improvements

New in SQL Examiner Suite 2018 (7.1.5.170) (May 24, 2018)

  • New features:
  • Support for SQL Server 2017 (including Linux)
  • New look and feel
  • SQLDE: Added CSV export
  • Improvements:
  • SQLDE: Improved work with flat files (CSV, TSV)
  • SQLDE: Ability to work with several files (by mask), and not with just one
  • Various usability improvements

New in SQL Examiner Suite 2016 7.0.0.12 (Jul 27, 2016)

  • Full SQL Server 2016 support:
  • Both SQL Examiner and SQL Data Examiner now support all new features of SQL Server 2016. SQL Examiner Suite 2016 has added support of the following features:
  • Temporal tables (SE, SDE).
  • Using SQL Server 2016 backup files as comparison source (SE, SDE).
  • Comparing and synchronizing Security Policies (SE).
  • Constraints on memory-optimized tables (SE).
  • Native JSON Support (SDE).
  • Full ORACLE 12c support:
  • Both components of SQL Examiner Suite 2016 have started supporting some of the new features specific to version 12c and earlier.
  • The following features of the new Oracle database are now supported:
  • Generated columns (SE, SDE).
  • Identity columns (SE, SDE).
  • Invisible columns and indexes (SE).
  • Bitmap indexes (SE).
  • Ability to compare REVERSE and PARALLEL indexes’ properties (SE).
  • Partitioned tables and indexes (SE).
  • DB CLUSTER object support (SE).
  • Extraction / comparison / synchronization of CLUSTER TABLE, INDEX ORGANIZED TABLE, EXTERNAL TABLE (SE).
  • Full MySQL 5.7 support:
  • In addition to earlier releases, some new features have been added:
  • Sectioned tables and indexes added (SE).
  • Support for spatial indexes (SE).
  • Support for FULLTEXT indexes (SE).
  • Increased accuracy of TIME, DATETIME, and TIMESTAMP types (SE, SDE).
  • NEW! PostgreSQL 9.5.2:
  • The SQL Examiner Suite 2016 release adds support for PostgreSQL 9.5.2 and all its features.
  • NEW! High DPI:
  • Work with comfort on any modern computer screen with higher screen resolution and DPI. See more and compare your databases more efficiently.

New in SQL Examiner Suite 2015 6.0.0.100 (Jan 11, 2016)

  • Full SQL Server 2014 support:
  • Both SQL Examiner 2015 and SQL Data Examiner 2015 now support all the new features that were introduced with the SQL Server 2014 release.
  • SQL Local DB support:
  • Now, SQL Examiner and SQL Data Examiner work with the SQL Local DB databases that were introduced with SQL Server 2012.
  • Task Scheduling now built into program:
  • No more tedious manual configuring Windows Scheduled Tasks and SQL Examiner or SQL Data Examiner command-line utilities. Now, you can setup a scheduled comparison and synchronization directly from GUI with an easy to use wizard that allows you to configure any aspect of the task.
  • Significantly improved Console Mode Setting wizard:
  • The wizard was significantly reworked and is now even easier to use than before. All the new program features are now supported.
  • New command-line configuration file format:
  • The XML configuration file format that was used for passing parameter to SQL Examiner or SQL Data Examiner command-line tools has been completely redesigned. Then, the new format allows you to configure any program option and program feature.
  • Added Advanced Filtering feature:
  • When you work with a very large database that contains tens of thousands objects (tables, stored procedures etc.), the schema load can require a lot of time. Now, you can configure the program to ignore some objects when the program loads the database schema and thereby significantly speeds up the process.
  • Redistributable command-line tool now available:
  • Now, you can purchase the special versions of the SQL Examiner and SQL Data Examiner command-line tools that can be included and freely distributed with your applications with some license limitations (the primary limitation – you cannot create a competitive product with the redistributable command-line tool).
  • New look and feel:
  • The programs were redesigned and now looks more modern
  • SQL Server Compact support:
  • SQL Data Examiner could compare and synchronize SQL Compact databases for a while. Now, you can also work with such databases with SQL Examiner.
  • Oracle: added Permissions support:
  • Now, you can compare and synchronize permissions when you compare Oracle databases.
  • Partial Synchronization support for Oracle and MySQL:
  • With Partial Synchronization mode, you can copy not an entire object from a source database to a target, but copy the required parts of an object only. For example, when you copy a table, you can decide to copy only 5 columns of 7 and not copy foreign keys at all. Previously, this mode was supported for SQL Server databases only. Now, Oracle and MySQL are also supported.
  • Data types mapping in cross-platform comparisons:
  • Previously, when you performed a cross-platform database schema comparison, data type mappings were not configurable. For example, when you compared an SQL Server database with a MySQL database with a previous version, the UNIQUEIDENTIFIER data type in the SQL Server database was always mapped to the CHAR (36) data type in MySQL database. Now, you can configure how you want to map this data type, for example BINARY (16) instead of default CHAR (36).
  • Various small updates in GUI:
  • Various small improvements that make working with the program easier.
  • Various new comparison/synchronization options:
  • Added new comparison and synchronization options that allow for more flexibility while you setup the program.

New in SQL Examiner Suite 2012 5.0.0.87 (Oct 26, 2012)

  • SQL Server 2012 changes and innovations support:
  • The SQL Examiner Suite 2012 now supports all changes introduced with SQL Server 2012. The list of supported changes includes (but is not limited to) the following:
  • Sequence Objects
  • Full-Text Stoplists
  • Full-Text search property lists
  • Spatial Indexes
  • Columnstore Indexes (a part of the xVelocity in-memory technology)
  • Contained Databases and Contained Users
  • Oracle schema comparison and synchronization has been improved
  • Packages can be compared and synchronized now
  • Oracle comments can be synchronized with MySQL comments and SQL Server extended properties
  • Oracle identifiers can be enclosed by parentheses now
  • MySQL schema comparison and synchronization has been improved
  • Now, SQL Examiner synchronizes MySQL comments with SQL Server extended properties and Oracle comments when you perform a cross-platform schema comparison and synchronization.
  • Line-by-line script comparison in SQL Examiner:
  • Now, SQL Examiner shows a line-by-line comparison as widely used version control system clients.
  • SQL Server Compact data comparison feature has been added:
  • We have added SQL Server Compact to the list of supported databases. Only data comparison and synchronization is available in this release.
  • Sortable data view in SQL Data Examiner 2012:
  • Now, you can synchronize data in the SQL Data Examiner by any column that significantly simplifies data review and analysis. Previously, the data was always sorted by a comparison key and this order could not be changed.
  • TFS integration has been improved:
  • Now, it is possible to specify a username and password when connecting to the Team Foundation Server.
  • Visual Studio 2010 compatibility has been improved:
  • Now, when you script your database schema with SQL Examiner, you can specify Visual Studio 2010 or Visual Studio 2008 style. This choice affects the generated folder structure, SQL script names, etc. Previously, only Visual Studio 2008 was supported. The Script Comparison engine is now also compatible with the script folder structure that is used by Visual Studio 2010.
  • Partial Synchronization in the command line tool has been added:
  • Previously, you could only use Partial Synchronization mode in the SQL Examiner GUI. Now, it’s possible to perform the partial synchronization with the SQL Examiner command-line tool. Partial Synchronization enables you to synchronize only the required differences (for example, one of three different columns of the table) in an object instead of synchronizing the entire object (for example, a table).

New in SQL Examiner Suite 4.0.0.37 (Jun 10, 2010)

  • MySQL Schema Comparison:
  • The support of MS SQL Server databases has been available forever. The new version of SQL Examiner adds MySQL to the list of supported databases, allowing comparing and synchronizing database structures of MySQL databases.
  • Oracle Schema Comparison:
  • SQL Examiner 2010 supports Oracle databases, allowing comparing and synchronizing database structures of Oracle databases.
  • Cross-Platform Schema Comparison:
  • For the first time, you can compare and synchronize MS SQL, MySQL, and Oracle database schemas to each other. Use SQL Examiner 2010 to perform cross-platform schema comparison and synchronization between all supported DBMS servers. For example, you can compare a MS SQL Server database with an Oracle database, Oracle with MySQL, and so on. The capability is somewhat limited by the range of object types that are implemented in a similar way by the different DBMS platforms.
  • CSV and MS Excel Data Comparison:
  • SQL Data Examiner 2010 can use CSV and MS Excel files as a data source. This significantly simplifies regular import of data from CSV and MS Excel files into the database.
  • OLE DB Data Comparison:
  • In addition to CSV and XLS formats, SQL Data Examiner 2010 can now use any data source based on the OLE DB provider. This allows you importing data not only from CSV or XLS files, but from any type of files for which an OLE DB provider exists.
  • Schema (owner) Mapping in SQL Data Examiner:
  • SQL Examiner could map database schemas of different owners for ages. Today, SQL Data Examiner 2010 gains this feature as well. The new release of SQL Data Examiner can also perform schema mapping.
  • Direction of Synchronization:
  • SQL Examiner 2010 assigns the schema on the left as the source, and the one on the right as the destination, making the process easier to understand.
  • Query Comparison in SQL Data Examiner:
  • SQL Data Examiner 2010 has greatly improved query comparison, eliminating most of the limitations existed in previous versions.
  • Background Processing in SQL Data Examiner:
  • Comparing multiple big tables has always been time-consuming. SQL Data Examiner 2010 makes it possible to begin working with the results immediately as they become available. When the comparison of the first pair of tables is complete, you can start working with the results while other tables are being processed in background.
  • Project Options in SQL Data Examiner:
  • SQL Data Examiner 2010 configures and stores project options separately from global settings. In effect, you can now define and store different settings for individual projects.
  • Automated Login Operation with Stored Passwords:
  • SQL Examiner 2010 and SQL Data Examiner 2010 can now remember authorization data for database connections. If you have ever connected to a database with SQL Examiner and SQL Data Examiner, a list of logins pops up when you establish a new connection. Conveniently, you won't have to enter the login and password every time you connect to a database.
  • Other Enhancements:
  • The list goes on and on. SQL Examiner Suite 2010 has a large number of other enhancements and improvements of which are too many to list. Together, the improvements make SQL Examiner Suite faster, greater and more usable.

New in SQL Examiner Suite 3.0.0.34 (May 19, 2009)

  • The new version added an opportunity to compare and synchronize SQL Server database schema with SQL scripts. Now you can compare data in MySQL databases. While comparing data you can not only compare the results of SQL queries, but also update them.

New in SQL Examiner Suite 2.2 (Jul 9, 2008)

  • The new version added an opportunity to compare and synchronize SQL Server database schema with SQL scripts. Now you can compare data in MySQL databases. While comparing data you can not only compare the results of SQL queries, but also update them.

New in SQL Examiner Suite 2.1.0.75 (Dec 15, 2007)

  • Feature: It is possible to hide unnecessary buttons of the main toolbar now.
  • Feature: When creating a backup of a SQL Server 2008 database, it is possible to use compression now.
  • Feature: It is possible to launch the Console Mode Settings Wizard when one of the sources is an empty source.
  • Feature: Added the %file1, %file2 parameters for external applications.
  • Change: It is possible to evoke the pop-up context menu from the keyboard now.
  • Change: Added support to the ROWGUIDCOL property.
  • Bug fix: When retrieving data from a SQL Server 2000 backup, the order of sorting of the fields, included in an index, was incorrectly displayed.
  • Bug fix: Fixed the issue that prevented the PERSISTED property from being saved in a snapshot.
  • Bug fix: Fixed the issue of the Ignore Triggers option (triggers were not completely ignored when generating a script).
  • Bug fix: Fixed the issue that occurred in the process of generating a script for an extended property with a NULL value.

New in SQL Examiner Suite 2.0.0.70 (Nov 14, 2007)

  • The new SQL Examiner Suite 2008 features significant changes in the engine
  • supports main innovations of SQL Server 2008
  • supports Oracle and MS Access and cross-platform data comparison
  • The program now allows you to use not only tables, but also views and SQL–query as the data comparison source
  • The Ignore index details option doesn�t include the Ignore Unique sub-option anymore
  • Some minor GUI changes

New in SQL Examiner Suite 1.1 (Nov 17, 2006)

  • The key feature introduced to SQL Data Examiner is the support of the SQL Data Examiner Command Line tool that provides access to the features of the program via command line interface. And the updated version of SQL Examiner makes it possible to compare the source code of CLR-objects.