Differences

This shows you the differences between two versions of the page.

sybase-to-oracle-tool [November 16, 2012 3:52 am]
sqlines
sybase-to-oracle-tool [February 14, 2013 9:16 am] (current)
sqlines
Line 1: Line 1:
-====== SQLines Tool - SQL Conversion from Sybase ASE to Oracle ======+====== SQLines Tool - Sybase ASE to Oracle Migration ======
-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 tool allows you to convert database schema (DDL), queries and DML statements, views, stored procedures, functions and triggers from Sybase Adaptive Server Enterprise (Sybase ASE) to Oracle. 
 + 
 +SQLines converts SQL scripts and standalone SQL statements. To migrate data and database schema from a Sybase database to Oracle use [[/sqldata/sybase-to-oracle|SQLines Data]] tool.
===== SQLines Features and Licensing ===== ===== SQLines Features and Licensing =====
-SQLines is available in Standard, Professional and Enterprise editions:+SQLines is available in Online and Desktop editions:
-| |  **Standard**  |  **Professional**  | **Enterprise** +| |  **Online Edition**  |  **Desktop Edition**  |
-| //Lines of Code Limitation// |  Up to 30,000 |  Up to 100,000 |  Unlimited  | +| **License Limitations** |||
 +| //DDL Statements// |  Unlimited |  Unlimited  || 
 +| //DML Statements, Queries and Views// |  Unlimited |  Unlimited  ||  
 +| //Procedural SQL// |  Unlimited  |  Unlimited  ||
| **Conversion Features** |||| | **Conversion Features** ||||
-| //SQL Scripts// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  | +| //DDL - Tables and Indexes// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  ||  
 +| //Queries, Views and DML Statements// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  || 
 +| //Stored Procedures, Functions and Triggers// |  {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  ||
| **Interfaces** |||| | **Interfaces** ||||
-| //Command Line// | {{:green_tick.gif|}} |  {{:green_tick.gif|}}  | {{:green_tick.gif|}}  |   +| //Command Line// |  n/a |  {{:green_tick.gif|}}  ||   
-| //API// |  {{:red_cross.png|}} |  {{:green_tick.gif|}}  | {{:green_tick.gif|}}  | +| //API// |  n/a |  {{:green_tick.gif|}}  ||
| **Platforms** |||| | **Platforms** ||||
-| Windows 32-bit |  {{:green_tick.gif|}} |  {{:green_tick.gif|}}  | {{:green_tick.gif|}}  +| Windows 32-bit |  Hosted |  {{:green_tick.gif|}}  || 
-| Linux x86 32-bit |  {{:green_tick.gif|}} |  {{:green_tick.gif|}}  | {{:green_tick.gif|}}  |+| Linux x86 32-bit |  Hosted |  {{:green_tick.gif|}}  ||
| **Licensing and Support** |||| | **Licensing and Support** ||||
-| //Technical Support// |  {{:green_tick.gif|}}  | {{:green_tick.gif|}}  | {{:green_tick.gif|}}  |  +| //Technical Support// | {{:green_tick.gif|}}  |  {{:green_tick.gif|}}  ||  
-| //Price// |  $375 |  $975 | $1735  |+| //Price// |  Free |  $375 ||
-Try [[http://www.sqlines.com/online|SQLines Online]] or download a [[/download|Trial Version]] (//no registration required)//.+Try [[http://www.sqlines.com/online|SQLines Online]] or download a [[http://www.sqlines.com/download|Trial Version]].
If any you have any questions or need any assistance, please contact us at [[support@sqlines.com]]. If any you have any questions or need any assistance, please contact us at [[support@sqlines.com]].
Line 27: Line 34:
===== Conversion Features ===== ===== Conversion Features =====
-Supported SQL conversion features: +For detailed information about conversion features supported in SQLines, see 
- +[[/sybase-to-oracle|Sybase ASE to Oracle Migration Reference]].
-==== 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 |+