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

  • 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?

    Likes to play Chess

  • 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

  • Yes, thanks. I got it.

    Likes to play Chess

  • This was removed by the editor as SPAM

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

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