Help

(karthick) #1

Hi i am new to this tool Wednesday on wards i am going to work in this tool
i am from DB team I need complete documentation of Team City to Octopus Deployment using Power shell script with Stored Procedure Please guide me and help me Please consider my message

(Justin Walsh) #3

Hi @karthick!

Welcome to the world of Octopus deploy! We’re glad to have you with us!

A great first start with Teamcity and Octopus would be our “Turbocharging TeamCity with Octopus Deploy” webinar, which can be found here: https://octopus.com/blog/turbocharging-teamcity-with-octopus-deploy - this will give your some great information about how Octopus and TeamCity work together, and how to leverage the strengths of both products.

Additionally, we have a great series of blog articles covering automating your database deployments with Octopus, which can be found here: https://octopus.com/blog/search?q=automate+database

If you do just want to execute a stored procedure through powershell, you would just need to define a script step in your deployment process, and then use something like:
Invoke-Sqlcmd -ServerInstance "your_server" -Database "your_database" -Query "EXEC your_stored_proc"

I hope this helps - happy deployments!

(karthick) #4

Hi @Justin_Walsh

Thanks for your support i will go through please guide in future if i need any help

(karthick) #5

Hi @Justin_Walsh

Can you please share any steps in screen shoot

(Justin Walsh) #6

Something like this should do it, @karthick!

Obviously changing “server”, “database”, and “your_stored_proc” to the appropriate values.

I hope this helps!

(system) closed #7

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.