You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
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.
The text was updated successfully, but these errors were encountered: