TRIBAL KNOWLEDGE - When you need it right the 1st time
  • Home
  • About
    • Privacy Policy
    • Terms and Conditions
  • Government Services
  • Products
    • SQL Simulator(beta) >
      • Docker >
        • Benefits
        • Features
        • Install Guide
      • Kubernetes >
        • Benefits
        • Features
        • Install Guide
      • FAQ
  • Pricing
    • SQL Simulator Docker
    • SQL Simulator Kubernetes
  • Resources
    • Blog
    • Newsletter
  • Contact Us
    • Support
    • Schedule Free Onboarding

Top 6 questions about performing a SQL Dry Run with SQL Simulator

6/1/2023

3 Comments

 
Picture

What is a dry run?

According to chat gpt a dry run :

"Refers to a rehearsal or practice session conducted in a simulated or controlled environment to test the execution of a process, system, or event without actually implementing it in its full operational capacity. It involves going through the motions and steps of a particular activity, such as a presentation, procedure, or software implementation, to identify potential issues, assess readiness, and familiarize participants with the expected workflow. Dry runs are typically employed to uncover and rectify any flaws, ambiguities, or inefficiencies before the actual implementation or live performance takes place, allowing for adjustments and improvements to be made, thereby enhancing the overall outcome and reducing the likelihood of errors or disruptions."

What is the purpose of a SQL Dry Run?

To verify if your SQL scripts will execute and that those SQL scripts are doing what you think they will do.

So what is a SQL Simulator?

SQL Simulator makes performing dry runs easy with just the click of a button.

What is needed to setup and run the software?

The setup process can take as little as 5 minutes.  Here is what you need
  1. Download the software
  2. Unzip the software(There is no installer)
  3. Create a blank/empty schema in a non production database
  4. Configure data sources
A "hello world" tutorial can be found by clicking here

How does SQL Simulator work?

It is similar in concept to Redgate SQL Clone or Windocs.  If you are not familiar with these tools they make clones of your database.  The key difference with SQL Simulator is, it only makes a clone of the database objects affected by your sql script not the entire database.  Nor does it copy the entire table (if your sql has  where clauses).  Once those database objects have been cloned, SQL Simulator then executes your script against the cloned database it created.

For a more in-depth technical overview click here

Can I see a demo?

Here you go
3 Comments
tel -U link
12/20/2023 08:29:58 pm

<p>Are there any visual elements such as charts, graphs, or images in the article? How do they enhance the content?
<a href="https://telkomuniversity.ac.id/" target="_blank" rel="noopener noreferrer">Telkom</a>!</p>

Reply
Weston O.G. link
12/21/2023 11:03:05 am

I don't understand the question you are asking. Can you rephrase it?

Reply
Karen link
1/28/2025 10:02:36 am

Thanks for this blog posst

Reply



Leave a Reply.

    Tribal Knowledge

    Archives

    May 2024
    April 2024
    December 2023
    June 2023

    Categories

    All

    RSS Feed

Copyright 2021 GoodTech, LLC. All rights reserved. PO Box 381, Powhatan, VA 23139
Privacy Policy
Terms and Conditions
  • Home
  • About
    • Privacy Policy
    • Terms and Conditions
  • Government Services
  • Products
    • SQL Simulator(beta) >
      • Docker >
        • Benefits
        • Features
        • Install Guide
      • Kubernetes >
        • Benefits
        • Features
        • Install Guide
      • FAQ
  • Pricing
    • SQL Simulator Docker
    • SQL Simulator Kubernetes
  • Resources
    • Blog
    • Newsletter
  • Contact Us
    • Support
    • Schedule Free Onboarding