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

SQL Deployment Tool for Multiple Databases

By , 13 Nov 2010
Rate this:
Please Sign up or sign in to vote.

Introduction

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.

 

Background

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)

EasyDeploy_config.JPG

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.

SQL_Deploy.JPG

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.

 

History

10/25/10 Initial release

License

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

About the Author

Srinivas-Miriyala
Software Developer (Senior)
United States United States
No Biography provided

Comments and Discussions

 
GeneralThanks for your vote and advice but it is possible to execut... PinmemberSrinivas-Miriyala4-Nov-10 5:59 

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 | Mobile
Web02 | 2.8.140415.2 | Last Updated 13 Nov 2010
Article Copyright 2010 by Srinivas-Miriyala
Everything else Copyright © CodeProject, 1999-2014
Terms of Use
Layout: fixed | fluid