sequence of script execution
I am using SQL Change Automation in
Visual Studio, Facing an issue with sequence of script execution.
Here is what i am doing
1) Add a Stored Procedure ( let’s say addValue) in Source database
2) Add a migration script, which calls the stored Procedure ( addValue)
3. Make sure Shadow Database is generate ( check the check box to generate Shadow database)
4. Build the solution, it is failed, error says Stored Procedure addValue is not available
I know the issue, as migration scripts are executed before programmable objects. by the time it runs the script ( step 2) stored procedure addValue is not available in the shadow database.
I already explore the deployment order in the project property, but this is for only programmable objects. May be in my case i need the mix of deployment order for migration script and programmable objects.