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>
Download (untitled) / with headers
text/plain 1.2k
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.



This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.