Tests

SQL Tran uses its static analysis of the source database to build extensive tests for all the code objects, automatically. Take a look at the testing workflow to learn more.

One can find tests right in the Workspace, in a side-panel of an object. The other, dedicated screen for tests can be accessed from the side navigation.

Objects SQL Tran can generate tests for:

• Tables

• Views

• Procedures

• Functions

Important: Do not use production databases as staging databases. Testing process writes to the tables.

Seeding data

You can opt to use your existing staging databases for source and targets. They can include sensitive data as SQL Tran is deployed in the user's tenant so you have full control of the access.