I understand that the data can be moved in a variety of ways, like below.
But what about the DDL itself?
I have a SQL 2014 database, and two more from 2016, 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. . indexes, too, but indexes is not a priority. What are my best options?
Obtain Oracle DDL = How ?
Move data to Oracle = below, and more, relatively clear and easy:
Use a tool such as Microsoft SQL Server Migration Assistant for Oracle.
Use SQL Server Integration Services (SSIS).
Create a Linked Server on SQL Server pointing to the Oracle database.
Export Oracle data to a CSV file and then import the data to SQL Server via bulk copy.
likes to play chess