SqlBIManager

Author(s)

• Sjoerd van Noort

Tags

Deploy Deployment SSAS SSIS SQL Continuous Delivery Tabular asdatabase ispac

Functions

Use-SbmLog Write-SbmLogInformation Connect-ASServer ConvertTo-AsmlDatabase Get-ASDatabase Clear-ASDatabase Publish-AsmlDatabase Read-AsmlDatabase Write-AsmlDatabase Write-ASDatabaseCreateReplaceScript Set-AsmlDatasource Add-AsmlRoleMember Clear-AsmlRoleMember ConvertTo-AsmlRoleMember Select-AsmlRoleMember Connect-SsisCatalog Get-SsisFolder Get-SsisProject Publish-SsisProject Export-SsisProject Get-SsisParameter Set-SsisParameter Clear-SsisParameter Get-SsisEnvironment Get-SsisEnvironmentVariable Set-SsisEnvironmentVariableValue

Dependencies

• • SqlServer

Release Notes

Added examples for diffent scenarios deploying ssas tabular databases; setting connection strings, removing, replacinf adding role members.
       Added examples automating get latest from TFS, Building visual studio solutions, generating SQL migration scripts.
       Publish-AsmlDatabase now has "RetainRoleMembers" and "RetainDataSources" switches enabling to publish the database schema from development, while keeping
       the configured connection details and role members on the UAT or production server.
       Added Clear-AsmlRoleMember to avoid carrying development users to UAT or production server.
       Get-SsisParameter now returns extra column "ParameterValue" containing derived parameter value (design default, literal value, or referenced environment variable).
       Added Set-SsisParameter to set project or package parameter value.
       Added Clear-SsisParameter to reset project or package parameter to design default.
       Added Get-SsisEnvironment
       Added Get-SsisEnvironmentVariable
       Added Set-SsisEnvironmentVariableValue
       Fixed setting memberName in ConvertTo-AsmlRoleMember