SQL 2022 to SIARD2 - The conversion from varbinary to BLOB is unsupported

[pi-r-ayotte]

Description: Unable to export table containing varbinary column on SQL Server 2022

Steps required to reproduce the bug:

1. Create a Test database
2. Run the tcl script (see below) to create a test table
3. Try to export (cmdline used: java -jar "-Dfile.encoding=UTF-8" dbptk-app-2.11.0.jar migrate --import microsoft-sql-server --import-server-name=sql2022 --import-database="Test" --import-username=userna --import-password="pwd" --export siard-2 --export-file=G:\export\Test-dbptk.siard)
4. You should find the error in the dbptk-app.log

Attach the dbptk-app.log.txt file below. dbptk-app.log.txt

TCL Script

USE [Test] GO /** Object: Table [dbo].[AlarmEnroll] Script Date: 5/17/2024 2:18:51 PM **/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AlarmEnroll1]( [ObjPropRef] varbinary NULL, ) GO USE [Test] GO INSERT INTO [dbo].[AlarmEnroll1] ([ObjPropRef]) VALUES (0) GO