Professional Web Applications Themes

How to copy tables fra MS SQL2000 to DB2 - IBM DB2

I need to setup some automated jobs to copy data to a DB2 8.1 UDB. Data has to be renewed every night. One way woulkd be to unload to a text file and load from this, but I hope there is a smarter way ?? Any help is greatly appreciated. /Jep...

  1. #1

    Default How to copy tables fra MS SQL2000 to DB2



    I need to setup some automated jobs to copy data to a DB2 8.1 UDB.

    Data has to be renewed every night.

    One way woulkd be to unload to a text file and load from this, but I
    hope there is a smarter way ??


    Any help is greatly appreciated.
    /Jep



    Jep Guest

  2. #2

    Default Re: How to copy tables fra MS SQL2000 to DB2

    Larry <lsedelsus.ibm.com> wrote in message news:<3F3D0890.324050A3us.ibm.com>...
    > Use DB2 Data Propagator (tion). Purchase and install DB2
    > Information Integrator tion Edition.
    >
    > Larry
    >
    > Jep wrote:
    >
    > > I need to setup some automated jobs to copy data to a DB2 8.1 UDB.
    > >
    > > Data has to be renewed every night.
    > >
    > > One way woulkd be to unload to a text file and load from this, but I
    > > hope there is a smarter way ??
    > >
    > > Any help is greatly appreciated.
    > > /Jep
    Have you look into the DTS tool that comes with SQLServer?
    Ollie Guest

  3. #3

    Default Re: How to copy tables fra MS SQL2000 to DB2

    I would suggest DB2 tion (DB2 Data Propagator).

    Jep wrote:
    >
    > I need to setup some automated jobs to copy data to a DB2 8.1 UDB.
    >
    > Data has to be renewed every night.
    >
    > One way woulkd be to unload to a text file and load from this, but I
    > hope there is a smarter way ??
    >
    >
    > Any help is greatly appreciated.
    > /Jep
    >
    >
    >
    Blair Adamache Guest

Similar Threads

  1. sql2000 backwards
    By ranger in forum Coldfusion Database Access
    Replies: 0
    Last Post: March 13th, 11:02 AM
  2. CF, SQL2000, and XML
    By Osgyth in forum Coldfusion Database Access
    Replies: 0
    Last Post: March 3rd, 08:59 PM
  3. iis/asp + sql2000 a bit slow
    By Florian in forum ASP Database
    Replies: 12
    Last Post: February 8th, 10:13 PM
  4. Tables...Copy/Paste from Word
    By Gunjani in forum Web Design
    Replies: 0
    Last Post: December 4th, 12:45 PM
  5. ASP + SQL2000 : request with COMPUTE SUM(xx)
    By Bryce in forum ASP Database
    Replies: 1
    Last Post: September 22nd, 04:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not 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