Merging MS sql server (aspnetdb) tables, stored procedures etc.. with my own database?

I'm using asp.net default database created on website template (aspnetdb.mdf) and membership class for users. And for the additional information related to my website i'm using another database (mydata.mdf).

What i want to do is to combine these databases into one, and 开发者_JAVA百科to access them via one connection string. Since getting the data from mydata.mdf then selecting the user info from aspnetdb.mdf according to it is a pain.

What is the best way to achieve this, considering both databases have lots of stored procedures and FK relationships.

I've found some articles telling aspnet_regsql.exe is the way but couldn't find any tutorial and how to execute it?

Thanks in advance!

Yeah, you need to run aspnet_regsql.exe against your database to setup the tables and sprocs.

Its a wizard, so it does a good job guiding you through the process.

See the MSDN Documentation for more information. There's a chart near the bottom of the page that gives location of the file depending on the version of the framework that you are using.