Last post May 15, 2013 05:29 AM by Angie xu - MSFT
May 09, 2013 12:45 PM|maliksh|LINK
Can i include SQL SERVER database in app_data folder on production server with SQL SERVER enterprize edition.
all the time i uploaded sql server database into hosting sql sever database , can i include the database file .mdf inside app_data folder
Des it will work normally or only this work with sql server express edition?
May 09, 2013 01:07 PM|sangeeth2007|LINK
i am not clear on the question you asked . are you asking if we can change the connection string of attachdb, if so change "
"SQL-FULLVERSION\SQL2008" in the connection string below to the connection string of your production database
<add name="connectionstring" connectionString="Data Source=SQL-FULLVERSION\SQL2008;AttachDbFilename=|DataDirectory|Data.mdf;Integrated Security=True;User Instance=True"
May 09, 2013 10:12 PM|dotnetnerd|LINK
Could you please explain a bit more?
May 10, 2013 07:08 AM|maliksh|LINK
I mean that attach database inside app_date folder is only work with SQL Server express , what if there was SQL Server enterprise edition installed on the hosting server does it will work if i attached database inside app_data??
May 10, 2013 10:58 AM|sangeeth2007|LINK
have you tried the changing the connection string ( mentioned in the above post) ?
May 15, 2013 05:29 AM|Angie xu - MSFT|LINK
what if there was SQL Server enterprise edition installed on the hosting server does it will work if i attached database inside app_data??
If you want to work with attached database inside app_data in SQL SERVER enterprize edition, you should change your connection string first,