Geek Answers Handbook

How to parse SQL files using C #?

Can anybody help me?

I have a bunch of .sql files. I want to analyze (check) these files before they are executed on the server.

I have many internet sites that parse code. But I want to parse the code using C #.

So please, can you advise. If there is any tool, dll I need to use.

I just want to parse the file and not execute it

+5
source share
7 answers

The way to do this is to execute it on the server, except for SET PARSEONLY ON (so that it is parsed but not executed): I think MS Query Analyzer does this.

+13

, SQL Server SET PARSEONLY ON . , .

+3

Antler Parser Generator - . SQL, .

+1

(, , :-)), .

, , , , , , , . , , , , , , .

- - .

+1

DMS Software Reengineering Toolkit SQL, SQL.

Formatter Formatter, . , .

"" ; , .

.

EDIT Aug 2011: DMS SQL- SQL 2011.

+1

Visual Studio , Visual Studio . Team Developer.

, "" sql, . , , , , , .

0

More articles:


All Articles