Migrating Data from ORACLE to SYBASE

  • karthik M

    One Orange Chip

    Points: 29139

    All,

    One of my co worker pinged me and asked "is there any tool or jobs available to migrate data from ORACLE to SYBASE", then i suggested to use SQLSERVER DTS package to move data from ORACLE to SYBASE.

    I would like to know whether my suggestion is correct or wrong.

    My Email:

    I go for 'SqlServer DTS Package'.This is very user friendly, readable and maintainable.

    ....

    ....

    ....you can use 'DTS Package' which is an inbuilt tool coming along with SQLSERVER. As I said earlier, you don't need any prior Knowledge (like ETL) to run this DTS package. Because it is a wizard, so you can easily catch up the packages.

    karthik

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 720887

    There really is no right or wrong here. Not sure of the tools available for Sybase, though BCP is there. Oracle?

    DTS/SSIS works great and could easily move data from Oracle to Sybase, and if you have the skills, I'd use that. There might be better tools out there, but I'm not familiar with them.

  • karthik M

    One Orange Chip

    Points: 29139

    Steve,

    Thanks for your feedback. I also suggested them to use 'DTS'.

    If you came to know any tools apart from this one,Please let me know.

    karthik

  • terryj30

    SSCommitted

    Points: 1866

    DTS or BCP thats the only way. really

    Regards,

    Terry

  • Vivien Xing

    SSChampion

    Points: 12297

    The recommend tools for the migration are:

    · PowerDesigner for the data schema creation

    · BCP (Sybase Bulk Copy) or CIS (Sybase Component Integration Services) for

    moving the data

    ......

    · export the Oracle data

    · import into Sybase ASE

    Ref: Oracle to Sybase ASE Migration Guide

    http://www.sybase.com/detail?id=1022159

  • Alexsap2020

    Grasshopper

    Points: 16

    MnMTK migrated data to SAP/ Sybase

    https://www.ispirer.com/products/oracle-to-sybase-ase-migration

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply