update from between database

Discussion in 'ASP .Net' started by Thomas, Jul 29, 2003.

  1. Thomas

    Thomas Guest

    I have a Informix Database on Solaris and a SQL database. I need to
    update from Informix to SQL daily. Is there any easy way of doing it?
    BTW, I tried to use OleDbDataAdpater.Update to do the job. Nothing
    happened after the program worked diligently for a while.

    Thanks
    Thomas, Jul 29, 2003
    #1
    1. Advertising

  2. Thomas

    Jody Fisher Guest

    DTS

    "Thomas" <> wrote in message
    news:...
    > I have a Informix Database on Solaris and a SQL database. I need to
    > update from Informix to SQL daily. Is there any easy way of doing it?
    > BTW, I tried to use OleDbDataAdpater.Update to do the job. Nothing
    > happened after the program worked diligently for a while.
    >
    > Thanks
    Jody Fisher, Jul 29, 2003
    #2
    1. Advertising

  3. I'd suggest using SQL Server Data Transformation Services (DTS)
    Here's more info:
    http://www.microsoft.com/sql/evaluation/features/datatran.asp

    --
    I hope this helps,
    Steve C. Orr, MCSD
    http://Steve.Orr.net


    "Thomas" <> wrote in message
    news:...
    > I have a Informix Database on Solaris and a SQL database. I need to
    > update from Informix to SQL daily. Is there any easy way of doing it?
    > BTW, I tried to use OleDbDataAdpater.Update to do the job. Nothing
    > happened after the program worked diligently for a while.
    >
    > Thanks
    Steve C. Orr, MCSD, Jul 29, 2003
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Hartmut Schroth
    Replies:
    3
    Views:
    3,499
    Hartmut Schroth
    Dec 1, 2003
  2. joun
    Replies:
    9
    Views:
    2,236
    W.G. Ryan eMVP
    Nov 30, 2004
  3. joun
    Replies:
    5
    Views:
    2,663
  4. =?Utf-8?B?TWljaGFlbA==?=

    How to update datagrid after update

    =?Utf-8?B?TWljaGFlbA==?=, Mar 17, 2006, in forum: ASP .Net
    Replies:
    1
    Views:
    500
    Alex D.
    Mar 17, 2006
  5. mesut
    Replies:
    0
    Views:
    663
    mesut
    Feb 19, 2007
Loading...

Share This Page