-
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.
-
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.
-
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.
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
|
|