2.2.4 Migration Test

2.2.4 Migration Test

Migration Case By Data Type

References:

1) Migrating Data By Type​

2) How to create / run Daily Batch Job​

3) Data Quality Service for Data Integrity​

4) How to utilize Data Warehouse

Test Case By Data Type

Implementation ETL (Extract, Transform, and Load) Tool and Data Integrity Tool for Test

For this test, we implemented SSIS (SQL Server Integration Service) package, and to monitor data integrity, we implemented Data migration monitoring App using Angular for front-end and node.js for back-end.

See More:

Implementing SSIS (SQL Server Integration Service)

Migration Monitoring App with Angular for front-end

Migration Monitoring App with Node.js for back-end

TEST Result

---

For First Test,

Test Case ID: GS_MIG_002

Test Scenario: Migrate Dynamic Data

Test Case: 02. Migrate SQL server's live data 
(import_product, import_product_version...) 
to MongoDB (without Temp DB)

Pre-Condition:

1. Start SQL Server

• Confirm the service status (SQL Server and SQL Server Browser must be started)

2. Set up tables on SQL Server

• Create tables: import_product, import_product_version
• Make 100 source data to migrate

3. Set up a MongoDB​

• Create collection: import_product_ms

4. Write SSIS package

5. Implement Migration data Monitoring App

Test Step:

1. Open Migration data Monitoring App

2. Open SSIS package with Visual Studio

3. Execute ETL tool to migrate data (with SSIS)

• Confirm the complete of SSIS in normal

4. Confirm the data on target database (MongoDB)

Expected Result:

• Target DB's document count is the same to the source DB's row count.​
• There is no different data between source and target DB.

Actual Result:

• Using Data Monitoring App, confirm that the data count is the same and there is no data difference

• As a result of the test, Actual Result is the same to Expected Result.

Status(Pass/Fail): Pass

---

For second Test,

Test Case ID: GS_MIG_002

Test Scenario: Migrate Dynamic Data

Test Case: 03. Migrate SQL server's live data 
(import_product, import_product_version...) 
to MongoDB (without Temp DB), generating unmatched data

Pre-Condition:

This is the same to GS_MIG_002_02 Test Case.

Test Step:

1. Open Migration data Monitoring App

2. Open SSIS package with Visual Studio

3. Set up the break-point

4. Execute ETL tool to migrate data (with SSIS)

• Confirm the complete of SSIS in normal

5. Confirm that execution is suspended in break-point

6. Confirm the data on target database (MongoDB)

7. Change MongoDB data to test data difference check: pid, gtin, gln, productName_en, productName_fr

8. Resume SSIS package

9. Confirm tests collection has document on MongoDB.

Expected Result:

• There is different data between source and target DB.​

Actual Result:

• Using Data Monitoring App, confirm that there is different data.

• As a result of the test, Actual Result is the same to Expected Result.

Status(Pass/Fail): Pass