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

PreviousSupported DatabasesNextPostView Merge