This is an old revision of the document!


SQLines Tool - SQL Conversion from Sybase ASE to Oracle

SQLines tool allows you to convert database schema (DDL), views, stored procedures, packages, functions, triggers, queries, SQL scripts and embedded SQL from Sybase Adaptive Server Enterprise to Oracle.

SQLines Features and Licensing

SQLines is available in Standard, Professional and Enterprise editions:

Standard Professional Enterprise
Lines of Code Limitation Up to 30,000 Up to 100,000 Unlimited
Conversion Features
SQL Scripts
Interfaces
Command Line
API
Platforms
Windows 32-bit
Linux x86 32-bit
Licensing and Support
Technical Support
Price $375 $975 $1735

Try SQLines Online or download a Trial Version (no registration required).

If any you have any questions or need any assistance, please contact us at support@sqlines.com.

Conversion Features

Supported SQL conversion features:

Transact-SQL Language

Converting Transact-SQL language:

Sybase ASE Oracle
Optional statement delimiter Adding ;

Transact-SQL Stored Procedures

Conversion of Transact-SQL stored procedures:

Sybase ASE Oracle
CREATE PROC CREATE OR REPLACE PROCEDURE
Procedure body without BEGIN END Adding BEGIN END
Returning result set using SELECT Adding OPEN cur FOR SELECT and OUT SYS_REFCURSOR parameter
GO Replacing with /

SQL Statements

Conversion of SQL statements:

Sybase ASE Oracle
CREATE PROC CREATE OR REPLACE PROCEDURE