Activity overview
Latest activity by dbuenosilva
Hi @oweston12 This post was a while ago, but I am still not sure what is the best way to deploy SQL Jobs with RedGate. In our scenario, we don't want to re-create the jobs to avoid losing schedule and history. I would appreciate you sharing with us what approaches you have tried and which one works better for you. Cheers, Diego / comments
Hi @oweston12 This post was a while ago, but I am still not sure what is the best way to deploy SQL Jobs with RedGate.In our scenario, we don't want to re-create the jobs to avoid losing schedule a...
Thanks @DanC Let me try it! I will post the results soon. / comments
Thanks @DanC Let me try it! I will post the results soon.
Re-deploy all stored procedures regardless previous deployments
Hi there,When a stored procedure is modified directly in the database, and its changes are not pushed to the repo, a new deployment will not overwrite the altered stored procedure in the database i...
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. / comments
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...
Can SCA deploy always Views before Stored Procedures?
Hi there,We often have developers creating stored procedures that depend on views being created at the same task.SCA automatically creates the stored procedures in the "Programmable objects" -> <sc...