Microsoft SQL Server Component Release Notes

This page lists the main features added to the Microsoft SQL Server Component.

Feature Highlights

Version 2.0.8

Minor improvements and fixed issues

This version contains some minor improvements and fixed issues, which can be found in the complete changelog.

Version 2.0.7

Minor improvements and fixed issues

This version contains some minor improvements and fixed issues, which can be found in the complete changelog.

Version 2.0.6

New Template parameter "Create Indexes On Target Table"

A new parameter named "CreateIndexesOnTargetTable" has been added in the Integration MSSQL Template.

This parameter allows to configure when indexes should be created.

Different values are available to indicate if the Template should decide automatically, if the Template should always create them or never.

New Template parameter "Create Stage Indexes"

A new parameter named "CreateStageIndexes" has been added in the Staging Mssql As Table template.

This parameter allows users to create indexes on the stage table

Version 2.0.5

Minor improvements and fixed issues

This version contains some minor improvements and fixed issues, which can be found in the complete changelog.

Version 2.0.4

Minor improvements and fixed issues

This version contains some minor improvements and fixed issues, which can be found in the complete changelog.

Version 2.0.3

Minor improvements and fixed issues

This version contains some minor improvements and fixed issues, which can be found in the complete changelog.

Version 2.0.2

LOAD File to Mssql Template

Addition of a new option "Success If No File", on LOAD File to Mssql Template.

If this option is true, the Mapping will succeed when source file(s) do not exist, instead of throwing an error.

The table based on the expected structure will be created empty.

Change Data Capture (CDC)

Multiple improvements have been performed to homogenize the usage of Change Data Capture (CDC) in the various Components.

Parameters have been homogenized, so that all Templates should now have the same CDC Parameters, with the same support of features.

Multiple fixes have also been performed to correct CDC issues. Refer to the changelog for the exact list of changes.

Support reversing indexes from Microsoft SQL Server

Indexes are now reversed when performing a reverse on Microsoft SQL Server Metadata.

Version 2.0.1

JDBC Drivers classes and URLs

Semarchy xDI Designer 20.2.0 introduces an improvement which allows Components and Modules definition to provide themselves the proper JDBC drivers classes and URLs, for the connection wizard to automatically adapt depending on the Module selected.

This Component has therefore been updated to take into account this improvement and provide the necessary JDBC drivers classes and URLs information.

Change Log

Version 2023.1.0 (Microsoft SQL Server Component)

New Features

  • DI-4589: The Create Load Indexes option has been added to the LOAD File to Mssql template.

  • DI-4590: The Create Load Indexes option has been added to the LOAD Rdbms to Mssql template.

  • DI-4671: The Create indexes on Target Table parameter has been added to the INTEGRATION File to Mssql template.

  • DI-5184: The collation property has been added to columns. It can be reverse-engineered used in the

INTEGRATION MSSQL template to create work tables with proper collation.

  • DI-5372: The geometry datatype is now supported.

  • DI-5463: Error file management has been implemented for both the BULK and BCP actions in all the templates.

  • DI-5970: MSSQL - Third-party library upgrade.

  • DI-6243: The DEFAULT constraint management is disabled on timestamp and identity datatypes.

Bug Fixes

  • DI-4616: In the STAGING Mssql As Table template, a tooltip is missing on the Create Stage Indexes parameter.

  • DI-5630: The third-party libraries are missing in the Microsoft SQL Server third-party packs.

  • DI-5830: The templates that use the bcp command do not work when there is a backslash character (\) in the file path.

Version 2.0.1 (Microsoft SQL Server Component)

New Features

  • DI-2117: Microsoft SQL Server Component - update module definition to propose more accurate driver and urls

Version 2.0.2 (Microsoft SQL Server Component)

New Features

  • DI-1776: LOAD File to Mssql - new option 'SuccessIfNoFile' to create an empty table, if the source file does not exist

  • DI-1794: Support reversing indexes

  • DI-1912: Templates updated - support having CDC sources on Templates which were not supporting it (such as staging templates)

  • DI-1910: Templates updated - New parameter 'Cdc Subscriber' on Templates on which it was not handled yet

  • DI-1909: Templates updated - New Parameters 'Unlock Cdc Table' and 'Lock Cdc Table' to configure the behaviour of CDC tables locking

Bug Fixes

  • DI-1818: Syntax to drop an index was not correct

  • DI-1907: Templates updated - The 'Cdc Subscriber' parameter was ignored in some Templates when querying the source data

Version 2.0.3 (Microsoft SQL Server Component)

New Features

  • DI-2695: Template - LOAD File to MSSQL - improve the execution of BCP command and the logged command to be clearer

Bug Fixes

  • DI-2744: Template - LOAD Rdbms to Mssql - generated temporary file names may unexpectedly contain object delimiters

Version 2.0.4 (Microsoft SQL Server Component)

New Features

  • DI-2868: Template - Load Rdbms to Mssql - new parameter named "Code Page" which allows to define the code page used for BCP and BULK INSERT

  • DI-4160: Template - LOAD Rdbms to MSSQL - improve the execution of BCP command and the logged command to be clearer

Version 2.0.5 (Microsoft SQL Server Component)

New Features

  • DI-4530: Template - Integration Mssql - recreate indexes on target table when it is dropped and recreated by the Template

Version 2.0.6 (Microsoft SQL Server Component)

New Features

  • DI-4537: Template - Staging Mssql As Table - new parameter "Create Stage Indexes"

  • DI-4562: Template - Integration MSSQL - new parameter "Create Indexes On Target Table"

Version 2.0.7 (Microsoft SQL Server Component)

Bug Fixes

  • DI-3625: Template - STAGING Mssql As View - the view is unexpectedly created without defining the catalog name, which leads the view to be created in the default catalog of the connection, which can be wrong

Version 2.0.8 (Microsoft SQL Server Component)

Bug Fixes

  • DI-4721: Microsoft SQL Server - SQL syntax generated to drop primary key is incorrect in some Templates

Version 3.0.0 (Component Pack)

New Features

  • DI-2641: Reverse-engineer foreign keys referencing tables in another schema when the other table and schema are available in the metadata

  • DI-4508: Update Components and Designer to take into account dedicated license permissions

  • DI-4727: Rebranding: Templates and sample projects

  • DI-4731: Rebranding: Template messages

  • DI-4962: Improved component dependencies and requirements management

Version 5.3.4 (Component Pack)

Bug fixes

  • DI-5630 : The Microsoft SQL Server third-party packs are missing the third-party libraries.