Post reply

Transfer DATA from Syabse to SQL2008

  • July 6, 2009 at 5:07 am

    #384918

    Hello All;

    We have two servers here, the main one using Sybase database version 12.5.4 and the backup one is SQL 2008. We have copied/created the database in Syabse into SQL 2008.

    1) Now I would like to know What is the best way to transafer data from sybase to SQL 2008 on daily basis? for example; SSIS, DTS or a 3rd type party (if there is any),,, and

    2) Is it better to do it on sceduled job or if it's possible transfering it online?

  • July 7, 2009 at 8:53 am

    #1021121

    We used DTS in SQL 2005. It works fine, but you need to make changes to the stored procedures.

    I thought there was a Sybase import/conversion utility in SQL 2008?

  • July 12, 2009 at 4:32 am

    #1023588

    Hello David,

    Thanks for your reply; But i will need more help with this. Anybody out there can help with more ideas?

    Thanks in advance!

  • July 13, 2009 at 10:56 am

    #1024049

    Replication anybody ?

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

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

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