Roadmap

This is the features roadmap for Oracle SnowConvert

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