By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,763 Members | 1,641 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,763 IT Pros & Developers. It's quick & easy.

Membership and Roles

P: n/a
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,

Jun 29 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
You could use DTS to send them, if your host allows it

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

<bb****@yahoo.comwrote in message
news:11**********************@o11g2000prd.googlegr oups.com...
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,

Jun 29 '07 #2

P: n/a
bb****@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><providerssection. Aspnet_regsql is a tool that creates
the necessary tables in your database and comes with the framework.

Hope this helps,

Roland
Jun 30 '07 #3

P: n/a
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/eu...f-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.


<bb****@yahoo.comwrote in message
news:11**********************@o11g2000prd.googlegr oups.com...
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,

Jun 30 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.