I'm just starting to leearn to use Visual Studio 2005 and am confused about the Configurastion Manager and the membership process. If you use the config manager to set up users and rolls it seems to add that data to the local database, How do you deploy that to the website. If I upload the changed database It seems it will overwrite any data that has been added by users of the website. Also, when I am finished creating the website. how does someone else administer the users and rolls f they don't have the Configuration manager? I'm sure this is a simple process but I just can't seem to figure it out. Thanks for any help!

 Ben

benmat:

If you use the config manager to set up users and rolls it seems to add that data to the local database, How do you deploy that to the website. If I upload the changed database It seems it will overwrite any data that has been added by users of the website.

Hi Ben,

Seems you are talking about Web Site Administration Tool. You want to know how to use Web Site Administration Tool to configure the database which has been deployed. For this issue, please refer to my reply in the following thread. Thanks.

ASPNETDB.MDF deployment issues?
http://forums.asp.net/t/1157733.aspx

In addition, about how to deploy database to the host machine, I recommend you to read the following article. Hope it is helpful to you.

Recipe: Deploying a SQL Database to a Remote Hosting Environment (Part 1)
http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx

Benson:

Thanks for the reply! Sorry for the delay in responding but for some reason my subscription notification by email didn't work.

I am working on the Club Website template which allows users to register to use the site. They can't, however, add a roll for their account. That is done by an administrator in the ASP.net Configuration interface. 

Visual Studio 2005 has an interfacce that writes to the web.config and to a database. One of its uses is to manage the rolls for the users. It is found under Website>ASP.net Configutation. In it you set up a user and define a roll for that user. When I publish the site to the server, my users can login based on the rolls I setup in the ASP.net Configuration. What I don't understand is how to use this ASP.net Configuration to add or adjust rolls after the initial psting of the site. If users are adding their names to the database all the time through the website, how does the ASP.net Configuration get those names on my local copy of the site and database so I can add the rolls to their accounts. How also do I make changes to my local database to add rolls to their accounts and then publish the changes back to the server. It seems that republishing my local copy of the database to the server would overwrite the server copy and delete any data that had been updated by a web user.

Can you help me understand this?

Thanks!

 Ben Mathews