How to Automate a Simple Deploy Using DataDude (Visual Studio 2008 Database Edition)

Not sure why this was hard, but I wanted to make a trivial command file to deploy my database (or any change to it).  For those of you that don’t know the DataDude project, I have to say it’s one of the coolest tools that has come out the Microsoft Visual Studio Team for a while.  Basically, in a nutshell, what it does is split’s your database into hundreds of little files.  One for each table, key, foreign key, user, role, etc.  Then, since it is a standard VS2008 project, you can keep those files and the project under source control.  The big benefit is that multiple team members can change files and check them in, and everyone’s schema is kept up to date.

So, how does the up to date work?  the way it works is when you get the latest from your version control, you simply right click on the vs2008 project and say “Deploy”.

image

It’s kind of a hassle though because you have to open the project first, the don this.

Here is a simple one line cmd file that you can use to do this task for you.

C:\Windows\Microsoft.NET\Framework\v3.5\MSBuild.exe /t:Deploy 
  /p:Configuration="Debug";Platform="Any CPU" /v:normal /m 
  "data\ThreePLogicDatabase\ThreePLogicDatabase.dbproj"
pause

That’s it!  hope this helps.

About Peter Kellner

Peter is a software professional specializing in mobile and web technologies. He has also been a Microsoft MVP for the past 7 years. To read more about Peter Kellner and his experience click here. For information about how Peter Kellner might be able to help you with your project click here.

Follow me:


Comments

  1. Hi there I am so grateful I found your site, I really found you by accident, while I was browsing on Bing for something else, Anyhow I am here now and would just like to say thanks for a marvelous post and a all round thrilling blog (I also love the theme/design), I don

Trackbacks

  1. compare insurence cars rental deals amica com montreal quebec light truck says:

    compare insurence cars rental deals amica com montreal quebec light truck…

    sponges serene Shepard …

Your Comments

*

Protected with IP Blacklist CloudIP Blacklist Cloud

Follow

Get every new post delivered to your Inbox

Join other followers: