Roadmap

This is the features roadmap for Oracle SnowConvert

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Coming Soon

• Parse and translate CREATE MATERIALIZED VIEW

• Provide preprocess tasks in SnowConvert for Oracle

• Custom mappings for column types (only DATE data type)

• Support pseudotypes

Planned

• Report for identified keywords (elements.csv)

• Translation for ALTER VIEW

• Translation for DROP TABLE and DROP VIEW

• Documentation that describes the issue, adds some example codes to understand the issue and provides some recommendations for solving manually the Issue.

• Translation for CREATE OR REPLACE TRIGGER

• Translation for CREATE DATABASE LINK

• Translation for CREATE TYPE

• Translation for CREATE INDEX

• Data Lineage generation

• Parse and translate CREATE TRIGGER

• Extensibility to add custom translation rules

Delivered

• Translation for Records to Snowflake Scripting

• Provide arrange script in SnowConvert for Oracle

• Translation for most common built-in packages

• Translate Packages to Snowflake Scripting

• Translate Procedures to Snowflake Scripting

• Translate Functions to Snowflake Scripting

• Improve parser's robustness when parsing CREATE PACKAGE and CREATE PACKAGE BODY

• New Assessment Mode HTML Report

• Translation for CREATE PROCEDURE statements:

  • Collections

  • Record

  • Custom Types

• Parse and translate for CREATE PACKAGE and CREATE PACKAGE BODY

• Improvements for the Assessment Report: details per Top Level Object

• Translation for CREATE FUNCTION

• Provide to the users a Command Line Interface for running the migrations

• Translation for CREATE PROCEDURE and its main statements:

  • Translation for Execute Inmediate

  • Translation for Cursor related statements:

    • Cursor Variable Declaration

    • Explicit Cursor Declaration and definition

    • Cursor FOR LOOP

    • Open

    • Fetch

    • Close

    • Implicit Cursor Attribute

  • Translation for Exception Handler

  • Translation for PL/SQL Expressions

  • Translation for INSERT, UPDATE, DELETE, MERGE and SELECT inside a procedure.

• TopLevelObjects csv report

• Translation for CREATE PROCEDURE and its main statements:

  • Translation for IF Statement

  • Translation for CASE Statement

  • Translation for Variable Declaration and Assignment

  • Translation for Constant Declaration

  • Translation for Variable Declaration and Assignment

  • Translation for Constant Declaration

  • Translation for Commit

  • Translation for Exit

• Parsing and translation for CREATE TABLE

• Parsing and translation for CREATE VIEW

• Parsing and translation for CREATE SYNONYM

• Parsing and translation for CREATE INDEX and CREATE DATABASE LINK

• Parsing and translation for CREATE SEQUENCE

• Parsing and Translation for ALTER TABLE

• Parsing for CREATE PROCEDURE and its main statements

• Parsing and translation for most commonly used FUNCTIONS

• Generation of EWIs and Empty UDFs for unsupPorted FUNCTIONS

• Assessment for Tables, Views, Synonyms and basic inventory information for Procedures