I have downloaded the site and updated the code to fit my requirements. i have developed using VWD 2005 and SQl Express Edition 2005. Now i need to host the site. I got on idea stating that from "local computer - > server" i have to use "copy website". this is fine. now what abt the database. do i have to load it separately or how should i do ? Any ideas...
Hi, I've created a few Webcasts on how to get the Express DB's onto DASP servers: http://www.dasptv.com/ Basic steps are to addon a DASP SQL Server to your account then use the Attach feature in the Control Panel for your account. All the best, Mark
database i need to know if i can use sqlexpress edition database to store the details. is it free or do i have to pay for it.
You would use a SQL 2005 or 2008 database and attach your local SQL Express database to that. We don't support SQL Express (Microsoft says that shared hosts should not support SQL Express). Yes, you will have to pay for the SQL add-on. I'm afraid there's no way around that. Well, there is one way around paying for a db add-on, and that is to use Access, but we don't recommend that. Access was not designed for web use. When Access is put to any kind of moderate use it generally responds by pulling its head back into its shell and shutting down. Not cool. It was really made for one person to use at a time, on their own computer, or a small local network.
ok. i can pay for the sql db. now i have used aspnetmdb for membership activites and another db for the application. now i have register for another again for aspnetmdb or use aspnet_ressql to add to tables into the main db. Please help if any problems if i do like this.
This will all depend on what you are trying to accomplish how your application works and what's your budget. Technically everything can run under one database, but you run into potential conflicts (such as identical objects and/or tables) and it performance issues. Generally speaking you should run your ASP.Net membership roles provider off its own database. Using the aspnet_ressql command is the best way to create the schema for your roles and membership, but if you build your membership/roles form application locally you can use the SQL management tool inside your control panel to upload the aspnetmdb database to our server. This should have the roles/membership schema if you created the forms application locally. Remember to update the connection string to point to our SQL server once you uploaded it over.
to have aspnetdb database in the discountasp server do we have to pay for it ?If we have to pay for it budget would be a problem. To reduce cost i can add the table and scripts to the existing database as this appliacation is intended to use for learning purpose and got no commerical use. Any ideas.. .
Uploading the aspnetdb is free of charge. What you are simply doing is uploading it to the SQL addon you already have. You can use the SQL Management Tool inside your control panel to do this. Bear in mind, attaching or restoring the aspnetdb to our SQL server will over ride the data and objects you already have on our SQL server.
