Page History

...

1. The SQL Server Database Selection popup now includes the entity filters. It allows the user to set the filters before comparing databases. Filters are fully saved and retained in the workspace session. Image Removed

2. The IDERA SQL Schema Compare command line <Database> element supports the following new properties:

   1. ConnectionString. The entire database connection script.

   2. PacketSize. The SQL connection packet-size.

   3. Pooled. Indicates whether the SQL connection should be pooled.

   4. OtherProperties. Other connection properties.

3. The command line displays operational message on the screen and logs them at the same time; used to be either or in the previous version.

4. The command line /quiet option does not display messages on the screen. Messages are logged regardless of this option.

5. The command line script and log file are not created if databases are equal; used to be empty in the previous version.

6. The command line uses by default UTF-8 encoding for all files.

...

IDERA SQL Schema Compare 7.0 contains the new Command Line wizard, which allows the user to create a command line xml file step-by-step, via a simple and intuitive interface.

Image Removed

In addition to the Command Line wizard, IDERA SQL Schema Compare includes a new option in the schema compare UI. It allows the user to export a comparison session and create a command line directly from the UI.

Image Removed

Data Compare updates

New features and enhancements

...

IDERA SQL Data Compare 7.0 brings the new command line wizard. The wizard is similar to schema and creates an xml file specified for the data compare command line. In addition the wizard, the user can create the config file directly from the data compare UI.Image Removed

7.0 Fixed Issues

...

• It fixes an issue with the SPARSE column. The NULL|NOT NULL constraints should be specified after the SPARSE attribute.
• It fixes an issue that occurred when the synchronization script contains extended characters, such as Chinese letters. Schema now uses UTF-8 encoding for the script and the log files.
• It fixes an issue with the DATA_COMPRESSION attribute on a filestream table. If the filestream table contains an embedded primary key, data compression must be specified either under the primary key or the table, but not both.

5.0 New features

Microsoft Azure SQL Database v11 and v12 Preview support

...

• .

...

SQL Data Compare also supports the Azure data restriction that a table or view must have a clustered index. The SQL Data Compare user interface includes a warning and a new popup window that displays a list of any tables or views excluded because of this restriction.

While IDERA SQL Comparison Toolset now supports Microsoft Azure SQL Database v12, only the Preview release was available during development of the IDERA SQL Comparison Toolset. Note that Microsoft may make changes before the final product release.

Multiple session support

IDERA SQL Comparison Toolset now allows you to have multiple sessions for the same SQL database. You can control this feature on the Workspace tab of the Application Settings window, as show in the following image.

Image Removed

SQL Schema Compare Workspace tab user interface improvement

The SQL Schema Compare Workspace tab offers user interface improvements including:

• The Workspace tab now displays the session name for you to easily locate a session, even when there are multiple sessions for the same databases, as shown in the following image.
  Image Removed
• The Databases tab of the Workspace now includes a cloud icon next to Microsoft Azure SQL Databases for you to distinguish between cloud and on-premise databases, as shown in the following image.
  Image Removed

• A new landing page appears in SQL Schema Compare only when the Workspace is empty. The page makes it easier for a first-time user to navigate the toolset.

SQL Schema Compare refresh option

SQL Schema Compare introduces a new comparison option named Refresh referencing views when rebuilding a table. The option is located on the Scripting Options tab of the Comparison Options window, and it is disabled by default. When enabled, the table-rebuild portion of the schema synchronization script contains additional script that refreshes the views that reference the table that is being rebuilt. You can also use this option in the command line.

Image Removed

SQL Data Compare user interface improvements for Microsoft Azure SQL Database v11

SQL Data Compare includes a new exclusion window that displays a list of database objects, such as table or views, excluded from data comparison due to the Microsoft Azure SQL Database v11 restriction related to missing clustered indexes. You can access this window from a link that appears during the pairing step of the data comparison. note that the link is visible only if the restriction has affected tables or views in the database.

...

...