Procedures

We use static analysis to track the usage of procedure parameters. If any of them are used to compare against specific views or tables, we will pick a subset of rows from affected tables, then generate tests by populating the procedure parameters using the staging database data.

You can edit the existing test to use values you know well and can validate easier. You can also generate tests completely manually by explicitly specifying all parameter values.

Validation compares procedure return values (data sets) and comparison of all affected tables in source and target to ensure that all procedure side-effects are equivalent.