database availability question
dbaguru
Posts: 12
When packager is compiling the scripts and data on a somewhat large database (12gb), does the app do any locking, or otherwise hinder availability of the database ?
This discussion has been closed.
Comments
SQL Packager will not intentionally lock any schema or tables when it is creating a package. When the package runs these generated scripts, though, the schema will be locked in the target database and of course any tables that are being updated will have a lock on them.