Sybase CT-LIB to Oracle OCI Conversion

 

We have been spending years to make our automated database migration software SQLWays be more functional and more attractive to the client. Today not only do we propose the database conversion tool SQLWays for stored procedure migration, function migration, trigger migration, view migration, schema migration and data migration. We help understand our clients the value of automated database and application migration solutions that enable business growth.

Today SQLWays can convert Sybase CT-LIB C/C++ API to Oracle OCI.

Conversion features

  • Add the include files for OCI API functions and structures:
  • #include "ocilib.h"
     

     

  • Convert API variable type:
  • CS_CONNECTION *connection;
    CS_COMMAND *cmd;
     

     

    convert to:
    OCI_Connection * connection;
    OCI_Statement * cmd;
     

     

  • Convert API method:
  • ct_connect(connection, (CS_CHAR *) NULL, 0);
    ct_cmd_alloc(connection, &cmd);
    ct_command(cmd, CS_LANG_CMD,
    "select name from customers \
    where state = 'CA'", CS_NULLTERM, CS_UNUSED);
    ct_send(cmd);
     

     

    convert to:
    cmd = OCI_StatementCreate(connection);
    OCI_Prepare(cmd "select name  from customers where state = 'CA'");
    OCI_Execute(cmd);
     

     

  • SQLWays also allows you to convert dynamic SQL in the chosen direction at the same time you convert API.

Way SQLWays

SQLWays API conversion tool can easily migrate Sybase CT-LIB and embedded SQL project to Oracle OCI. This allows you to dramatically decrease conversion risks and significantly reduce in-house efforts. Reasonable pricing strategy makes SQLWays even more powerful instrument for such migration type.

To order a demo of SQLWays conversion software please go to request a demo. To find out about our pricing policy go to request a quote. You can also reach us via e-mail at sales@ispirer.com or support@ispirer.com and get a professional answer to any question.

 
view a demo
request a demo
request sqlways
request a quote
SQLWays for Oracle
Oracle Databases

Oracle 11g, 10g, 9i, 8i, 8.0.x and 7.x

Oracle Exadata v2 and v1

Sybase Databases

Sybase Adaptive Server Enterprise (ASE) 15.x, 12.5.x, 12.0, 11.x and earlier

Sybase Adaptive Server Anywhere (ASA), Sybase SQL Anywhere 11.x, 10.x, 9.0, 8.0.x, 7.0.x, 6.0.x, 5.5 and 5.0

Sybase IQ 12.x

Oracle News
Oracle Testimonials

"IPC uses SQLWays to migrate critical data to our Oracle database, and this is a very clever and very thorough program. The SQLWays programmers have anticipated and solved problems that I hadn't even encountered yet. You can use a wizard, or use it with batch processing or on a schedule. It's a great program and a great value. I heartily recommend SQLWays!"

Patrick Dugan Holmes
VP Technology
IPC - The Hospitalist Company
President
Los Angeles Oracle Users Group