Moving the aspnetdb.mdf Database to a Production SQL Server

Amgad Suliman | 17/12/2008 | 2 Comments | 674 Visits

One of the least documented features in ASP.NET is the way to move the user access and profiles tables in aspnetdb.mdf to a production SQL Server. Although aspnetdb.mdf can be used in production, it is not recommended. This is done in 2 steps, first create the structure (tables, views and stored procedures) in the database, and second point the connection strings in the solution to that database.

The structure should be created automatically, to do so open the command line by opening the Run dialog box and enter cmd. Then change to the directory C:\Windows\Microsoft.NET\Framework\v2.0.50727. Note that the last directory’s name may be different, just make sure it’s v2.0, which signifies version 2.0 of the .NET Framework. In this directory run the executable called aspnet_regsql.exe. When run without arguments a wizard will start. Although I never had trouble with this tool before, I would still advice to backup the database before continuing the wizard, if its not empty. The following screens show the input pages of the wizard:

 

The Welcome Screen of aspnet_regsql

Select the Action to Perform

Select the Database

To let the solution use the database for user access and profiles, a hidden connection string called LocalSqlServer has to be removed and added again with the new settings. The following code example does that.

    

                

        
        
        
        
        
    

 

  • Share/Bookmark
Filed Under: ASP.NET
Do you have an article you think webmasters might find useful? Send it to us.

Comments

  1. joyce says:

    Hi
    I ran the wizard as as given in this page, but it created an empty database, instead of copying my existing database.
    How do i copy my database to serever?

    Thanks
    Joyce

  2. Hi Joyce, the wizard creates the structure (tables, views and stored procedures) needed to use the database for ASP.NET memberships. There are 3 ways you could copy the database. You could copy the database’s mdf and ldf files to the new location and attach it using SQL Server Management Studio, backup the database and restore it in the new location, or generate the SQL statements needed to create the structure and run it in the new location.

Leave a Reply