Post reply

progress Database to Sql Server

  • May 12, 2010 at 5:27 pm

    #140285

    Hi ,

    I have a task of Transferring a Progress database to Sqlserver. I have a ODBC connection to Progress database and have Sql server in my local machine.

    Now i am creating a Ado.net Object to connect to Progress using ODBC connection and use it as Source.

    Sql Server Destination is the Target.

    I have A data Flow task and am creating a Data reader object and transfer Table by table from Progress to Sqlserver.

    The problem in this is when i transfer the tabels, only data is transferred , not the relationship between tabels, Please let me know how can i transfer even Relationship that exists in Progress database to Sqlserver tabels.

    1.Can i Do a Database transfer job from Progress to Sqlserver. please help.

    Regards

    Ranjeeta

  • May 18, 2010 at 11:37 am

    #1168994

    No, it is not possible.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • June 10, 2010 at 11:48 am

    #1178820

    Hi

    I have similar task to perform. Would like to know which odbc drivers are used to do data transfer.

    Thanks

    eswar

  • June 10, 2010 at 11:52 am

    #1178826

    eswar_reddy02 (6/10/2010)

    Hi

    I have similar task to perform. Would like to know which odbc drivers are used to do data transfer.

    Thanks

    eswar

    If you use SQL 2008, you can use the out-of-the-box ADO.NET Destination component. If you use SQL 2005, you have to either implement a script or you can use third-party solution like the commercial CozyRoc ODBC Destination component.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • June 11, 2010 at 7:14 am

    #1179150

    Regarding Progress and odbc, we have a similar process: We pull data from Progress 9.1D into SS2000 and SS2005 using Progress merant 3.6 odbc drivers. Simple DTS jobs execute these data transfers. One other thing: We use linked servers that point to the Progress database/odbc drivers.

    The problem is with SS2008 on a 64bit machine (the old SQL servers are 32bit). We can successfully configure the 32bit Progress drivers on the 64 bit server by using the 32bit version of the ODBC manager. The connection test is successful. However, when I try to create a linked server that points to the 32bit odbc drivers, it doesn't work.

    Any tricks for getting the linked server to use the 32bit drivers? Other than just go to 32bit server installation.

    Thanks


    smv929

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

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