Home → Support KB → Advanced (Technical) → How can I split a large database into multiple copies?
1.10. How can I split a large database into multiple copies?
The instructions below are for "Training Manager". Similar procedures apply for Asset Manager and Vehicle Manager. Just replace "Training" with "Asset" or "Vehicle" as needed.
PREPARE
Create a backup of your current database and test it before getting started as described below:
- First, use the menu option: File --> Backup, to create a backup file.
- Copy this backup file to a test computer which has Training Manager installed and which is NOT connected to your server database (you can use a trial copy of Training Manager from our website).
- While logged in to a LOCAL database on a test computer, restore the backup file using the menu option: File --> Restore. Re-open Training Manager and confirm that it works correctly. This will ensure that you have a good backup file and another copy of the database in working order for safety.
SPLIT THE DATABASE
After ensuring that you have a good database backup as described above, you can follow these instructions to create 2 copies of your current database running on your server:
How to run multiple databases on one server
Make sure that you have enough space on your server before beginning the process.
SEPARATE THE RECORDS
After you have 2 duplicate copies of the database running on your server, confirm that you can log into 1 database, make a change, and then log into the other database to confirm that the change is not present.
- Then you can log into 1 database and delete the records which you do not want in it.
- Next, log into the other database and delete the records which you do not want in it.
OPTIMIZE
After separating the records, it's a good idea to perform a backup/restore process on each database to optimize the record storage within the file. Databases do not reclaim all of the unused space when records are deleted, so performing a backup/restore will reorganize the space in the file to reclaim unused space, reduce the file size, and improve the peformance.
Be careful to backup and restore to the same database - name the backup file clearly and ensure that you restore it over the matching database so that you don't overwrite the wrong database upon restore.