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
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:
The schema.sql file has this table definition and the filestream field is the last one.