CS Membership for the Membershipless

From time to time I find myself pulling down a live Community Server database for testing.  When the database also has a remote membership system it can be very time consuming to try to download and configure both a CS database and a Membership system and keeping those databases in sync.

I have created a SQL script which can create simple membership data for all the membership in a CS database.  You set the application name, and script allows you to specify the name of one user which will be added to the system administrator role.  It will create the asp.net membership tables and entries as necessary, it auto assigns all other users to the everyone role; and sets any user passwords to "password" (obviously this is just for local testing).

This script builds an ASP.NET 2.0 Membership system, for use by CS2007 and CS2008 databases.

Dan