Click here to Skip to main content
Click here to Skip to main content

SQL Deployment Tool for Multiple Databases

, 13 Nov 2010 CPOL
Rate this:
Please Sign up or sign in to vote.
Executes SQL scripts in multiple databases at once.


Don’t you feel annoyed if you want run the same scripts in multiple databases over and over. I had the same situation at my work. So I made a small tool in WPF using MVVM architecture. I hope this may be helpful to you.



I have a situation whenever I make changes or develop stored procedures I have to run in couple of databases. Sometimes I forget to run in a few databases that cause an application error. So I decided to write an application to do this laborious job.


Using the Code

This tool is very light, the reason I called very light because I am not loading servers and databases information from the network. I feel it is overhead and shows more than you wanted. This tool reads this information from ServerConfig.xml file, you can add only information (Servers and Databases) you want to use in the XML file.

**This File must be located in application folder (Ex: bin/Debug or bin/Release)


All you need to configure is the DisplayText and Tag in the XML, you can disregard the rest of the stuff.

DisplayText – The text you see in the user interface, for example, server name in the server dropdown.
Tag – Actual name of the server/database

If you configure your settings in XML file, you are ready to use the application. The following picture shows the sequence of steps to how to use this tool.


Here are the steps again:

  1. Select authentication (Windows or SQL authentication), if it is SQL authentication enter valid user name and password.
  2. Select databases where you want to run your scripts.
  3. Select a script file if you have script already in the file, or you can type in your SQL script in the text area. If you have multiple SQL statements, each statement must end with a semicolon or enclose each statement between BEGIN and END to execute everything at once. Otherwise you will have to select each SQL statement at a time to execute.
  4. Click execute button to run the SQL statements
  5. You can see success or failure messages in the bottom of the application.
  6. Click clear to clear text area.

Points of Interest

I wanted to write a small useful application using WPF and MVVM.



10/25/10 Initial release


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Software Developer (Senior)
United States United States
No Biography provided

Comments and Discussions

GeneralThis is exactly what I was looking for... In one of my work... Pinmemberhfeiges31-Aug-11 7:27 
This is exactly what I was looking for... In one of my work environments we have servers with multiple copies of the same database for a CRM application, and this will allow me to deploy reporting solutions to all of the databases in one shot...
.... In another work environment, however, I have sort of the same issue but this time instead of multiple databases in a single SQL instance, we have the same database in multiple SQL instances.... Same issue but this time partitioned along SQL instances rather than SQL databases... Is it possible to optionally "reverse" the database/server schema in the tool, so now you can target multiple servers as opposed to multiple databases?? Then this would work in either environment...
GeneralRe: That is a good idea, unfortunately this tool doesn't support... PinmemberSrinivas-Miriyala31-Aug-11 7:53 
GeneralThanks for your vote and advice but it is possible to execut... PinmemberSrinivas-Miriyala4-Nov-10 6:59 
GeneralReason for my vote of 3 comment already added Pinmembersirama20042-Nov-10 2:55 
GeneralWhat is the advantage if it does not allow executing mutiple... Pinmembersirama20042-Nov-10 2:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.150326.1 | Last Updated 13 Nov 2010
Article Copyright 2010 by Srinivas-Miriyala
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid