vignesh.palaniappan

 Profile Answers by vignesh.palaniappan 

• Mar 13th, 2008

 

Data migration is actually the translation of data from one format to another format or from one storage device to another storage device. This also necessarily requires someone or something to do the translating  

Testing can be done by comparing the actual result of the migrated data with the actual result of the data before migration.

ST123

 Profile Answers by ST123 

• Dec 16th, 2009

 

Data migration testing is to compare migrated data with original data to find out any discrepancies. Database Migration Testing:

1. We have to check database integrity.
2. We have to check the referential integrity.
3. Whether the data are loaded in the target database correctly.
4. Check the constraints.

sudhakar.arige

 Profile Answers by sudhakar.arige 

• Feb 16th, 2010

 

Data migration is translation of data in the tables from one db to another or is can also be from one format to another format.

Checks needed are,

Need to identify the source table in source db & destination table in destination db

Need to check the data base columns in destination db should be respective to source db

Need to consider data types in both source and destination while migrating data

 

Developed Data Migration wizard will make the data migration more easier

Senthilvel

• Jan 19th, 2015

 

Data base Migration testing is done with the help of the Mapping document that defines the complete mapping from the source to the target and also the transformation logic that has to be applied while migrating the data from one DB to another. The Tester has to create SQL Queries with reference to the mapping document provided. There are few validations that would be followed while testing database migration like Data type, Length, Count, Duplicate, Null Value, Referential Integrity, Minus Query validations, Data Completeness etc.

Sats

• Apr 8th, 2015

 

Database migration can be thoroughly tested by first studying the mapping document as to how the migration process is going to translate the data from source to destination and taking a few samples from the source data and then verifying the destination DB with the help of mapping doc.

satish tyagi

• Jun 27th, 2015

 

Can you explain migration testing with help of example