Project Description
Utility to run multiple scripts in a specified order against a database. It's developed in VB.net.

This project was born out of the necessity to run a set of scripts in a particular order. Given all of the foriegn key constraints in our database, data had to be deleted in the right order, tables had to be dropped in the right order, then the scripts had to be run in the correct order. Remembering the correct order was impossible, and following a written script proved unwieldly. It ended up being much easier to write this utility to run the scripts in order.

This utility supports both running scripts from files as well as user provided scripts that are saved in the script project.

The data for a script project is stored in an xml file.

Technologies Used
  • WPF for the user interface
  • The WCF Data Contract serializer is used to create / read the xml files
  • The code is written using VB.net

Goals
  • Add support for Oracle (the database provider is implemented as an interface, but only SQL Server is supported at this time).
  • Implement the console interface

Last edited Dec 1, 2008 at 11:19 PM by fowlcoder, version 5