Supported sources

The article recounts supported comparison and synchronization sources for schema and data comparisons.

SQL Examiner compares database schemas; SQL Data Examiner compares data. SQL Examiner Suite contains both products.

Starting version 2008, SQL Examiner, SQL Data Examiner, and, consequently, SQL Examiner Suite are available in Professional and Standard editions. The Professional editions include all features of the products; there are some limitations in the Standard editions.

Supported SQL Examiner Suite versions

We guarantee that all versions of the products work with stated on-premise and cloud databases at the product's End of Support date. If a database vendor or cloud provider changes a database which leads to compatibility issues, we update the products to fix these issues if this change was made before End of Support date. We do not update not supported versions of the SQL Examiner and SQL Data Examiner.

Major version End of Support
SQL Examiner Suite 2016 and earlier1 Not supported
SQL Examiner Suite 2018 May 16, 2022
SQL Examiner Suite 2022 December 31, 20232

1 Includes both SQL Examiner 2018 and SQL Data Examiner 2018. The support period is the same for both products. The same applied to SQL Examiner Suite 2018 and 2022.

2 The specified End of Support date is a minimal guaranteed support timeframe and can be extended later.

Schema comparison

SQL Examiner compares and synchronizes databases schemas (structures). The most recent version is SQL Examiner 2022 (builds 8.0.x.x).

SQL Examiner primarily purposed to compare and synchronize databases running on servers of the same types (i.e., SQL Server with SQL Server, Oracle with Oracle, etc.). At the same time, comparison and synchronization of different versions are fully supported (SQL Server 2012 with SQL Server 2019).

Cross-platform schema comparison

The Professional edition of the SQL Examiner supports cross-platform comparison and synchronization (i.e., SQL Server with Oracle, Oracle with PostgreSQL, and so on). You can compare and synchronize tables, columns (data type mapping is supported). However, you cannot compare text objects (views, stored procedures, functions, triggers, etc.).

Source types

SQL Examiner can read schemas from live databases (databases that run on database servers), database snapshots (single-file definition of database schema, created with SQL Examiner), database backups, and database creation script. Supported source types depend on product edition.

Professional edition Standard edition
Live database Yes Yes
Snapshot Yes Yes
Backup file1, 2, 3 Yes
Creation script4, 5 Yes

1 Only SQL Server backups are currently supported.

2 Only full, uncompressed backups are supported. A backup file can contain multiple backups.

3 Backup files are read-only. SQL Examiner cannot update a backup file.

4 SQL Examiner 2009-2018 works with SQL Server creation scripts only. SQL Examiner 2022 works with creation scripts for all supported databases.

5 A single-file script or a folder that contains multiple scripts for a single database can be used as a comparison source.

On-premise databases

The table below states the officially supported databases and versions for each version of SQL Examiner. Although typically old versions of SQL Examiner can work with more recent versions of databases than stated in the table (but features introduced in these versions are not supported), we cannot guarantee that there are no issues in such configurations, and these configurations are not supported.

SQL Server Oracle1 MySQL PostgreSQL1
SQL Examiner 2022 7.0–2022 10g–21c2 5.0—8.0 9.0—13.3
SQL Examiner 2018 7.0–2017 10g–18c 5.0—5.7 9.0—9.5
SQL Examiner 2016 7.0–2016 10g–11g 5.0—5.7 9.0—9.5
SQL Examiner 2015 7.0–2014 10g–11g 5.0—5.6
SQL Examiner 2012 7.0–2012 10g–11g 5.0—5.5
SQL Examiner 2010 7.0–2008 10g–11g 5.0—5.5
SQL Examiner 2009 7.0–2008
SQL Examiner 2008 7.0–2008
SQL Examiner 1.x 7.0–2008

1 Despite stated support of the specific Oracle or PostgreSQL version, older versions of SQL Examiner do not compare and synchronize some objects of particular types in supported versions of Oracle or PostgreSQL. See Supported Oracle objects and Supported PostgreSQL objects below.

2 The first supported Oracle version is 10g. We also tested SQL Examiner with Oracle 9i, and it works, but this configuration is not officially supported.

3 In this article, where SQL Server 2008 is mentioned, both SQL Server 2008 and SQL Server 2008 R2 are implied.

SQL Local DB

Starting from version 2015, SQL Examiner supports SQL Local DB, introduced in the SQL Server 2012.

SQL Server Compact

Starting from version 2015, SQL Examiner supports SQL Server Compact 3.5 and SQL Server Compact 4.0 databases.

Cloud databases

