January 21, 2009 at 12:37 am
hi
i am developing a website which is having login form, i am using asp.net 2.o and sql server 2005 to develop this. I have created some roles and users using ASP.Net Configuration tool
this creates ASPNETDB.MDF but i am using using a remote database which is where i can create only one database which is normal sql server 2005 database, my question is can i copy this ASPNETDB.MDF to normal database so that i can use this. Please help me in this regard. Sorry if i did any mistakes in my English, because i ma poor in English.
Advance thanks
Srinvas
January 21, 2009 at 1:53 am
the best two options would be to either backup and restore (if you want to keep the database on the origional server as well) or detach and reattach if you want to move it to another server and work on it from there
BOL link to backup/restore ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/b93e9701-72a0-408e-958c-dc196872c040.htm
BOL link to detach and attach ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/6732a431-cdef-4f1e-9262-4ac3b77c275e.htm
John
January 22, 2009 at 8:05 am
I believe you can use the aspnet_regsql.exe utility to create a membership database or add the neccessary objects to an existing database.
Check out:
http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx - about 1/3 of the way down is a walk through of the wizard.
You can also review:
http://msdn.microsoft.com/en-us/library/ms998347.aspx#paght000022_usingthesqlmembershipprovider
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply