update from between database

Ask a Question related to ASP.NET General, Design and Development.

  1. #1

    Default update from between database

    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 Guest

  2. Similar Questions and Discussions

    1. Access Database will not update
      I've got CF7 running on WinXP SP2 with Access 2000 database. Very simple table - 4 fields, all text except the Key. I can view, I can Insert, but...
    2. Use a CFC to update a database with a date
      Hi All, I am trying to input a date in a database field with the current date. The datefield is in one table and I only want the date to be inserted...
    3. update database
      I have a database where I need to input values that I calculate. I only need to do this once, so I wanted to write a template to do this quickly. I...
    4. scheduled update of database
      Hi, I am using MS Access as database. I need to update the table on the 1st day of every quarter. Is there anyway to achieve ASP or MSAccess. ...
    5. Update database using dataset
      I have a number of text boxes that are all data bound to a data set. I would like the user to be able to make changes to these text boxes and then...
  3. #2

    Default Re: update from between database

    DTS

    "Thomas" <cfang@telamon-corp.com> wrote in message
    news:844eec0d.0307281542.2cb1333f@posting.google.c om...
    > 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 Guest

  4. #3

    Default Re: update from between database

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

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


    "Thomas" <cfang@telamon-corp.com> wrote in message
    news:844eec0d.0307281542.2cb1333f@posting.google.c om...
    > 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 Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139