Post reply

SQL Server DDL to Oracle DDL Tool?

  • January 9, 2002 at 3:35 am

    #77985

    Hi

    We have a Database on SQL Server and Mirror version of it on Oracle on a Web-server. When I make structural changes to the SQL Server DB via a Script of DDL, I would like to be able to take this script and convert it to Oracle DDL to apply to the Oracle DB.

    We can do this manually of course but it would be preferable to be able to run the script through some automated tool to convert it to remove the Human Error aspect. It would also be less time consuming.

    Does anybody know if such a Utopian Tool exists?

    TIA

    Simon Horne

  • January 9, 2002 at 4:50 am

    #421982

    Oracle have a Migration Work Bench that might do the trick?

    http://technet.oracle.com/docs/tech/migration/workbench/content.html


    Simon Sabin
    SQL Server MVP

    http://sqlblogcasts.com/blogs/simons

  • January 9, 2002 at 5:18 am

    #421985

    Thanks,

    I'll give it a look

    Simon

  • January 9, 2002 at 10:18 am

    #422001

    The Embarkadero tool ER/Studio can make a change to a logical design doc and roll that forward to multiple physical designs. You could have one physical design for SQL and one for Oracle. It's a nice tool, but $$.

    I assume ErWin can do this as well.

    Steve Jones

    steve@dkranch.net

Viewing 4 posts - 1 through 3 (of 3 total)

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