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
Here are this and some other articles on SSAS Deployment ssas-wiki.com/.../Articles
the same lack of information exists for the "Retain optimization settings" flag... If you have more infos about it, could you explain how it works?
Thank you so much.