我可以使用什么命令来部署 SSAS 表格模型？

Question

我想使用 Powershell 将表格模型部署到 SSAS 服务器。我可以使用什么命令来部署表格模型？

Answer 1

以下是我使用 Powershell 部署 SSAS 表格模型的命令。

# Generate Input Files for Tabular Model Deployment

# DEPLOYMENT WIZARD
# https://learn.microsoft.com/en-us/sql/analysis-services/multidimensional-models/running-the-analysis-services-deployment-wizard#running-the-analysis-services-deployment-wizard-at-the-command-prompt

# navigate to directory of DeploymentWizard executable
cd "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\"

# Run Deployment Wizard in "Answer Mode" to update input files (if needed)
.\Microsoft.AnalysisServices.Deployment.exe `
    "C:\Users\<username>\source\repos\My Project\My SubFolder\My Tabular Model\bin\Model.asdatabase" /a 

# Deploy Tabular Model to SSAS Server

# navigate to directory of DeploymentWizard executable
cd "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\"

# Run Deployment Wizard in "Silent Mode" redirecting relevant 
# profiler events generated during deployment to an output file
.\Microsoft.AnalysisServices.Deployment.exe `
    "C:\Users\<username>\source\repos\My Project\My SubFolder\My Tabular Model\bin\Model.asdatabase" `
    /s:"C:\Users\<username>\source\repos\My Project\My SubFolder\My Tabular Model\bin\deployment_output.txt"