SQL Simulator
  • Welcome
  • Getting Started
    • About SQL Simulator(beta)
    • Features
    • Benefits
    • Pricing
    • Platform List
    • Supported Databases
    • Technical Overview
      • PostView Merge
        • Step 1
        • Step 2
        • Step 3
        • Step 4
        • Step 5
      • PreView Merge
        • Step 1
        • Step 2
        • Step 3
        • Step 4
      • Dry Run
        • Step 1
        • Step 2
        • Step 3
        • Step 4
        • Step 5
        • Step 6
    • Self Destruct Events
    • K8s Install Guide
      • Azure Marketplace
      • Azure AKS
      • Google GKE
      • Amazon EKS
      • Other Cloud Provider
      • On Prem K8s
    • Limitations
    • Schedule Free Onboarding
  • Hello World Tutorials
    • SQL Server
      • Pod Setup
      • Database Setup
      • SQL Scripts
      • Add SQL Script
      • Datasource Config
      • Dry Run
      • Preview Merge
      • Postview Merge
    • Oracle
      • Pod Setup
      • Database Setup
      • SQL Scripts
      • Add SQL Script
      • Datasource Config
      • Dry Run
      • Preview Merge
      • Postview Merge
    • MySQL
      • Pod Setup
      • Database Setup
      • SQL Scripts
      • Add SQL Script
      • Datasource Config
      • Dry Run
      • Preview Merge
      • Postview Merge
    • Postgres
      • Pod Setup
      • Database Setup
      • SQL Scripts
      • Add SQL Script
      • Datasource Config
      • Dry Run
      • Preview Merge
      • Postview Merge
  • API Tutorials
    • Introduction
    • SQL Server
      • Windows Batch File
    • Oracle
      • Windows Batch File
    • MySQL
      • Windows Batch File
    • Postgres
      • Windows Batch File
  • Help
Powered by GitBook
On this page
  1. Getting Started

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

Last updated 11 months ago