d-man
Reputation: 58083
Asp.net app_data connect db
I am having sql server express edition local database in app_data folder.
How can i connect SQL Server Management Studio Expres with that db to execute sql scripts ?
Upvotes: 0
Views: 1352
Answers (2)
thitemple
Reputation: 6059
In Management Studio, right click databases, attach database and point to your mdf file.
Upvotes: 1
Dave Swersky
Reputation: 34810
If it's an MDF file, SQL Management Studio can't open it.
This article might help: http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx
Upvotes: 0
Related Questions
- ASP.net Database connection to remote SQL server DB not in 'App_Data'
- using App_Data in connection string
- Getting data from a table to ASP.NET web application
- Connection code to the database in asp.net
- ASP.NET Database Connect
- Not able to connect to the SQL Server data from asp.net app
- System.Data.Sqlconnection
- SQL Server 2005 and APP_DATA
- Guidance needed ASP.Net app connection string
- How do I refer to APP_Data from another project