Results 1 to 2 of 2
  1. #1
    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

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •