SQL Runner

The SQL Runner applas designed to be a small utility that lets you store and run SQL scripts against MySQL servers. This program lets you build Script Sets that contain as many SQL scripts as you want.

Each script consists of a test (for determining if the fix is required), a fix (for updating the SQL data), and notes that you can use to store any additional information about the script. Script Sets are stored as XML files, and thus are quite easy to back up, share, and store in version controlled folders.

First thing you need to do is configure your SQL server(s) in the server editor. Then you make a Script Set by adding script entries to the list in the center of the application. Adding and editing these scripts takes you to the Script Editor screen, where you have three tabs to fill out.   The first is the SQL you need to run to test to see if the fix is already present on the server. The second is the SQL that needs to be run to fix the issue. The final tab is a place for you to enter any notes about the script that you want to keep.