Visual Studio 2008 has this nifty tool for scripting databases. If you have an existing data connection in your Server Explorer, you can right-click on a database, select “Publish to Provider”, and voila, you have your entire database scripted to a file. Now, you may think “Hey, I can run this on another server, and […]

It’s remarkably unintuitive how to install a database through Visual Studio 2008. Nevertheless, it CAN be done! Solutions such as RedGate’s SQL Packager are great, but expensive. I needed a quick, free solution. As luck would have it, one of my favorite resources, CodeProject, had just the thing. Thanks to Stan Prodan for his article […]