Shimmy Weitzhandler
Reputation: 104692
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.
Upvotes: 7
Views: 4079
Answers (1)
RC_Cleland
Reputation: 2294
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.
Upvotes: 0
Related Questions
- How do I connect to an MDF database file?
- View data of .mdf file within visual studio
- What to use to open an .mdf (SQL Database) file
- Loading .mdf/.mdv file into SQL Server Management Studio
- sql server mdf file database attachment
- How to open the mdf file
- Run SQL script on MDF file in App_Data
- Use .MDF file in c#
- .mdf file opening problem
- Error opening .mdf file through SQL Server Management Studio Express