Links

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