Creating a Database Checkpoint in QTP

To create a database CHECKPOINT in a Test:

1. Identify the checks that you want to use to verify data in a database.
2. Identify the step in a test after which you want to insert the database checkpoint.
3. Create an SQL query to retrieve data from the database.
4. Specify the expected data.
5. Run the test to verify the database checkpoint.

Common Database Checks: You can define database Checkpoints in a test to check if:

• The data is saved to the correct tables and columns of the database.
• The data is updated in the database when a record is inserted, updated, or deleted in the aut. This process is also known as data persistence.
• The data entered using the AUT is represented correctly in the database. Some of the properties that you check for are data type, format, length, and spacing.
• The data entered into the database is not duplicate.

Related posts:

1. Inserting a Database Checkpoint in QTP
2. Understanding Standard Checkpoint in QTP
3. What is Database Checkpoints in QTP & How it Works?
4. Renaming a Checkpoint
5. Parameterizing a Checkpoint