📘Release History
V1.16
Created: 2024-07-17
bumped version number
add support for pre SQL Server 2017
V1.15
Created: 2024-07-04
added support for TimeStamp and RowVersion Cursor Field
modified retreive timestamp to be the sync_timestamp from SQL Server instead of Snowflake generated timestamp
updated high watermark to use full refresh path when the sync_strategy has been set to full refesh
added additional error information when the data returned doesn't include the required key fields
updated documentation
updated version numbers of omnata packages
V1.14
Created: 2024-06-12
fixed error when retreiving certificate
V1.13
Created: 2024-06-11
Separated out connection methods
SQL Server Authentication (on-premisis or Azure based)
Microsoft Entra Password (Azure SQL Database, Azure SQL Managed Instance)
Microsoft Entra Service Principal (Azure SQL Database, Azure SQL Managed Instance)
V1.12
Created: 2024-06-11
Used latest plugin devkit, which addresses an issue where errors occur when editing connections
Fixed an issue where the connection test did not actually execute a SQL statement
V1.11
Created: 2024-05-27
when a cdc columns change, a sync retreives the new set of columns and resets the state
cdc stream selection now correctly returns streams where net changes are requested
high watermark stream selection now displays indexed as well as heaped tables
V1.10
Created: 2024-05-26
FIltered Out Tables which don't support net changes if only net changes are required
Ensured when net changes are not supported that the all changes are retreived
Each sync queries sql server directly instead of using metadata on retreived on initial connection
When running a cdc sync, the columns for the capture instance are retreived instead of what was available on initial setup.
V1.9
Created: 2024-05-21
Update SQL DataTypes to correctly specify schema definition for datetime2, datetimeoffset, smalldatetime, money, smallmoney, and real
Modified Cursor Data when the cursor field is of type rowversion to include 0x at the start
CDC Streams can now only be incremental
If row_version field is defined, for non CDC syncs, the rowversion field is selected by default as the cusor field
V1.8
Created: 2024-05-19
Updated SQL DataTypes to correctly specify the schema definition for datetime2, datetimeoffset, smalldatetime, money, smallmoney and real
Expanded the list of column datatypes which can be used for a cursor field check to include datetime2, smalldatetime, datetimeoffset
V1.7
Created: 2024-05-18
increased plugin runtime to 0.3.26
Added billing events for ngrok tunnels
V1.6
Created: 2024-05-17
updated how indexed data is retreived for full data loads where the index is non integer based.
set the default cursor if a modified to create date is found for high watermark incremental merge based syncs
V1.5
Created: 2024-05-13
SQL Server Certificate Retreival Fix
V1.4
Created: 2024-05-13
Initial release of MSSQL plugin, supports inbound syncing using the following techniques:
Change Data Capture (CDC Tables)
Highwater mark (Tables and Views)
V1.3
Created: 2024-04-02
Switched to new plugin-oriented billing mechanism
Bump plugin runtime version
Built with omnata-plugin-devkit==0.3.17 which includes pinned stored proc dependencies
Last updated