testing: How do I check Migration of SQL server fields makes transformations as expected

lundi 5 mars 2018

Suppose my source table is:

CREATE TABLE Other1 (
    Other1Id varchar(10),
    Primary int,
    Ref1 varchar(10)
)

And My legacy table is

CREATE TABLE Other1Legacy (
    Other1Id varchar(10),
    [Primary] int,
    Ref1 varchar(10)
);

I have a mapping table to transform the Ref1 of the legacy table into the target. The structure of my mapping table is as follow:

Create table mappingTable(
    OldCode varchar(5),
    NewCode varchar(5),
)

How do I check whether the field Ref1 is correctly transformed?

testing