question

Shagufta avatar image
Shagufta asked

How to use power shell to deploy database stored procedures

I need to deploy couple hundred stored procedures to production. Some body told me that this can be achieved quickly by using power shell script. can any one help me with the power shell I am new to this. Thanks Shay
powershell
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

How is your code you need to deploy stored (e.g. sql script files in a directory)?
1 Like 1 ·
Hi Shawn, We are changing the sql server compatibility mode 80 to 100 and we have couple hundred database objects like stored procedures and functions etc to deploy. We have individual file for each object in a directory for example all the Stored procedures are under one directory and the function are in other. We decided to use the bat file to drop and create the database objects but for production server its a security violation. We cannot use the bat file to create\deploy database objects in production environment. is it possible to achieve this using power shell ? I am not familiar with power shell that why I am asking for help. Thanks, Shay
1 Like 1 ·

1 Answer

· Write an Answer
icehouselux avatar image
icehouselux answered
Just happened to check this link...please see if this helps https://www.simple-talk.com/sql/ssis/deploying-multiple-ssis-projects-via-powershell/
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.