Code conversion to Teradata from Oracle or MS SQL Server

UDA
Enthusiast

Code conversion to Teradata from Oracle or MS SQL Server

I am new to Teradata and have been assigned to convert code of Oracle version or MS SQL Server version of our application to Teradata.

Please suggest which of the two codes( oracle or sql server) will better suit for conversion to Teradata?

Is there any tool available to do that?

Thanks a lot !!
3 REPLIES
Junior Contributor

Re: Code conversion to Teradata from Oracle or MS SQL Server

It mainly depends on the code.
If it's plain SQL and the Oracle UDFs provided by Teradata are installed on your system you could do a 1:1 conversion.

If there are lots of MS Stored Procedures or Oracle PL/SQL you could convert it to Teradata SPs, but the performance might be horrible, especially if there are cursors. If it's a simple SP without loops and cursors you can convert it to a Teradata macro, this should be your first choice.

Dieter
Enthusiast

Re: Code conversion to Teradata from Oracle or MS SQL Server

Thanks for the response Dieter,

We have around 10-15 stored procedures and functions; they have around 20000 lines of code in all with lots of cursors( in fact multiple dynamic cursors( REF cursors in oracle) are open at a time. These procedures/ functions do all the DMLs on our tables.

Beside these there are 150 DDL scripts ( creating tables and views ).

Thanks in advance for your suggestions.

Fan

Re: Code conversion to Teradata from Oracle or MS SQL Server

I'm interested to know how big is the work to concert the Oracle DDL to Teradata DDL. And what kind of work you have to do to define a good primary index.

If you are not changing the primary index, what kind of performance you get?