Does Altibase guarantee data consistency after migration?
Yes. Altibase guarantees data consistency with proven methodology and extensive battle-tested experiences. Altibase’s Migration Center executes a validity check to ensure that the data in the source database and the data that were migrated to the target database are identical. In addition, if there are any inconsistencies, Migration Center will generate a report so that the user can intervene.
Data Consistency
- Altibase Migration Center meets the requirements to guarantee data consistency via:
- Analysis phase: validation of execution rules through accurate analysis of duplicated data, mismatched data types, etc.
- Migration phase: comparison of data values between source and target data objects
- An example of comparison report:
|
Time Information |
Duration |
Start Time |
End Time |
|
|
0:00:00.516 |
09/04/2013 16:05:11 |
09/04/2013 16:05:11 |
||
|
Database Information |
Source Database |
Target Database |
||
|
Connection Name |
ora11g |
Altibase |
||
|
Address |
192.168.1.62:1521 |
127.0.0.1:20300 |
||
|
DB Name |
Oracle |
ALTIDB |
||
|
User ID |
Orauser |
Altiuser |
||
|
Migration Information |
||||
|
Object |
# of Differences |
# of Source Objects |
# of Target Objects |
|
|
Sequence |
0 |
10 |
10 |
|
|
Table 1 |
0 |
100 |
100 |
|
|
Row |
0 |
100,000 |
100,000 |
|
|
Data Value |
0 |
400,000 |
400,000 |
|
|
Table 2 |
0 |
100 |
100 |
|
|
Row |
0 |
100,000 |
100,000 |
|
|
Data Value |
0 |
400,000 |
400,000 |
|
|
Table n |
0 |
100 |
100 |
|
|
Row |
0 |
100,000 |
100,000 |
|
|
Data Value |
0 |
400,000 |
400,000 |
|
|
Constraints |
0 |
5 |
5 |
|
|
Index |
0 |
30 |
30 |
|
|
Synonym |
0 |
3 |
3 |
|