>Hi, every time I deploy my application to the server, My Server configuration file is replaced, so connection string is now having a reference to the test SQL Server instead of the Production Server.
>
>How can I avoid configuration file to be replaced when deploying.
>
>It is posible to just deploy a web page? using visual studio?


Have two copies of web.config. One in the DEV server, one in Production. Each points to different data servers.
When you copy (or Publish), do not copy over (or FTP over) the web.config file.