Last post Aug 16, 2008 07:44 PM by jeremyh
Aug 16, 2008 05:05 PM|aftab|LINK
I am deploying my web application and just couple of questions but let me set the stage for you:
I have 2 databases now for my website:
Database 1 is the ASPNETDB.MDF (inside the App_Data folder) this has the roles and membership details etc.
Database 2 is the AbcDB.mdf (it has my tables, stored procedures etc) and it is located in 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data' and
NOT in the root of my web application folder or under App_Data folder of my web application.
And now the thing is, to upload it to the web site, the database has to be under the App_data folder or in the root of web application.
Do I have to physically move my database AbcDB.mdf to the web application root folder or App_Data folder of the web application?
How can I get AbcDB.mdf database to go under App_Data folder (which already has the ASPNETDB.MDF)
I want to upload my AbcDB.mdf, how can do it? Please help
I am little confused here.
Aug 16, 2008 07:44 PM|jeremyh|LINK
Most hosts dont allow you to host sql express database in App_data you have to upload the database to their sql server, So I would check with you host first
most have details in their support pages or control panel pages.
This show you the steps need
Also you will need to define the membership in your web.config and set an applicationname, take a read of
You will also need to make sure the connectionstring are updated in your web.config to your new database locations.
This covers some more detail about deploying sql express database
Hope it helps