I was working back through the section in your book on Security, specifically using forms authentication part as a refresher and I have gotten stuck on the concept of the fact that when you use a web site administration tool to create roles and users you end up creating a separate User Instance Database, that is detached from the main database as WSAT tool automatically creates a App.Data folder with an ASPNETDB.mdf file in it in your project explorer. I currently have an application that uses two databases one for the production information and the other for the ASPNETDB.mdf security database. Now the application has to work with two separate databases. Is that a wise choice for a production application? If not then how do you meld the User Instance Database instance with the main database that sits somewhere else outside of the App.Data folder of your web site? Did I miss a step here? Do you need to do this before you deploy to your production server? Can you DTS in SQL Server to meld the two together?

Thanks
:-)

If you want to merge existing database, DTS (or SSIS nowadays) is indeed to merge the data. Alternatively, you can use the publishing wizard to export the data.

The last few pages of Appendix B show you how to reconfigure the application to make use of the merged database.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!