Vembu Releases PL2TSQL, The First Ever Tool to Migrate From
Oracle PL/SQL to Microsoft T-SQL
October 1, 2003 - Vembu Technologies, a startup company
focusing on developing database tools, announced today the
general availability of PL2TSQL 1.0, a PL/SQL to T-SQL migration
tool. The PL2TSQL tool takes Oracle PL/SQL Packages, Procedures,
Functions and Triggers and converts them into Microsoft SQL-Server
T-SQL code.
The PL2TSQL product is the first ever tool which automatically
converts PL/SQL to T-SQL. "This is a very significant
product considering the momentum Microsoft SQL-Server is getting
in the market" Said Sekar Vembu, CEO of Vembu Technologies.
"Even before we released the product we have couple of
paying customers, one of them being Ramco Systems, in Chennai,
India who are converting more than 2.5 million lines of PL/SQL
to T-SQL" added Mr. Vembu.
PL2TSQL1.0 is available for a free evaluation in which the
number of lines that can be converted is restricted. Interested
users can go the www.vembu.com/PL2TSQL.html
and fill up a form to request an evaluation copy.
The following are some of the important features of the PL2TSQL
product
Support
for Conversion of both Named and Anonymous PL/SQL Blocks
to Transact-SQL
Support
for Conversion of ORACLE Datatypes TO SQL SERVER
Support
for User-Defined Datatypes Conversion
Support
for PL/SQL Functions conversion into Transact-SQL Functions
Support
for ORACLE SQL queries conversion into Transact-SQL SQL
Queries
Support for both Scalar and Record Anchoring used in PL/SQL
Support for Cursor Declaration, OPEN, FETCH and CLOSE Statements
Conversion
Support for conversion of Cursor Variables
Support for conversion of User-defined Datatypes
Support for Implicit Cursor Conversions
Support for PL/SQL Conditional Statements conversion
Support for PL/SQL Control Statements conversion
Support for Native Dynamic SQL Statements(NDS) conversion
Support for %ROWCOUNT, %FOUND and %NOTFOUND cursor attributes
Support for PL/SQL Label Conversions
Support for PL/SQL IN OUT modes conversion
Support for PL/SQL Record Statements
Transaction features Conversion for 'COMMIT', 'ROLLBACK',
'SAVEPOINT' etc. are supported
Support for many other PL/SQL Syntaxes like '||' into Transact-SQL
A user friendly Graphical user interface is provided.
