Utility to apply SQL scripts to DB's and report results, and update log
$100-500 USD
Cerrado
Publicado hace casi 13 años
$100-500 USD
Pagado a la entrega
This is for SQL Server 2008
I have a n UpdateLog table that contains a record of every SQL script applied and whether it is successful or a failure.
This table gets updated automatically when i run my update script.
I need a utility (WinForms app) that will
* Compare the list of scripts to run, vs. those that are already run. (by comparing the script name and success/failure to those in the SQL Update log)
* Run the scripts one at a time, and report results back to user. (If it is not a success then the user may need to do some manual intervention before continuing the process)
## Deliverables
The program will have a config file that points to a "Application Master" DB via a connection string.
You will connect to the master application db, query a table to provide a list of all other DB's that are a part of my application on the same server, and provide them in a grid.
User will highlight one row on the grid (one db)
This will show a detail grid below the main grid showing the update history for this db.
Additionally, you will show another grid beside it which whill show all scripts available for this db and highlight the ones that have not been run.
User will select one or more scripts from the not-ran list, and click GO to apply the scripts.
You will run the scripts in ORDER of oldest to newest.
After each script is run you display the RESULTS (Success or a failure with details, (whatever SQL server provides)
The user will interpret the results of the SQL response, and click one of two buttons: "Continue to next script" (if there are any more to run), or "Stop"
If the user determines there is an error, he will click STOP and you will close both grids, and the user will manually fix anything he needs to do, and start the process over.
I can provide a sample screenshot if you feel you need it.