I need to move database with 500 tables from SQL Server to Oracle 19

  • VoldemarG

    Hall of Fame

    Points: 3686

    I have a SQL Server database,  that I need to migrate to Oracle 19.

    How can I generate all PL/SQL DDL for all source tables? i need at least CREATE TABLE for each, but of course preferrably with all constraints and Foreign Keys, etc.  .  What are my best options?

    Obtain Oracle DDL     = using what tool or technique?

    Voldemar likes to play CHESS (and IS good at it!)

  • frederico_fonseca

    SSChampion

    Points: 14708

    you need to stop just asking your questions here and google first - plenty of links given for it including some from oracle and one of their tools to do exactly that with step by step instructions.

    Do note that we are not here to do your work for you - specially because you aren't paying us to do it.

    https://www.oracle.com/database/technologies/migrating-sql-to-oracle.html

  • VoldemarG

    Hall of Fame

    Points: 3686

    Yes, thanks. I got it.

    Voldemar likes to play CHESS (and IS good at it!)

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

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