sqlserver2pgsql icon indicating copy to clipboard operation
sqlserver2pgsql copied to clipboard

Cannot understand FILESTREAM

Open allaboutmikey opened this issue 2 years ago • 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

allaboutmikey avatar Mar 02 '23 05:03 allaboutmikey