Activity overview
Latest activity by skuhn
Thanks again, it does appear that flyway suits our use case. / comments
Thanks again, it does appear that flyway suits our use case.
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 ...
Do you use SCA for application support data update scripts?
We are currently using SCA for our application's database and we are exploring how to manage data update scripts that arise as part of day to day application support. These scripts are typically us...
Change how static tables are stored in the sqlproj file (Suggestion)
Hi,It appears that list of static tables included in a project are stored as a single line entry in the *.sqlproj file. This often results in merge conflicts as it is a one line difference. (at lea...
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...
Issue at refresh / verification step
I'm attempting to create a new SQL Automation project using an existing database that has hundreds of objects in it. The initial step of pulling in the objects and setting a baseline works without...
Lost SQL Source Control Links using localdb
Me and my team are using SSMS 17.7 along with SQL Source Control 6.0.2.6908 with git 2.17 on Windows. We have recently shifted from using a shared development database to using dedicated databases ...
Shared Filter Rules?
Hi,
Here is our scenario:
1. A developer links a database to SQL Source Control
2. That developer creates filter rules for certain objects
3. That developer commits the filter rules to our source c...
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
Issues with new Release 10.2.0.696
I recently upgraded to the latest version, 10.2.0.696 and when performing a compare SQL Compare is showing over 200 tables as "existing in both but different". Since we have made very few changes ...