My hosting provider assigns the server name, database name, user name and password after I import/upload my SQL server database to them. When I run locally for testing it will be different. How can I effectively test and publish my site without having to change this all the time?
Jump to Post
In your web.config file, keep two different connection strings stored, then just change which one is being used based off of your environment. At work, we have 3 tiers to publishing our sites, development, pre-production, and production. Each one has it's own database server, so we simply keep 3 connections …
All 2 Replies
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.