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  eploy /ConnectionString:"Data Source=10.8.x.xsql2008;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  Thanks to Visual Studio Database Edition.

alk.

Tags: Visual Studio Database Edition

Tags: VSDBEdition