Activity overview
Latest activity by rpaul
@DanC Jenkins handles the deployment. I've started looking at the documentation for Change Automation but right now I'm unclear how the process works for the devs. EDIT: To be more specific, we manually deploy once a week. / comments
@DanC Jenkins handles the deployment. I've started looking at the documentation for Change Automation but right now I'm unclear how the process works for the devs. EDIT: To be more specific, we man...
@DanC, We are an enterprise data repository team needing to clean up our version control process. We use Jenkins to deploy to our production server, tied into GitHub. We previously just had one user committing everything to GitHub but decided to have each dev use local databases and push their own branches for review. Since we had access to Redgate tools, SQL Source Control seemed like the best way to allow everyone to push from SSMS. Most frequently our work consists of updating stored procedures or inserting data. / comments
@DanC, We are an enterprise data repository team needing to clean up our version control process. We use Jenkins to deploy to our production server, tied into GitHub. We previously just had one use...
@DanC, we can't use SQL Compare because our devs don't have write access to the prod server. We also have an automated CI/CD tool (Jenkins) so we just need to get changes into GitHub. / comments
@DanC, we can't use SQL Compare because our devs don't have write access to the prod server. We also have an automated CI/CD tool (Jenkins) so we just need to get changes into GitHub.
Thanks @DanC. Is it possible I'm not using the tool correctly? My devs make changes to objects in their local db and then push it to GitHub using SQL Source Control. In that way, the tool is not dynamically picking the right statement because the objects do already exist but it is still removing "ALTER OR". Should we be doing something differently or is this a bug? / comments
Thanks @DanC. Is it possible I'm not using the tool correctly? My devs make changes to objects in their local db and then push it to GitHub using SQL Source Control. In that way, the tool is not dy...
Hi Dan, sorry, I clarified my question. The file is a stored procedure and is in that folder. / comments
Hi Dan, sorry, I clarified my question. The file is a stored procedure and is in that folder.
Why is SQL Source Control stripping "ALTER" out of stored procedures?
Last week I tried to commit a stored procedure through SQL Source Control, and was surprised to see that it was stripping the "ALTER" out of "CREATE OR ALTER" in the file. This is obviously a probl...
Local DB unlinks from source control every time SSMS is closed
Every time I reopen SQL Server Management Studio my local database is no longer connected to source control. The database is not rebuilding or anything, it is persistent, so I'm not sure what's goi...