Technical Overview

Let me give you an example to describe how SQL Simulator works. Lets say you had the following Insert Statement:

Insert into tableA values (1,’test’);

You want to test this SQL before you run it against production, but you only have blank/empty database. So you would need to do the following steps:

1. Get the DDL for tableA from production

2. Use that DDL in the blank database to recreate the table structure

3. Check to see if the primary key of 1 exists in production and if so copy that record to your blank database.

4. Execute your insert statement against the blank database

When you give SQL Simulator a SQL Script it automates the steps listed above. SQL Simulator has 3 main function. They are:

• Postview Merge

• Preview Merge

• Dry Run