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:

Get the DDL for tableA from production
Use that DDL in the blank database to recreate the table structure
Check to see if the primary key of 1 exists in production and if so copy that record to your blank database.
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:

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:

Get the DDL for tableA from production
Use that DDL in the blank database to recreate the table structure
Check to see if the primary key of 1 exists in production and if so copy that record to your blank database.
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: