Workflow

Setting up staging connections

You can generate tests for all objects which are correctly created at once, or for a specific object.

For tables and views, there is only one test and that one compares that the data returned is the same in source and target.

For procedures, we will actually follow the parameter usage to determine which data to use when generating tests.

For functions, we will also generated tests based on parameter usage, but the validation is simpler due to the fact that functions can't change database state.

Triggers are not tested as they anyway affect procedural code side-effects.