This client wanted to move from Oracle DBMS to Snowflake in order to save significantly on licensing costs and related scaling issues. The trouble was that there was no clear path to do this – at the time, no tool existed to simply port over the tables. We created a DDL translator that would facilitate and easier lift and approach to the database schema and data. We created a python program that would ingest large Oracle DDLs and generate correctly formatted Snowflake DDL that could then be executed on Snowflake. The harder part of this migration was the conversion of PL SQL to functional code on Snowflake. This was done over a longer period of time using Javascript.
-Jeremy Brooks
