Visual Studio 2010 database deployment -


My Visual Studio 2010 solution includes a database project and a setup project, the easiest to create this database created by the I setup project. What's the way I was hoping that this would be quite easy to add database project output to the setup package and it would work magically, but it does not seem that it is easy.

Let me know if you have more information. Thanks!

You can create a script to attach to the database.

to

  USE Master; Turn on Database MyDatabase (FILENAME = 'C: \ MyDatabase.mdf'), (FILENAME = 'C: \ MyDatabase.ldf') for ATTACH; Geo  

All you need to do is establish a connection with the SQL server, make sure the files are in the right place, and then execute the SQL.


Comments