dalibo/sqlserver2pgsql

Cannot understand FILESTREAM

Opened this issue · 0 comments

Is there support for filestream fields? As far as I know, you can just treat them like binary(max) and query them like other fields, but the converter seems to be choking on mine. Is this expected behaviour?
The error looks like this:

Cannot understand       [ScanData] [varbinary](max) FILESTREAM  NULL,

 at ./sqlserver2pgsql.pl line 1663, <$file> line 2132.
        main::parse_dump() called at ./sqlserver2pgsql.pl line 3317

The schema.sql file has this table definition and the filestream field is the last one.

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BitMapsFarm](
        [FarmBitMapID] [int] IDENTITY(1,1) NOT NULL,
        [BitMapTypeID] [int] NULL,
        [bmpName] [nvarchar](50) NULL,
        [DateFrom] [datetime] NULL,
        [DateTo] [datetime] NULL,
        [WayPointID_1] [int] NULL,
        [WayPointID_2] [int] NULL,
        [mx1] [int] NULL,
        [my1] [int] NULL,
        [mx2] [int] NULL,
        [my2] [int] NULL,
        [Aspect] [float] NULL,
        [Minx] [float] NULL,
        [Miny] [float] NULL,
        [Maxx] [float] NULL,
        [Maxy] [float] NULL,
        [Zone] [int] NULL,
        [upsize_ts] [timestamp] NULL,
        [ScanGUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
        [ScanData] [varbinary](max) FILESTREAM  NULL,
 CONSTRAINT [aaaaaBitMapsFarm_PK] PRIMARY KEY CLUSTERED
(
        [FarmBitMapID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] FILESTREAM_ON [ImageFileStream],
UNIQUE NONCLUSTERED
(
        [ScanGUID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] FILESTREAM_ON [ImageFileStream]
GO