Friday, July 04, 2008

What is the ASPNETDB for?

Registering the aspnet database

  1. Open a Visual Studio Command Prompt
  2. Type aspnet_regsql and press [Enter]
  3. Follow the steps in the wizard

Here's a simple guide to the aspnet_regsql command:
syntax: aspnet_regsql

:

  • Use -S to install to the aspnetdb on the server specified by
  • Use -sqlexportonly to generate a sql script
  • Add -E to log in to SQL using windows authentication, or -U -P to use a specific login and password.

:

  • * -A with one of the following: all, m, r, p, c, w
  • all: add all features
  • m: membership
  • r: roles
  • p: profiles
  • c: personalization (web parts)
  • w: web events
  • -ssadd -sstype and one of the following (for session-state persistence):
  • p: creates the ASPState database
  • c -d : creates ASPState tables in the specified

No comments: