Oracle Importing to Snowflake

How to import an Oracle project to Snowflake

SqlDBM Support avatar
Written by SqlDBM Support
Updated over a week ago

Note, this is an Enterprise feature.

Conversion for Oracle projects is not yet available as with other project types. However, the following method exists for converting Oracle DDL to a new Snowflake project.

The following video shows how to:

  1. Start a new Snowflake project.

  2. Reverse Engineer from Oracle DDL.

  3. Forward Engineer Snowflake DDL and import to an existing project.

To convert Oracle DDL to Snowflake:

  • Create a new Project

  • Select Snowflake as the project type

  • Click the "Bring your Database" button.

Next, change the import source from Snowflake to Oracle following the steps below:

1. On the top of the screen, click the "Import From" link

2. Select the "Oracle" option

3. Press "Apply"

Next, provide the Oracle DDL by pasting it into the text area provided or uploading a file and proceed with project creation using the steps below:

1. Upload your Oracle DDL script or paste it into the text editor. Click the upload (up arrow) or the "Upload It" button.

2. Once your DDL has been parsed, review the "Add Tables" options on the right to select which diagrams will be generated.

  • "Reverse Engineer Diagram" - generates an ER diagram with all the objects in the script and their relationships.

  • "RE: Schema Diagrams" - generates an ER Diagram per schema object in the DDL

3. When you're ready, press the "Import" button or triangle icon on the top menu bar to finish Reverse Engineering your database.

Did this answer your question?