Show HN: SQL Dry Runs with SQL Simulator https://ift.tt/a6devHL

Ads by Eonads

Show HN: SQL Dry Runs with SQL Simulator My name is Weston Goodwin. I created a tool called SQL Simulator which allows you to do Dry Runs with your SQL Scripts. The reason I created the tool was because I wanted to verify that my SQL scripts did what I thought they would do without executing them against the database. 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: https://ift.tt/0IOVXAJ... You can download the software here: https://ift.tt/cU65yDd You can read the documentation here: https://ift.tt/0IOVXAJ... https://ift.tt/iRAEnqZ June 4, 2023 at 11:03PM