SQL database

Hello,

I'm using the standard database that is created with a createuserwizard (aspnetdb.mdf) from Visual Web Developer 2008 Express Edition. Is this database supported by discountasp.net or do I have to purchase SQL Server?
If it is supported, what's the best way to upload the database and what option do I choose from discountasp.net regarding the database type?
Thank you.

 

So you're saying I can develop the database to work when I'm previewing the site on my computer, but in order to upload the database (and therefore, the membership qualities) I need the SQL add-on?
If I'm right with this assumption, how do I go about getting the SQL add-on?
Also, since my database is already implemented, do I have to re-do it, or does the add-on just make it able to work on a live site?

 

Hi,
It would work like this:

1. Create your site locally with the data driven parts using SQL Express.
2. Login to your DASP Control Panel and add either SQL Server 2005 or SQL Server 2008.
3. Once your DASP SQL Server addon has been provisioned look in the DB section of your Control Panel.
4. There you will find the connection string for your new DASP SQL Server addon.
5. Once you have that make the changes to your remote web.config
   If you have trouble we can help you here in the forums.
6. Back in your Control Panel look in the DB section for the Attach feature.
   Upload your Express DB to a folder on your site then use the Attach feature to load everything.
   Your SQL Server addon is not on the same box as your site but your records/objects will get loaded.
   When you do this it only works once,
   Make a backup of your DASP DB first. That's another feature in the CP DB section.
   Once your Express DB is loaded you can make changes to your data as needed.
   If however you load another Express DB it will wipe out your additions/changes. Thus the backups.

Salute,
Mark