General SQL Parser .NET v.2.1.9

Advertisement
Advertisement

Due to the complexity of the SQL grammar, many people have attempted but failed to generate a successful parser. Here, at Gudu Software, we have developed a parser that can successfully reduce the difficulties associated with decoding SQL grammar. Vendors are constantly releasing new versions of databases, so maintaining an original home-grown SQL parser is time consuming, error-prone, and costly. We are dedicated to helping your product adapt to the latest versions of database programs. With the appropriate library, like the one we provide, you can save hundred of hours, if not more, on developing time. As a result, the efficiency of your business will increase dramatically.

FEATURES:

Clean up messy SQL codes:
· Easily integrate SQL formatter into your application for a color coded layout that is easy to navigate, giving your product a professional feeling.

Detect SQL syntax errors:
· Your application will be able to validate SQL syntax before a database executes the query. This is very useful especially if your SQL was dynamically built based on user input.

Rid SQL injections:
· Avoid being vulnerable to SQL injection in your ASP.NET or Java application, by automatically detecting malicious SQL segment with our ready-to-use library.

Retrieve/Refactor table & column name:
· Precisely determining and renaming every table and column in stored SQL statements is very complex with a lot of nesting and sub-queries, but we can make it hassle-free for you.

Find affected SQL objects:
· Parse out the affect SQL objects in a SQL file that can have many different types of SQL (select, insert, create, drop, etc), and helping to determine what is being affected, including but not limited to schema, table, column.

Discover the relationship in DDL:
· Quickly locate the primary key and/or foreign key in DDL scripts to figure out the complex relationship among the various tables. Extracted table, attribute names, data types can be used to generate the CRUD-Statements.

Query parse tree in XML:
· Parsing SQL is a notoriously difficult task, but we are here to help. You will be provided with a SQL query parse tree in XML output that will allow you to further process SQL scripts.

Rewrite and convert SQL:
· Modify SQL expression/condition in where clause to reconstruct a new filter. Rewrite Oracle proprietary joins to ANSI SQL compliant joins. Translate SQL between different databases.

CRUD Reportor:
· Read complex and large SQL scripts to find out tables have Create, Read, Update, Delete and Insert operations against them immediately, it's almost impossible to do that without help with a tool.

SQL Parser can even do more:
· We are dedicated to constantly improving our product so it will be easier to use with more flexibility, making it a valuable asset to your software product. Here, we have provided you with additional demos that may be helpful to you.

Due to the complexity of the SQL grammar, many ...

check syntax of sql statements, pretty print out sql statements

 
  • General SQL Parser .NET
  • 2.1.9
  • 20 Jun 12
  • Gudu Software
  • WinXP, Windows Vista, Windows 7, Windows 7 x64
  • Shareware
  • 3 Mb
  • 546
  • $149.95
 
 

Review General SQL Parser .NET

  • captcha
 

Other software of Gudu Software
  • Easydump for Oracle  v.1.2.0EasyDump for Oracle is a GUI interface tool used to Export/Import data objects, It is based on Oracle's Export/Import utility. Ftp or copy dmp file to remote server after export automatically.This tool is especially useful to those Oracle DBA who ...
  • Easyscript for Oracle  v.1.2.0Easyscript for Oracle is a tool to help you manage scripts efficiently and use scripts easily. The goal of easyscript is providing you a uniform and easy envrionment to manage and use your scripts.
  • EasySQL Checker for Oracle  v.1.0.0EasySQL Checker for Oracle is a SQL syntax validation tool, It can check to see whether a SQL statement syntax is valid before you actually run it against Oracle. It can opens several SQL files together and check all on the fly,then you can go ...

New Components & Libraries software
  • DotConnect for MailChimp  v.1.7dotConnect for MailChimp is an ADO.NET provider for working with MailChimp data through the standard ADO.NET or Entity Framework interfaces.
  • Mgosoft PS To PDF SDK  v.9.1.2Mgosoft PS To PDF is a simple tool that supports converting PostScript (PS) documents effectively, into Portable Document Format (PDF) format files.
  • Devart ODBC Driver for MySQL  v.2.4Devart ODBC Driver for MySQL provides high-performance and feature-rich connectivity solution for ODBC-based applications to access MySQL databases from Windows, both 32-bit and 64-bit.
  • Devart ODBC Driver for InterBase  v.2.2Devart ODBC Driver for InterBase provides high-performance and feature-rich connectivity solution for ODBC-based applications to access InterBase databases from Windows, both 32-bit and 64-bit.
  • Clipsmm  v.0.2.0 Betaclipsmm was developed as an accessible C++ interface and library for CLIPS. CLIPS is an environment for creating rule-based and/or object-based expert systems. clipsmm extends the CLIPS C API in several ways: · CLIPS Environments are ...
  • Libevent  v.2.0.16libevent is meant to replace the event loop found in event driven network servers. An application just needs to call event_dispatch() and then add or remove events dynamically without having to change the event loop. The libevent API provides a ...