Language
You are here:HomeTechnologies
Next Topic:Profile

Downloads

Original code
Translated code

MSSQL/Oracle Compiler

1. Problems

Problem #1

Oracle tools and other professional solutions provide only a poor (or no) translation of T-SQL data, DDL, DML and especially stored procedure code to enable switching from MSSQL to Oracle or to support both platforms with a single written codebase. Therefore, for an ISV, it is very difficult and expensive to switch.


Problem #2

Many software companies have to support MSSQL and Oracle at the same time because of the demands of their customers. In order to achieve this, they must reduce their DB complexity dramatically and/or develop their more complex SQL code twice over.

2. Solution

Over the last three years, CEITON has developed for its own purpose a two-phase approach. It allows you to convert an MSSQL DB to Oracle any time, completely and without problems. Secondly, it allows you to translate all future changes on an MSSQL server to those Oracle DBs in order to allow continued development and updates.


CEITON Oracle Transparent Gateway for MSSQL

This fixes some of the problems of the Oracle tools and allows a complete conversion of a DB without any manual SQL corrections.


CEITON MSSQL Oracle Cross Compiler and Coordinator

This is an MSSQL compiler that first translates all MSSQL code, including stored procedures, functions, views, indexes etc., to optimized PL/SQL code. In addition, it also translates MSSQL features, which do not actually exist in Oracle, such as complete updates on joined views etc. Furthermore, the cross-compiler can be used with the help of the CEITON Oracle Coordinator to translate updates and changes of existing DBs to PL/SQL, including the most complex interdependent stored procedures.

3. Results

With these revolutionary tools, CEITON has converted its own MSSQL workflow databases, comprising approx. 200GB and around 3,000 extremely complex stored procedures and functions, to Oracle for miscellaneous customers. All current and future developments and updates written in T-SQL can be translated automatically to Oracle. This enables the support of both MSSQL and Oracle platforms without duplicate development efforts.


Benefits

For software companies it is easier to move to Oracle without breaking with Microsoft. Oracle simply gets more clients. Microsoft does not lose clients to Oracle completely when ISVs need to support Oracle for any reason. The users of the tools generate new revenues. Everybody wins.


Data Definition Language is, in the context of databases, a language with the help of which you can create, change or delete data structures.
Data Manipulation Language is, in the context of databases, a language, which is required to read, overwrite or delete data from a database.