Dan Wahlin has documented a possible to solution to the problem of changing your Web.config connection string when moving your app between your development machine, the staging server, and finally production. Currently I use the "rename my Web.config to Web.config.live" method. This sounds like it has potential.
Check it out.