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

  • VoldemarG

    Hall of Fame

    Points: 3571

    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

  • frederico_fonseca

    SSChampion

    Points: 14390

    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: 3571

    Yes, thanks. I got it.


    Voldemar
    likes to play chess

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

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