Database Upload Stage

Thanks for your help
I do not currently have a \App_Data\ folder, should I create this under the route of my site (I do have a _database folder)

 

You don't need an App_Data folder but if you use VS it will create one for you.
Just right-click on your site root in VS and use the Add Folder feature.

Yes you can use the DASP _database folder for this.
Salute,
Mark

 

I am currently using SQL Server Management Studio Express. The database is poplated with data and I now wish to get it online so my site can access it.

I have read throught the other posts and it seems like there are a few options for getting my database online. It seems the simplest is to upload and then attach my database.

I believe the following steps should work:

Step One - Purchase Add On

Add New MS SQL 2005 Database*
SQL Space: 300mb
Database Name: SQL2005_290796_ (I assume the name of my database must be the same as what I named it in SQL Server?)

Step Two- FTP Database

I assume I simply FTP the database files (MDF and LDF) Into a Database Folder in the same way as I do my other files.

Step Three - Attach Database

I am not sure how/where I do this?

Step 4 - Upload webconfig

Upload a new webconfig file with the correct connection string, I currently have this set to my local settings (with security set as integrated, what should this be changed to?)

Thanks
Regards
Confused Newbie!

 

Hi,
I really wish this was easier for everyone and yes we are trying to make it easier but to be honest...
The Express SQL DBs do confuse matters.

The name of your SQL Server 2005 addon does not need to match your current code.
You'll be specifying the new name in your updated connection string.

You should FTP your Express DB, for Attaching, to the \App_Data\ folder.
i.e. \App_Data\aspnetdb.mdf

Those features and options are in the SQL Tool Suite tab in your SQL Server 2005 control panel area.

Your web.config connection strings section will need to be updated with the info you'll find in your Control Panel.
Refer to some of my previous post in this section or ask me to code your conn string for you when it's time. No prob.

If you get stuck I'm willing to do this for you.
Salute,
Mark