Dear Imar Sir,
I have completed the project and would like to host on the server.
I have taken hosting package also. My hosting package supports sql server but it should on .sql extension
I have control panel detail and there is feature of uploading .sql file.
Now the point of confusion for me is that I have generated .sqi file for Planetwrox.mdf. Is it necessary to generate separate .sql file for ASPNETDB.MDF also?
I use Filezilla to upload the files on server.
Have I to upload whole constituents files including ASPNETDB.MDF and Planetwrox.mdf File of App_Data Folder also?

There is commnad
<connectionstring>
<clear/>
Like that

From where I got user id and password.

Please guide me.

Hi there,

>> Is it necessary to generate separate .sql file for ASPNETDB.MDF also?

Yes, you need to script them using the Publishing Wizard as well, as explained in the book.

>> From where I got user id and password.

This is something your host should give you.

Once you have the databases in place, you need to update the LocalSqlServer connection string or reconfigure the membership provider as explained in Appendix B.

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!