Tonys Blog

All things .NET & SuperOffice DevNet...
posts - 19, comments - 6, trackbacks - 4

Create Membership Tables In Your Database

I came across kris' blog entry about installing the asp.net Membership tables in a database you define. This is not about creating the standard ASPNETDB database, but creating a sql script that installs the Membership tables, triggers, stored procedures, the whole lot, into a database you define! This is a great tip that certainly alleviates me from having to deploy a completely seperate database just to manange users information.

Essentially it breaks down to this line:

aspnet_regsql.exe -E -S localhost -d MyPersonalDatabase -A all -sqlexportonly c:\membership.sql

As most probably already know, aspnet_regsql.exe is found in (C:\Windows\Microsoft.NET\Framework\v2.0.50727\)

Kris has more about setting up the connection strings on his blog, so check it out at:

http://blog.krisvandermast.com/CreateMembershipTablesInAnotherDatabaseThanTheStandardAspnetdbmdf.aspx

Print | posted on Sunday, May 27, 2007 9:45 PM | Filed Under [ .NET Database ]

Feedback

Gravatar

# re: Create Membership Tables In Your Database

You can simply run aspnet_regsql.exe and wizard will appear that allows you to chose database and creates the tables there.
4/6/2008 2:36 PM | Wizard

Post Comment

Title  
Name  
Email
Url
Comment   
Please add 8 and 7 and type the answer here:

Powered by: