DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: SQL Server DDL to Oracle DDL

  1. #1
    Join Date
    Jan 2002
    Posts
    2

    Question

    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


  2. #2
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    I ** SERIOUSLY ** doubt it : Oracle != SQL Server. An Oracle DDL must inform tablespace info, freelists info, initrans/maxtrans, have different datatypes, different constraints, and so on ...

    Regards,

    Chiappa

  3. #3
    Join Date
    Jan 2002
    Posts
    2

    Smile

    >>have different datatypes, different constraints, <<

    I know It's a bit of a shot in the dark really

    Simon

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166

    Cool

    I do something like that. I use Erwin 4.0 and I have a schema using Sql Server 2000. I maintain that schema and when I want to make changes, I make the changes to the Sql Server 2000 schama and then I just derive a new model pointing to Oracle 8i. It will take some work but if you need to support both Sql Server and Oracle with the same schema it is well worth it. You should keep your schema as Sql Server and then derive the Oracle version, I tried it the other way and it didn't work very well.


Posting Permissions

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


Click Here to Expand Forum to Full Width