Professional Web Applications Themes

Snapshot from DB2 to Oracle - IBM DB2

Hi Is there anyway to transfer data from Db2 to Oracle like Oracle's snapshot? I am doing this already using a java program which selects from source DB2 (v8) and inserts into destination Oracle (8.1.7). Its one to one insert. I am wondering is there any DB2/Oracle tools which does this like a snapshot or similar functionality. Thanks V Prakash...

  1. #1

    Default Snapshot from DB2 to Oracle

    Hi

    Is there anyway to transfer data from Db2 to Oracle like Oracle's
    snapshot?

    I am doing this already using a java program which selects from source
    DB2 (v8) and inserts into destination Oracle (8.1.7). Its one to one
    insert.

    I am wondering is there any DB2/Oracle tools which does this like a
    snapshot or similar functionality.

    Thanks

    V Prakash
    Prakash Guest

  2. #2

    Default Re: Snapshot from DB2 to Oracle

    See WinSQL Professional (http://www.synametrics.com/winsql)


    --
    ------------------------------------------------------------------------
    This email is certified to be Spam free by Spam Marshall

    You don't pay to get spam, why pay to clean it?
    Visit http://www.spammarshall.com to create an account for free
    <http://www.spammarshall.com>

    ------------------------------------------------------------------------
    Prakash wrote:
     


    Kathy Guest

  3. #3

    Default Re: Snapshot from DB2 to Oracle

    You can use IBM's Data Propagator Relational product, and you will also
    need IBM Information Integrator to do the "translation" between DB2 and
    Oracle.

    Larry Edelstein

    Prakash wrote:
     

    Larry Guest

  4. #4

    Default Re: Snapshot from DB2 to Oracle

    Prakash wrote:
     
    You can use IBM's Data Propagator Relational product as Larry suggests
    or contact Oracle about their
    line of Transparent Gateways.

    --
    Daniel Morgan
    http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
    http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
    damorganx.washington.edu
    (replace 'x' with a 'u' to reply)

    Daniel Guest

  5. #5

    Default Re: Snapshot from DB2 to Oracle

    Hi there,

    StarQuest has a DB2 to Oracle tion solution :
    http://www.starquest.com/Productfolder/infosqdr.html

    It is pretty simple to use and also includes scheduled tions.

    Bob

    com (Prakash) wrote in message news:<google.com>... 
    DB2 Guest

Similar Threads

  1. Snapshot issue
    By emullet in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: December 18th, 11:36 PM
  2. Snapshot of FLV
    By U. Tote in forum Macromedia Flash Actionscript
    Replies: 0
    Last Post: January 16th, 03:51 PM
  3. snapshot
    By Jaz in forum AIX
    Replies: 5
    Last Post: July 18th, 07:47 PM
  4. Snapshot of 3D scene?
    By Phoonzang webforumsuser@macromedia.com in forum Macromedia Director 3D
    Replies: 2
    Last Post: July 9th, 11:01 AM
  5. Snapshot on a Snapshot
    By Pete Sharman in forum Oracle Server
    Replies: 1
    Last Post: December 12th, 05:57 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