Can i include SQL SERVER database in app_data folder on production with SQL SERVER Entertprise edition

Question

User-775697465 posted

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?

Answer 1

User2108829372 posted

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"
    providerName="System.Data.SqlClient" />

Answer 2

User311508580 posted

Hi maliksh,

Could you please explain a bit more?

Answer 3

User-775697465 posted

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??

Answer 4

User2108829372 posted

have you tried the changing the connection string ( mentioned in the above post) ?

Answer 5

User-166373564 posted

Hi maliksh

maliksh

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,

With regards