Deploying a database package to SQL Server through Octopus & TeamCity

jeetdeveloper

I am implementing CI/CD for SQL Server Database through Redgate software and TeamCity. I manage to Build and push the NuGet Database Package to Octopus. I can see the NuGet package in Library section of Octopus. But I am facing issues in deploying that package to SQL Server. I cant find the Step Template "Deploy a NuGet package" in Octopus process section. I have also tried "Deploy a package" step template but it didnt worked.I am following this guide.

https://documentation.red-gate.com/sr1/worked-examples/deploying-a-database-package-using-octopus-deploy-step-templates

Any Help will be highly appreciated

Tianjiao_Li

It may be helpful if you take a look of bellow documentations:
https://documentation.red-gate.com/sca4/deploying-database-changes/add-ons/octopus-deploy/deploy-a-database-package-to-a-single-environment-using-octopus-deploy-and-powershell

https://documentation.red-gate.com/sca4/deploying-database-changes/add-ons/octopus-deploy/deploy-from-a-development-database-using-octopus-deploy-and-powershell

jeetdeveloper

Hello

Thanks for reply.  I manage to deploy Database successfully, but with manual upload of nuget package to Octopus. What I want is that teamcity should directly send that package as external to Octopus. I found jetbrains official docs which I am sharing in attachment. I didnt found Nuget settings and Nuget server page in TeamCity in Administration|Global Settings. Please help me in achieving this.  

Tianjiao_Li

Can you double check if nuget is installed on the server? You can find the installation instruction on this link: https://www.jetbrains.com/help/teamcity/nuget.html