sqlserver2pgsql icon indicating copy to clipboard operation
sqlserver2pgsql copied to clipboard

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

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

samRddhimat avatar Feb 10 '23 02:02 samRddhimat

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

Shubham-21-dev avatar May 10 '23 05:05 Shubham-21-dev