Existing application databases can be cloned by selecting the Clone button in the database administration screen, accessed from the Administration module. Cloning a database creates a copy of the application database, not of the physical SQL server databases. For an explanation of the difference between these two types of databases see Managing databases.
This feature allows sophisticated user access restrictions to be applied, where the same physical database is made accessible to a user multiple times but with different levels of restriction.
Because the cloned application database refers to the same physical database, both of them are updated at the same time when the physical database is updated by Vacuum.
When cloning an existing database, the following options apply, as shown in the image below:
- Display Name: The new display name for the database - this is the name users see in the Home screen.
- Copy: By default, the defined periods, existing users and default restriction are all copies across to the new database. You can optionally also copy personal favorites and favorite folders.
- Users: All existing users and their current default period and user restriction are copied to the new database.
- Default Restriction: If the source database has a default restriction, it is copied to the new database.
- Folder Favorites: All existing global favorites, stored in folders against the source database are replicated on the new one.
- Personal Favorites: All existing personal favorites created by users on the source database are replicated on the new one.
Related articles