Microsoft SQL Server component release notes
This page lists the main features added to the Microsoft SQL Server Component.
Changelog
Version 2024.2.0
Version 2023.1.0
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.2 (Microsoft SQL Server component)
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
Version 2.0.3 (Microsoft SQL Server component)
Version 3.0.0 (component pack)
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