Database Locks

To protect the integrity of your production database, you can lock it so changes cannot be made to certain application elements. This prevents these changes from being overwritten during promotion to this database from another environment.

Database locks can only be initiated and released by an ODBC Administrator. Database locking activities are recorded in the TS_ADMINCHANGES table.

When the database is locked, the features cannot be modified in SBM Application Administrator:

Projects
Roles
Groups
Users
Notifications and rules
Calendars
Record Locks

When the database is locked, the features cannot be used in SBM System Administrator:

Tables
Folders
File > Put Files in Database
Tools > Archive
Tools > Export
Tools > Import From XML
Tools > Import From Database

Note: During promotion, reports in the receiving database are overwritten with reports in the database from which you are promoting. Users who have modified reports in a production environment may lose those modifications after a promotion.