Skip Menu |

This queue is for tickets about the SQL-Translator CPAN distribution.

Report information
The Basics
Id: 90700
Status: new
Priority: 0/
Queue: SQL-Translator

People
Owner: Nobody in particular
Requestors: suntong [...] cpan.org
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



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
Download AdventureWorks.sql
application/octet-stream 480k

Message body not shown because it is not plain text.