We tested SQL Examiner 2018 and 2022 with the following cloud databases:

  • Azure SQL Database
  • Amazon RDS for SQL Server
  • Amazon RDS for Oracle
  • Amazon RDS for MySQL
  • Amazon RDS for MariaDB
  • Amazon RDS for PostgreSQL

Supported Oracle objects

Oracle support was added in SQL Examiner 2010. Different versions of SQL Examiner do not support some object types. The table below shows database objects supported by each SQL Examiner version. However, as of November 16, 2021, materialized views and synonyms are still not supported. We plan to add such support in the SQL Examiner 2022 (the current version) later in 2022.

2022 2018 2016 2015 2012 2010
Tables Yes Yes Yes Yes Yes Yes
Views Yes Yes Yes Yes Yes Yes
Stored Procedures Yes Yes Yes Yes Yes Yes
User Defined Functions Yes Yes Yes Yes Yes Yes
Triggers Yes Yes Yes Yes Yes Yes
Sequences Yes Yes Yes Yes Yes Yes
Packages Yes Yes Yes Yes Yes
Comments Yes Yes Yes Yes Yes
Users Yes Yes Yes Yes
Roles Yes Yes Yes Yes
Generated columns Yes Yes Yes
Invisible columns and indexes Yes Yes Yes
Identity columns Yes Yes Yes
Clusters Yes Yes Yes
Partitioned tables and indexes Yes Yes Yes
Bitmap Indexes Yes Yes Yes
User Defined Types Yes Yes
Materialized Views
Synonyms

Supported PostgreSQL objects

SQL Examiner has worked with PostgreSQL since version 2016. The table below shows database objects supported by each SQL Examiner version.

2022 2018 2016
Tables Yes Yes Yes
Views Yes Yes Yes
User Defined Functions Yes Yes Yes
Triggers Yes Yes Yes
Sequences Yes Yes Yes
Schemas Yes Yes Yes
Roles Yes Yes Yes
Permissions Yes Yes Yes
Comments Yes Yes Yes
Domains Yes Yes
Event Triggers Yes
Procedures Yes
Materialized Views Yes
Security Policies Yes
Statistics Yes
Collations Yes

Version control systems

Starting from version 2009, the Professional edition of the SQL Examiner can work with database creation scripts stored in various source control systems. Scripts can be either read from or updated in these systems. The following source control systems are supported:

  • Git (starting from SQL Examiner 2015)
  • Microsoft Team Foundation Server (TFS)
  • TortoiseSVN
  • Perforce
  • Microsoft SourceSafe

Data comparison

SQL Data Examiner compares and synchronizes data in various data sources. The most recent version is SQL Data Examiner 2022 (builds 8.0.x.x).

Cross-platform data comparison and synchronization

The Professional edition of the SQL Data Examiner supports cross-platform data comparison and synchronization, i.e., you can compare and synchronize data between any combination of the supported sources.

On-premise databases

SQL Server Access Oracle MySQL PostgreSQL
SQL Examiner 2022 Yes Yes Yes Yes Yes
SQL Examiner 2018 Yes Yes Yes Yes Yes
SQL Examiner 2016 Yes Yes Yes Yes Yes
SQL Examiner 2015 Yes Yes Yes Yes
SQL Examiner 2012 Yes Yes Yes Yes
SQL Examiner 2010 Yes Yes Yes Yes
SQL Examiner 2009 Yes Yes Yes Yes
SQL Examiner 2008 Yes Yes Yes Yes
SQL Examiner 1.x Yes Yes Yes

SQL Local DB

Starting from version 2015, SQL Data Examiner supports SQL Local DB, introduced in the SQL Server 2012.

SQL Server Compact

Starting from version 2012, SQL Data Examiner supports SQL Server Compact 3.5 and SQL Server Compact 4.0 databases.

Other data sources

In addition to mentioned above, the SQL Data Examiner works with the following data sources.

Excel Flat files OLE DB ODBC
SQL Examiner 2022 Yes Yes Yes Yes
SQL Examiner 2018 Yes Yes Yes Yes
SQL Examiner 2016 Yes Yes Yes Yes
SQL Examiner 2015 Yes Yes Yes Yes
SQL Examiner 2012 Yes Yes Yes
SQL Examiner 2010 Yes Yes Yes
SQL Examiner 2009 Yes Yes
SQL Examiner 2008 Yes Yes
SQL Examiner 1.x Yes Yes
  • Product:  SQL Examiner, SQL Data Examiner
  • Edition:  All
  • Version:  All
  • Published:  2021-11-18
  • Last Upadted:  2021-11-26


Do not see what you are looking for?
Please submit a support request


Table of contents