Administering the Database
Overview - Database Administration
This section of System Management Help covers common database administration tasks, such as:
- How to establish database security, including server-side security, integrated logons, and Virtual Private Archibus.
- How to upgrade databases to new versions of Archibus.
- How to track changes to database values.
- How to enable cascading updates for Web Central installations running on Microsoft SQL or Oracle database servers.
- How to create, move, back up, copy, recover projects, and use grant and revoke features. These procedures are specific to the database server programs: Microsoft SQL Server and Oracle.
- Microsoft SQL Server procedures
- Backing Up Projects Overview (Microsoft SQL Server)
- How to Back Up a Multi-User Project (Microsoft SQL Server)
- How to Back Up Database Files Directly (Microsoft SQL Server)
- How to Create a New Project by Copying (Microsoft SQL Server)
- How to Move a Project (Microsoft SQL Server)
- How to Recover Project Data (Microsoft SQL Server)
- How to Use Grant and Revoke in Conjunction with Archibus (Microsoft SQL Server)
- How to Work with Multiple Project Connections (Microsoft SQL Server)
- Usage notes (Microsoft SQL Server)
- Working with multiple projects
- Creating SQL User IDs (Oracle)
- Establishing Multiple Tablespaces on a Single Oracle Server
- Establish Oracle Roles
- Establish Synonyms (Oracle)
- Establish the Tablespace, User, and Role (Oracle)
- Import the Dmp File
- Security in Multiple Tablespaces (Oracle)
- Verify the Archibus Login Credentials (Oracle)
- Working with Audit Logs (Oracle)