Suppose we've old_table in MS/SQL Server which is getting migrated to
new_table in Oracle.To ensure the consistency & integrity of data we shall
carry out following data checks :-
1) Check count of every column both at old & new migrated table to ensure
all records have been migrated.
2) Check sum of lengths of all columns which are being migrated from source
to target.
But, let us assume that the column_1 in old table has value "Akshay"
migrated to column_2 in new table as "Skshay".Accordingly the results for
both the steps would confirm that the data has been migrated properly.
If there is no DB link provided between MS SQL Server &
Oracle(therefore Minus query also won't work) then how to ensure accurate
data migration ?
*Thanks & Regards,*
Akshay S. Tanksale
--
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
---
You received this message because you are subscribed to the Google Groups
"Oracle PL/SQL" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
