What is the correct way to deploy SQL, SSRS and SSIS projects?

arielman2304 676 Reputation points

I have VS solution which includes 3 projects:

Today in my Jenkins pipeline, I'm deploying each one in separate stage:
For SQL I'm using msbuild command.
For SSRS I'm using rs command.
For SSIS I'm using IsDeploymentWizard command.

Last week I saw this article:

So my question what is the proper way to do deploy? using this command for all 3 or one by one?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,306 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,735 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,415 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,816 Reputation points


    As stated in the Doc, -Deploy command only apply for managed code projects. The SQL etc. projects should not be Managed Code project, I have not tried it myself but I am afraid this -deploy command would not work in this particular solution.

    Reference : What is "managed code"?