sql-server-2008visual-studio-2010ssmsmdf

Open mdf file that resides in App_Data with SQL Server Management Studio?


Is there a one-click way to open an mdf file that resides in the App_Data of the current editing project in Visual Studio 2010 with SQL Server Mangement Studio 2008 R2?

UPDATE:

I am also looking for the opposite way, where I want to execute a generated SQL script to a database that resides as an mdf file in the local App_Data folder.


Solution

  • No there is not a one click way as SQL Server does not allow mdf to be shared when it is attached to the SQL Engine.