Results 1 to 3 of 3

Thread: encounter incorrect record count while migration

  1. 03-11-2005, 11:00 PM #1
    PMMWAN
    PMMWAN is offline Registered User
    Join Date
    Feb 2005
    Location
    Yangon,Myanmar(Burma)
    Posts
    42

    encounter incorrect record count while migration

    hi
    i migrated tables from dbase4 to oracle
    by using sql dts.After migrating,I got
    a problem.for example,
    employee table record count
    in dbase4 is 76967.
    but employee in oracle is 76958.
    so there is differenc between db4 and oracle record count.
    How can i solve these problem and
    How can i trace?
    Any migration tools in oracle8?
    Thanks
    Last edited by PMMWAN; 03-11-2005 at 11:03 PM.
    Reply With Quote Reply With Quote
  2. 03-12-2005, 11:02 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    DTS may have encountered problem migrating those records and you may have set DTS to ignore errros.

    Change properties of the package to fail on first error and log package execution to a file, this will tell you more about the error.
    Reply With Quote Reply With Quote
  3. 03-12-2005, 11:14 AM #3
    Rawhide's Avatar
    Rawhide
    Rawhide is offline Registered User
    Join Date
    Feb 2003
    Posts
    1,048
    Also, if you can link the two servers, run a query to get all records in the dbase4 table that don't exist in the Oracle table. Maybe you will see something obvious about the data that explains it. For example, if the query returns 0 results, then you have duplicate records that were filtered out. Or perhaps you will see rows of null entries.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules