Database Schema Conversion Toolkit

Note

This extension will be retired on December 15, 2024. We will stop supporting this tool for any issues that arise, and will not issue any bug fixes or further updates.

The Database Schema Conversion Toolkit is an Azure Data Studio extension for converting Oracle database schemas to Microsoft SQL platform. It helps in converting majority of the database storage objects and code objects to a format compatible with the target database. The Database Schema Conversion Toolkit in Azure Data Studio enables the previously unsupported migration and modernization of Oracle workloads in exclusively Linux environments compared to SQL Server Migration Assistant.

This section introduces you to Database Schema Conversion Toolkit and provides step-by-step instructions for converting Oracle databases schema.

Supported sources

Oracle databases version 11.2.0.4 and above are supported as the source.

Note

Database Schema Conversion Toolkit extension is dependent on the Extension for Oracle to establish connection to the Oracle database and SQL Database Projects extension to display the converted schema output and its deployment on target.

Supported targets

The Database Schema Conversion Toolkit extension currently supports the following targets:

  • Microsoft SQL Server 2017 and above
  • Azure SQL Database
  • Azure SQL Managed Instance

Currently supported objects

The Database Schema Conversion Toolkit supports automated conversion of the following database objects from Oracle to Microsoft SQL platform:

  • Basic table definitions (columns, indexes, primary key, foreign key, unique and check constraints)
  • Procedures
  • Views
  • Triggers
  • Sequences
  • Synonyms
  • Basic Routines and calls to user defined routines
  • Basic DDL, TCL statements including built-in functions
  • Programability constructs like Exceptions, CTEs
  • Support for expressions like CASE, LOOPs, Conditions

Note

If your database contains a significant amount of objects that the Database Schema Conversion Toolkit does not currently support, you may consider using SQL Server Migration Assistant for Oracle, which provides automated conversion for additional object types, but can only be used on Windows.