|
Registry Plus Central Registry Tools
|
| bet | 36/38 | | Sana | 22.07.2021 | | Hajmi | 0,67 Mb. | | #15596 |
Creation and Administration of Databases on the SQL Server
For the initial setup, databases need to be created on an MS SQL Server and regular maintenance and backups need to be performed subsequently.
The responsible IT personnel needs to be able to write SQL scripts to get counts, create specialized extracts, and perform direct updates to the database based on ad-hoc requests from registry users.
Each registry must have access to IT personnel who can perform the above tasks. The above tasks are best left to an experienced database administrator (DBA); this person needs to be extensively involved during the initial setup of the applications. Once the applications are set up, backups and database maintenance need to be performed on a regular basis following the practice of the local data processing center. More complicated SQL scripts for specialized extracts and reports can be written by the DBA or by some other advanced user of MS SQL Server.
Start-up/Conversion: 8 hours of Database Administrator Support
Ongoing: 4 hours/month of Database Administrator Support
|
| |
