0

I'm trying to get a consolidated sql file by reading all the .proc(Sybase stored procedure) files at a directory using PowerShell. While doing so, it is required to maintain their order as per dependencies to avoid any "stored procedure not found error" while deployment.

My current logic loops in all the files looking for a Sp name, when found I keep it in a ArrayList. If any dependency is found and is already in my array, i would insert it at one position before the dependent stored procedure. But this identifies 1-1 relationship between them,and does not resolves all the dependencies.

Expected result is a consolidate file which can be deployed on database.

Improve this question
2
  • have you considered this post: stackoverflow.com/questions/2470945/… Commented Jan 17, 2019 at 22:59
  • These stored procedures are not yet present in the database. It is for first time deployment. Commented Jan 18, 2019 at 6:11
Related questions
141
Dynamic Sorting within SQL Stored Procedures
6
Stored Procedure - forcing execution order
6
PowerShell dependency management
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.