Can SCA deploy always Views before Stored Procedures?

• 
  Hello dbuenosilva,
  
  Thanks for your question Diego, are you looking to set the definition once and then have that order respected?
  
  If so, this solution should work for you, it may be worth checking that EvaluateExecutionOrderOnImport is correctly set so your changes aren't overwritten.
  https://documentation.red-gate.com/sca/developing-databases/working-with-the-visual-studio-extension/advanced-scenarios-for-visual-studio/customizing-programmable-object-deployment-order-in-visual-studio
  
  Or were you looking to uniformly alter the deployment order by type, so views would be deployed first, then sprocs?

  Peter_Laws November 04, 2022 08:56

  - 0 +
• 
  Thanks, @Peter_Laws for replying to it.
  
  We use EvaluateExecutionOrderOnImport = FALSE.
  
  We're looking to uniformly alter the deployment order by type so that views would be deployed first, then sprocs. By doing so, we wouldn't need to customise object deployment orders in Visual Studio.
  

  dbuenosilva November 10, 2022 02:05

  - 0 +
• 
  Thank you for clarifying, I'm afraid this functionality isn't explicitly available in SQL Change Automation, however you might be able to get closer to what you want.
  
  By editing the programmable objects grouping, you could sort them by object type rather than schema (the default), could that htne make the deployment ordering definition easier?
  
  https://documentation.red-gate.com/sca/developing-databases/concepts/migrations/programmable-objects
  referencing https://documentation.red-gate.com/sca/reference/sql-change-automation-project-settings

  Peter_Laws November 22, 2022 10:23

  - 0 +

Add comment

Please sign in to leave a comment.