What makes a poor programmer happy

I must create a duplicate of a database in another server, I need to duplicate only the structure of actual production database to use with a test web application to check how the webapp works with an empty database. I simply fired a command prompt, went to output directory of my database project, and typed

vsdbcmd /a:Deploy /ConnectionString:"Data Source=10.8.x.x\sql2008;user=sa;pwd=xxxxxxxx" /dsp:SQL /manifest:MyProject.deploymanifest /p:TargetDatabase=MyProjectEmptyDb

And after a couple of minutes the empty db is ready, with its 9 physical files, 5 filegroups, all the indexes, all fulltext defined etc etc  :D Thanks to Visual Studio Database Edition.


Tags: Visual Studio Database Edition