At work, we have a Microsoft SqlServer instance with many databases, users, stored procedures, and jobs. Infrastructure can be managed with code using Terraform, Ansible, or an equivalent. The data itself can be managed with Flyway or Alembic, but what about the objects like stored procedures that are between these layers?
In the past, we've relied on backups. In order to have a scripted solution from scratch, I've written a tool in Python that builds a dependency tree and then runs SQL to provision these objects, but I was curious how others are doing it. Thanks!
Comments URL: https://news.ycombinator.com/item?id=21786726
Points: 1
# Comments: 0
from Hacker News: Newest https://ift.tt/2rLzbaD
via IFTTT
No comments:
Post a Comment