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

arielman2304 676 Reputation points
2021-05-23T08:12:25.437+00:00

Hi
I have VS solution which includes 3 projects:
SQL, SSRS & SSIS

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:
https://learn.microsoft.com/en-us/visualstudio/ide/reference/deploy-devenv-exe?view=vs-2019

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
    2021-05-24T01:39:29.653+00:00

    Hi,

    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"?

    Regards,
    Lukas