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.
Here are some key features of "SQL Runner":
· Support for MySQL servers -- tested against MySQL 4.x and 5.x servers.
· Can store and manage multiple server connections
· Can store and manage multiple Script Sets
· Each Script Set can contain multiple Scripts
· Run scripts and tests individually or in batch modes
· Runs on Windows and Linux (possibly Mac OSX too, but not tested)
Requirements:
· Microsoft's .Net Framework 2.0 (or equivalent) installed.
· A MySQL server to connect to