Comments
Sort by recent activity
Thanks Kendra, The current process that we use is that we test/validate the scripts against our Training database which is a copy of Production taken once a day. Once confirmed then we will run the script against Production. Applying the script to Production is a manual process that we would like to automate. Additionally we don't put the scripts in source control currently but rather get saved to a network share. So we definitely want to get them into source control as well as automate deployment. Since these scripts are very much dependent on the state of data and since our dev and test environments are typically stale from a data perspective, running them in dev and test as part of the pipeline wouldn't work well. What we might do is have a two stage pipeline for these scripts that just includes our Training and Production environments. Our we can run them through our normal pipeline but include conditional logic based upon environment, or even data state. Scott / comments
Thanks Kendra,The current process that we use is that we test/validate the scripts against our Training database which is a copy of Production taken once a day. Once confirmed then we will run the ...
Thanks again, it does appear that flyway suits our use case. / comments
Thanks again, it does appear that flyway suits our use case.
I resolved this by writing a powershell script to fix the line endings on the generated stored procedure files and then applied those changes back to my development database. After that the Refresh / Verification step completed successfully. I'm still not certain how the stored procedures were originally deployed without a linefeed on some lines. / comments
I resolved this by writing a powershell script to fix the line endings on the generated stored procedure files and then applied those changes back to my development database. After that the Refres...
Hi Neil,
Yes, that solved my problem. Thank you very much for the quick response!
Scott Kuhn / comments
Hi Neil,
Yes, that solved my problem. Thank you very much for the quick response!
Scott Kuhn
Hi Brian,
I've used the Red Flag debugger before. I generated a trace/debug file this morning if you want to send me instructions on how to send it then I will.
Basically all I did was open a project and run the compare. I did not have any differences so I just stopped there and closed SQL Compare. However, it was still running in the background. I detached the debugger at that point and saved the file.
Thanks,
Scott / comments
Hi Brian,
I've used the Red Flag debugger before. I generated a trace/debug file this morning if you want to send me instructions on how to send it then I will.
Basically all I did was open a proj...