Description
This article explains how to transfer your default UTS database to MySQL or MSSQL. It assumes that you have an Enterprise license already entered into UTS and that your external database is already set up for use with UTS.
Solution
Make a backup
If you've already used UTS and want to transfer your data to an external database, the first thing you need to do is to have UTS make a backup.
- Log into UTS Server Administration
- Click on 'Backups' under Datastore
- Click on the 'Back up now' button and wait for UTS to make a complete backup. The amount of time this takes can vary depending on how much data you have in your UTS setup
Connect UTS to your external database
- Log into UTS Server Administration
- Click on 'Database' under Datastore
- Change Database Type to MS SQL or MySQL, depending on what you'll be using
- For 'Server Address' enter the IP address of your external database server
- Enter the port number your external database is using. Port 1433 is the default for MS SQL and 3306 is the default for MySQL
- Enter the name of the database that was created for UTS
- Enter the Username assigned to the database
- Enter the corresponding Password
- Click on the 'New Datastore' button. You will receive a warning that this will delete the current datastore. Click on the 'OK' button if you are ready to proceed. UTS will then delete the previous database and font vault, then create a new database in your external database server
Restore your backup
- Log into UTS Server Administration
- Click on 'Backups' under Datastore
- Enter the full path, including the filename, to the tar backup you intend to restore. By default, when UTS creates a backup, it will be stored in:
- Mac: /Applications/Extensis/Universal Type Server/data/backups
- Windows: C:\Program Files\Extensis\Universal Type Server\data\backups
Example paths:
- Mac: /Applications/Extensis/Universal Type Server/data/backups/2011_03_05T00_38_53_328Z.tar
- Windows: C:\Program Files\Extensis\Universal Type Server\data\backups\2011_03_05T00_38_53_328Z.tar
- Click on the 'Restore Database' button
- You will be asked to confirm that you want to do this. Click on the 'OK' button if you are ready to proceed
At this point, UTS will restore the data from the tar file into your MySQL or MS SQL database. When it's done, you can continue using UTS as before.
Note: When UTS creates backups, it will also back up the data from your external database.