dalibo/sqlserver2pgsql

> (1) not understood. This is a bug at sqlserver2pgsql.pl line 2551, <$file> line 1

Opened this issue · 1 comments

Hi,

Not sure this is the right place to report issues faced while using sqlserver2pgsql.pl in command prompt.
Passed a input file with create statement and got the below error flashing at the prompt.

**Line <CREATE TABLE dbo.DC_MA_MAIL (

(1) not understood. This is a bug at sqlserver2pgsql.pl line 2551, <$file> line 1.**

Below is the script i'm using

CREATE TABLE dbo.DC_MA_MAIL (
CASE_REF_NO VARCHAR (50) NOT NULL
);

I'm using Windows 11 and installed strawberry-perl-5.32.1.1-64bit to run it in the prompt.

Thanks

Hi,
Similar issue, Passed an input file
CREATE TYPE [dbo].[Survey_GPSCoordinates] AS TABLE(
[ID] [int] NULL,
[Latitude] [numeric](18, 12) NULL,
[Longitude] [numeric](18, 12) NULL
)
got the below error when using sqlserver2pgsql.pl in command prompt
Cannot understand [Latitude] [numeric](18, 12) NULL,

at ./sqlserver2pgsql.pl line 1948, <$file> line 109.
main::parse_dump() called at ./sqlserver2pgsql.pl line 3316

Thanks