At work we've been getting better at writing what's known as GitHub Actions (workflows, YAML). I've got it deploying applications to websites, etc. It is cool.
One thing users would like to have is a means of deploying updates to SQL Server database objects using GitHub Actions. I've thought about this and have come up with some ideas, but then I realized that this problem has undoubtedly been solved before, and better than what I can come up with. So, I'm asking to be pointed to some resources where I can learn more on how to do this. At this point we're using what's known as GitHub Self-Hosted Runner, because all of our websites, applications, etc., are on-prem, in-house. So, the solutions must work within those constraints.
Kindest Regards, Rod Connect with me on LinkedIn.