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