Tables

Testing table data equivalence in source and target staging databases

To test tables, we read data from them and ensure that both source and target return exact same data.

SQL Tran does not copy the data from source to the target, but Omni Loader does and is the most performant solution on the market for that exact purpose. Also, SQL Tran and Omni Loader have fully compatible mapping functionality so you can copy the data AND test the code even if you are renaming the objects or columns, moving objects between schemas, or even changing data types.