EAS-AVS Parallel Testing

This page serves as a plan for parallel testing EAS and AVS.
During this exercise, we will use DBI QA and EAS PROD.
We can use EAS PROD because it is not in PROD.
EAS will be in PROD after this release.

Prepare Databases (October 11, 2011 1700)

• Copy the DBI production database(s) to the QA environment.
• Run AVS-EAS ETL
• The addresses in DBI QA should match those in EAS PROD.

Confirm Readiness (October 12, 2011)

The database preparation may take overnight.
Here we just want to confirm that we are ready to go into parallel on Monday Morning.

Begin Parallel Testing (October 14, 2011 0800)

• For every address modified in AVS PROD, make the same changes in EAS PROD.
• At the end of each day, confirm that AVS QA and AVS PROD are materially the same.
• TODO - We'll need some SQL to generate a list of changes that we can easily compare.
• TODO - does AVS have a way to extract "changes since yesterday"?