Post reply

Get out data from Oracle to load into to SQL 2K5

  • April 1, 2007 at 4:06 pm

    #119270

    Hello,

    I have this job:

    I have to get out lots of data from Oracle Db (frequently at day, may be automatically/scheduled) and to load data to SQL Server 2005.

    SSIS is a good tool to do it (fast and good performance).

    Or using Bulk/bcp remain the best one?

    Thank

  • April 1, 2007 at 4:24 pm

    #698013

    I would like to add that Oracle is on HP-Unix server.

    Thank any help will be very appreciated.

    Thank

  • April 3, 2007 at 7:36 am

    #698277

    Link Oracle db to the link servers in SQL 2K2 and use openrowset function.

    select into [tableSQL2k5] from openrowset(ORACLE_DB, select * from

    );

     

     

     

  • April 5, 2007 at 8:44 am

    #698820

    Openrowset may be interesting, but because of etherogeneous systems and diffrent tables in not applicable.

    I need to extract data from some tables in ORACLE that are in structure different from SQL 2K5 one.

    So I have to transform them before loaded to SQL 2K5.

    Any help will be very appreciated.

     

    Thank

  • April 10, 2007 at 4:06 am

    #699479

    Hello,

    anybody work with Oracle and SQL server 2005 to move data?

    Any experiences to help me?

     

    Thank

Viewing 5 posts - 1 through 4 (of 4 total)

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