We help IT Professionals succeed at work.
Get Started

.NET Windows App - How do I tweak the SQL Server connect string for the publish?

Last Modified: 2012-05-11
I've created my first Windows-based .NET apps that connects to SQL Server.  
- The development copy connects to my development SQL Server and works fine.  
- If I paste the contents of the project's bin\Release folder over to a production machine, modify the connect string found in MyApp.exe.config, it works fine.
- I want to do it right, however, by publishing the project.  How do I tell the publish process to use a different connect string?  Do I temporarily the connect string in app.config to configure it for the production server and then publish the project?  I doubt it.
- What is the accepted way of doing this?
Watch Question
Senior .Net Consultant
Top Expert 2016
This problem has been solved!
Unlock 3 Answers and 6 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE