On Wed, 20 Dec 2006 11:50:55 -0500, dgk <dgk@somewhere.com> wrote:

>I've been developing an ASP.NET app using the default user and profile
>provider, which is SQLExpress. But to go live we are going to use
>SQLServer2005. I know I can use the ASPNET_REQSQL tool to prime
>SQL2005, which apparently just creates an ASPNETDB.MDF file. However,
>since I already have a local ASPNETDB.MDF file which has all the user
>data already entered, I'd rather just use that.
>
>But when I move it to the appropriate location on the drive (under the
>MSSQL/Data directory) and try to attach it, it keeps wanting to use
>the one back in the development directory.
>
>How can I tell it to use the one in the Data directory for now on? Or
>am I approaching this wrong? Should I just use the tool to create the
>new database and somehow import the data from the old database?