I use the Database Publishing Tool a lot. For some reason the version in Visual Studio didn’t work as well for me, so I have stuck with the free standing version of it. Not sure if there is a version that works with Sql Server 2008 yet, but this one works well for 2000 and 2005.

The problem you may encounter, as I do, is that the resultant script is waaaaaay to large to load into the Sql Server Management Studio. So, once you script out the database, then you can use sqlcmd.exe to run the resultant script on an existing database.

Your command line will look something like this:

C:\>sqlcmd -S YOUR_SQL_SERVER -U USER -P PASSWORD -d DATABASE -i "the_scriptpath"

And here it is in action:

sqlcmd 

music note While writing this, I was listening to "Ancodia" by 808 State

DotNetKicks Image