I have created a web site (with help from Professional ASP.NET 4 in C# and VB) and it works fine on my local machine. When I tried to deploy to the server at my hosting company I ran into problems. It appears that VS defaults to creating the Provider databases in SqlExpress. When I tried to deploy, I got errors saying that SqlExpress wasn't installed on the server. How do I tell VS that it needs to use SQL 2008 in release, but SqlExpress in debug for the Provider databases?

I have the same question so looking forward to the answer

Hi there,

You'll need to update your web.config and have your connection strings on the server point to a different database serve.

You can use Web Publish Config Transformations (https://msdn.microsoft.com/en-us/lib...vs.100%29.aspx) to create different versions of web.config for local development and deployment to a server.

Hope this helps,

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!

Yes, I already have different web.config files for the two environments. I think the problem I'm having is how to change the connection strings specifically for the provider databases created by VS, as opposed to the database I've created for my data. But I will look at the documents you suggest, as I'm sure there is information in there I can use.

Thanks!