Well one of my customers had asked the as significance of this property as he didn’t find anything on net so thought of writing an article about it.
Retain Configuration Setting:
Will retain all properties of Connection String except Password.
Project which you want to deploy, have SQL DB Server Name – Server A and Database Name as Test specified in Data Source Connection String but in your Destination server where you are deploying, Server Name is Production and Database Name is ProdDb.
1) If you check the Retain Configuration Setting
Server Name on the AS Server will remain as Production
RDBMS Database Name will remains as ProdctDB but if you will process it will fail (which is by design) you need to provide the password explicitly.
2) If you un-check the Retain Configuration Setting
Server Name on the AS Server will change to your Project’s Server name which is Server A
RDBMS Database Name will be changed to your Project’s Database Name which is Test