question

arielman2304-0180 avatar image
0 Votes"
arielman2304-0180 asked LukasYu-msft commented

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

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://docs.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-generalsql-server-reporting-servicessql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft commented

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Have you resolved your issue ? Could we offer more support?

0 Votes 0 ·