Database connection string configuration process improvement

Source: Internet
Author: User
Tags domain name server

When several people work on projects together (including when working with foreign customers), for the convenience of debugging, (will not affect others) we must modify the connection string of the database,
Because we usually useSource codeManagement tools, such as SVN, many people tend to sign which files are careless, which is a big problem for others, and our automatic daily build.
A careful person is also a small mental burden. If this situation can be avoided, we should try our best to avoid it.

One customer once adopted the solution of adding files such as Web. config to ingore. Then create a web. config. default. but this will cause us a lot of trouble every time we update the file, when we change the web. during the config process, we will notify all stakeholders of the project that you want to obtain this item again.

Our solution is to use domain names.
Which side of the connection string does not directly write the IP address or the name of a server, but the domain name. In this way, you can use your host to modify the domain name. Or, the more powerful is the Domain Name Server on its own. You can adjust different reverse return values from the source IP address. Yes.

The next step is to use the default instance when installing the database. Then the user name and password for database connection are the same. (It is best not to use the SA account)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.