Sql Server CI/CD with Jenkins & Redgate

jeetdeveloper

Hello, 

I am following  below  article for SQL Server Database CI/CD 



https://www.red-gate.com/hub/product-learning/sql-change-automation/database-continuous-integration-with-redgate-sqlchangeautomation-powershell-and-jenkins#disqus_thread

I manage to run powershell command and store output nuget package locally. Now I want o push/publish nuget package to Octopus. Is there any plugin available in Jenkins like we have in TeamCity.

Please help 

Russell D

You can find information on all of the available addons here: https://documentation.red-gate.com/sca4/deploying-database-changes/add-ons. 

jeetdeveloper

Hello, 

Thanks for reply. I manage to run and deploy sql server nuget package from jenkins to Octopus. I am following this article. 

https://www.red-gate.com/hub/product-learning/sql-change-automation/database-continuous-integration-with-redgate-sqlchangeautomation-powershell-and-jenkins

In powershell script you can see we have statically define the package version. but what I want is that we should have build counter and and send package number as per that counter to Octopus. 

like in script   $packageVersion = 0.2  I want that to be added as per build counts. As I have to increment the packageversion statically or delete package from output directory

I manage to pass args[0] and args[1] in jenkins job but how do I publish Nuget packages. ??

Awaiting your reply 

Any idea how we can do it ?