how understanding tie strings deploying an asp.net site?

right the exam prolongation databases same server, nonetheless opposite names. deploying meant modifying web.config change tie strings repremand database. step i forget too frequently...

we've finally combined new database server testing, i'm relocating databases over... nonetheless server opposite we'll still need understanding tie twine issues.

i pondering handling around hosts file, nonetheless guess switching desktop accessory whenever i need exam opposing prolongation information seems unwieldy during best.

so i'm only wondering there's improved proceed out there. something build "production" web config deployment ideal...