4 ms·
DbUp, SQL files, and git. We have the documentation in txt/md files inside the git repo. With a checklist for developers. Then documentation for DBA to review
by guilhas 8y ago
DbUp, SQL files, and git.
We have the documentation in txt/md files inside the git repo.
With a checklist for developers.
Then documentation for DBA to review.
Special attention on UPDATEs/DELETEs on user generated data.
Folders procedures, schema, and data.
Procedures are full, idempotent, execute everytime.
Schema is transactional, files starting with datetime.
Data is idempotent, execute everytime. Using sql server MERGE.