Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / ASP.NET / General / June 2007

Tip: Looking for answers? Try searching our database.

Membership and Roles

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bbawa1@yahoo.com - 29 Jun 2007 22:47 GMT
Hi,

I am working on Membership and roles in Asp.net 2.0.  I am using
logincontrols in asp.net 2.0.  When I use these login controls it
automatically creates ASPNETDB.mdf database.  which has it's own
tables for membership.  But I can't move this database to live
server.  Over live server I have only one database TWSAN I just want
to copy tables from this database to TWSAN.  Is this possible.

Thanks,
David Wier - 29 Jun 2007 22:56 GMT
You could use DTS to send them, if your host allows it

Signature

David Wier
MVP/ASPInsider
http://aspnet101.com
http://iWritePro.com

> Hi,
>
[quoted text clipped - 6 lines]
>
> Thanks,
Roland Dick - 30 Jun 2007 03:12 GMT
bbawa1@yahoo.com schrieb:

> server.  Over live server I have only one database TWSAN I just want
> to copy tables from this database to TWSAN.  Is this possible.

It is possible, but you have to be careful which tables to copy first
because of the foreign key constraints.
It might be easier to copy your TWSAN database onto your development
machine, adapt web.config to make the membership controls use that
database, and copy the database back to the live server (unless there
are changes, e.g. inserts, made to the database in between, of course).

As for how to configure web.config to use something else than aspnet.mdf
for membership, have a look at
http://msdn2.microsoft.com/en-us/library/ms998317.aspx (or google for
aspnet_regsql membership asp.net). Especially important is the
<membership><providers> section. Aspnet_regsql is a tool that creates
the necessary tables in your database and comes with the framework.

Hope this helps,

Roland
sloan - 30 Jun 2007 18:23 GMT
That db is a just a default.

And you dont have to use the default.

Look up "membership provider" and "sql server 2000".

You don't have to use 2000, but it'll show you how to put your data into a
non default database.

There's even an Access implementation.

http://msdn.microsoft.com/vstudio/eula.aspx?id=96713a8e-b8d4-4d6e-bb8f-027e6c8e15d8

I'm not recommending Access, (unless its a super small site perhaps) BUT
again, shows you how to switch out to a non default db.

> Hi,
>
[quoted text clipped - 6 lines]
>
> Thanks,

Rate this thread:







Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.