Impact of running Extract (create DACPAC) against an active, live, production database? #196
Unanswered
chadbaldwin
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I thought I would post this discussion in parallel with my own personal research. Hopefully someone here already has experience with this and can shed some light on it.
We run a single-tenant infrastructure and are trying to build a method for tracking and remediating drift among many databases. One of many methods we are looking into is to use DACPACs....We would extract a DACPAC from the production database, and then generate a DeployReport comparing it against the "golden" database (also a DACPAC).
I realize there are drift features built into DacFx if you register a DAC on the server, however we have not reached that point yet.
Should there be any major concern around running an Extract against an active, live, production database in regard to blocking and resource usage?
I assume the Extract is not much more than a bunch of
SELECT * FROM sys.*
queries and then it builds the model.xml locally. I'm sure I'm vastly over-simplifying it.Beta Was this translation helpful? Give feedback.
All reactions