Skip to content

Cannot understand FILESTREAM #175

@allaboutmikey

Description

@allaboutmikey

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions