in Visual Studio (2010), I go to File > New Website > ASP.Net Web Site, I view 'Default.aspx' in browser, I register as a new member, this creates ASPNETDB_TMP.MDF in the app data folder (and aspnetdb_log.ldf
), and ASPNETDB.MDF in 'Data connections' in the server explorer plus associated folders such as 'Tables' etc.
I've now created a membership site with database, which I can run on my pc.
How do I get that onto my hosting package? I've got sqldb publishing wizard, and sql management studio installed, but I cannot work out how to get it to my hosting, I use websitepanel on an MS platform.
And note to change the Membership's connection string after you publish to remote server.
Best Regards,
Jean
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
None
0 Points
5 Posts
Publishing Visual Studio Membership website and DB
Oct 12, 2017 12:25 PM|Marodo2712|LINK
<div>Hi
in Visual Studio (2010), I go to File > New Website > ASP.Net Web Site, I view 'Default.aspx' in browser, I register as a new member, this creates ASPNETDB_TMP.MDF in the app data folder (and aspnetdb_log.ldf ), and ASPNETDB.MDF in 'Data connections' in the server explorer plus associated folders such as 'Tables' etc.
I've now created a membership site with database, which I can run on my pc.
How do I get that onto my hosting package? I've got sqldb publishing wizard, and sql management studio installed, but I cannot work out how to get it to my hosting, I use websitepanel on an MS platform.
Thanks
</div>Contributor
6460 Points
2525 Posts
Re: Publishing Visual Studio Membership website and DB
Oct 13, 2017 02:20 AM|Jean Sun|LINK
Hi Marodo2712,
Do you mean that you want to publish the ASPNETDB_TMP.MDF to the remote SQL Server? If so, please try the following link.
https://weblogs.asp.net/nannettethacker/deploying-the-aspnetdb-mdf-to-a-production-server
And note to change the Membership's connection string after you publish to remote server.
Best Regards,
Jean
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.