Subject: | Error with parser 'SQL::Translator::Parser::SQLServer': Unable to parse line |
Date: | Fri, 22 Nov 2013 22:03:42 -0500 |
To: | bug-SQL-Translator [...] rt.cpan.org |
From: | Tong Sun <suntong [...] cpan.org> |
Hi,
I'm trying to creating ER diagrams from MS SQL Server databases, and this
is what I got:
D:\>sqlt-graph -d SQLServer -o=sample_schema.png --color AdventureWorks.sql
Error: translate: Error with parser 'SQL::Translator::Parser::SQLServer':
Unable to parse line 1:
'USE [AdventureWorks]'
'GO'
'/****** Object: Schema [HumanResources] Script Date: 11/22/2013
20:49:42 **
****/'
'CREATE SCHEMA [HumanResources] AUTHORIZATION [dbo]'
'GO'
...
Any idea what went wrong please?
This is under Windows 7. The SQL::Translator & sqlt-graph installed fine.
The AdventureWorks.sql is just plain ascii file in unix format:
$ head AdventureWorks.sql | hexdump -C
00000000 55 53 45 20 5b 41 64 76 65 6e 74 75 72 65 57 6f |USE
[AdventureWo|
00000010 72 6b 73 5d 0a 47 4f 0a 2f 2a 2a 2a 2a 2a 2a 20
|rks].GO./****** |
00000020 4f 62 6a 65 63 74 3a 20 20 53 63 68 65 6d 61 20 |Object:
Schema |
00000030 5b 48 75 6d 61 6e 52 65 73 6f 75 72 63 65 73 5d
|[HumanResources]|
00000040 20 20 20 20 53 63 72 69 70 74 20 44 61 74 65 3a | Script
Date:|
00000050 20 31 31 2f 32 32 2f 32 30 31 33 20 32 30 3a 34 | 11/22/2013
20:4|
00000060 39 3a 34 32 20 2a 2a 2a 2a 2a 2a 2f 0a 43 52 45 |9:42
******/.CRE|
00000070 41 54 45 20 53 43 48 45 4d 41 20 5b 48 75 6d 61 |ATE SCHEMA
[Huma|
. . .
Thanks
Message body not shown because it is not plain text.