March 14, 2016 at 8:05 am
To try and speed up our deployments into new environments (test and live), we've produced an SSIS package that undertakes many of the tasks (backing up and deploying databases, etc.). This has worked well for dramatically speeding up deployment and ensuring that all of the sizeable list of tasks are done correctly. However, we're struggling when it comes to updating connections in our tabular models.
Example:
1. Backup MyTabularModel.abf using an Analysis Services Execute DLL Task
<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>MyTabularModel</DatabaseID>
</Object>
<File>F:\TM\MyTabularModel.abf</File>
</Backup>
2. Restore MyTabularModel.abf to new environment using an Analysis Services Execute DLL Task
<Restore xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<File>F:\TM\MyTabularModel.abf</File>
<DatabaseName>Acorn</DatabaseName>
<AllowOverwrite>true</AllowOverwrite>
<DbStorageLocation xmlns="http://schemas.microsoft.com/analysisservices/2008/engine/100/100">K:\TM\</DbStorageLocation>
</Restore>
3. Update the connection string:
from Provider=SQLNCLI11;Data Source=OldEnvironment;Integrated Security=SSPI;Persist Security Info=false;Initial Catalog=MyDatabase
to Provider=SQLNCLI11;Data Source=NewEnvironment;Integrated Security=SSPI;Persist Security Info=false;Initial Catalog=MyDatabase
How do we change the connection string programatically?
Stuart
March 22, 2016 at 9:29 am
With no suggestions here I raised the same question on MSDN.
For posterity, here were the responses:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply