Post reply

T-SQL to ANSI-SQL converter

  • May 16, 2008 at 6:39 am

    #71271

    Hi,

    I'm just wondering if anyone would know of converter tool that takes t-sql (2000) and converts it to ansi-sql, specifically stored procedures and views, making it compatible with mySQL server?

    Or, if anyone could sum up the effort of converting the datamodel and logic from SQL Server 2000 to mySQL? Specifically the objects one would have to tailor by hand?

    Thanks

    /Timo

  • May 16, 2008 at 11:16 pm

    #816834

    There are a lot of things in SQL Server that have no replacement in ANSI SQL. And, I've never heard of such a converter... basically, portability is a myth.

    So far as conversion goes, you're going to need to know both languages really well, plain and simple.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply