Re: Need to load 200 users into Form security DB

Tech-Archive recommends: Fix windows errors by optimizing your registry


Ok, that makes more sense.

You have 2 choices.

Create your own custom membership provider. Which is not super trivial.
OR
You have to jam your information to the default/existing MembershipProvider.

Here is a "hint" blog entry.

http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!160.entry

My situation is that I had a development database with some users/roles in
it. And then I had to move them to production.

But I think you can learn how to manually create your own TSQL to have your
own versions.

INSERT INTO dbo.aspnet_Users
INSERT INTO dbo.aspnet_UsersInRoles
INSERT INTO dbo.aspnet_Membership

Aka, follow my blog entry up to the point of the above.
Then you'll create your own INSERT statements...using data from your source.

You're basically writing to to write code (tsql in this case).




"randy.buchholz" <randy.buchholz@xxxxxxxxxxxxxxxx> wrote in message
news:%239WfmRcnJHA.1216@xxxxxxxxxxxxxxxxxxxxxxx
I believe so. I'm not really familiar with the specifics of the security
modules yet; this is my start. I ran the script that creates a security
database in SQL2008 with 11 tables, Membership being one. Also Users,
Roles, Profiles. The only thing I have done for security so far is to use
the little web app (ASP.Net Configuration) that has a security tab,
Application Tab, and Provider Tab. My provider is AspNetSqlProvider. In
the config.net I point localserver to the security database
<add name="LocalSqlServer" connectionString="Data Source=ET;Initial
Catalog=ASPSecurity;Integrated Security=True"
I have only had a handfull of users thus far so I was managing them from
the security tab on ASP.Net Configuration. With 200 new users that
approach would take forever. I have the users in a spread*** and need
to get them into the Membershp (?) database. Thanks.

"sloan" <sloan@xxxxxxxxx> wrote in message
news:uiQgK5bnJHA.6060@xxxxxxxxxxxxxxxxxxxxxxx

Are you using the MembershipProvider?

I'm having trouble following your question a little.



"randy.buchholz" <randy.buchholz@xxxxxxxxxxxxxxxx> wrote in message
news:OzUyCkbnJHA.500@xxxxxxxxxxxxxxxxxxxxxxx
Hi All,
I have an application that is using Form security and a SQL Server 2008
security db. I have a list of users that I need to get into the system.
I have not been able to find a way to generate the UserID or
ApplicationId in the user table to enable a direct load. The names are
used/come from other systems so I need them to be exact matches. (I
don't want to trust the users to enter them themselves.) If I can't
find a way to do a direct load I thought about exposing a grid view next
to the New User control and populating the user name (read only) when a
name is selected. I haven't seen a way to get to the user name field
though. Last resort would be writing my own (or finding) another Create
User control. I would really like to find a way to load directly. Or
next, populate the name field in the standard New User control.
TIA







.

Quantcast