If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Applications & Tools > Tool for converting SQL, e.g. parsing MySql DDL and generating similar SQL Server DDL

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 01-30-10, 09:42
DbTom DbTom is offline
Registered User
 
Join Date: Jan 2010
Posts: 1
Tool for converting SQL, e.g. parsing MySql DDL and generating similar SQL Server DDL

What tools exist for converting SQL scripts between different dialects ?

The ideal application I am looking for would be a GUI app with two textareas, and you would paste some SQL (DDL or DML) into one of the textareas, and then make a selection where you specify how the parser should try to comprehend that SQL, i.e. you might specify that the SQL in the textarea should be parsed as mySql dialect.
Then the other textarea should display the converted/generated SQL which is equivalent but written with a target dialect that you also should have specified.

If there is no such GUI based applications, but only some command line applicactions, e.g. ant tasks or some kind of reusable scripts for different conversions, then it would be better than nothing at least, i.e. better than manually trying to convert between dialects.

Do these kind of applications exist and is there any free such tools, and which ones are the best ?

/ Tom
Reply With Quote
  #2 (permalink)  
Old 01-30-10, 19:37
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,309
I've seen many tools that will convert a GUI based query to different dialects of SQL, but I've never seen a usable tool to convert SQL code from one dialect to another. In some ways, this would be harder than natural language translation (English to Chinese for example).

If you find anything that can do even a mediocre job, I'd love to hear about it.

-PatP
__________________
In theory, theory and practice are identical. In practice, theory and practice are unrelated.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On