Post reply

Transfer data from Sybase to SQL Server 2005/2008

  • June 16, 2011 at 10:17 am

    #242330

    Hi All,

    I've an application, which uses SYSBASE as back end. Now I want to use SQL Server 2008 and want to transfer entire database to MS SQL 2008.

    I know how to build SSIS Package, but couldn't find provider for SYBASE under OLE DB or ADO.NET Source Editor->Configure OLE DB Connection Manager/Configure ADO.NET Connection Manager->Connection Manager->Provider.

    Does anybody have solution for this?

    Thanks in advance!

  • June 16, 2011 at 10:48 am

    #1339906

    Have a look at the Sybase Migration Assistant provided by Microsoft:

    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=f39d6150-e611-46e1-84c5-0808010711c8&displaylang=en

    One of the pre-reqs:

    • The Sybase OLE DB provider and connectivity to the Sybase ASE database server that contains the databases you want to migrate. You can install providers from the Sybase ASE product media.

    You'll need to attain the OLE DB provider that matches your version of Sybase from your Sybase media or from the Sybase website.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • June 16, 2011 at 11:38 am

    #1339935

    Thank You!!!

  • June 16, 2011 at 3:05 pm

    #1340087

    You're welcome, thanks for posting back 🙂

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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