How to transfer your data to an external database in UTS

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.

1. Log into UTS Server Administration
2. Click on ‘Backups’ under Datastore
3. 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

1. Log into UTS Server Administration
2. Click on ‘Database’ under Datastore
3. Change Database Type to MS SQL or MySQL, depending on what you’ll be using
4. For ‘Server Address’ enter the IP address of your external database server
5. Enter the port number your external database is using. Port 1433 is the default for MS SQL and 3306 is the default for MySQL
6. Enter the name of the database that was created for UTS
7. Enter the Username assigned to the database
8. Enter the corresponding Password
9. 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

1. Log into UTS Server Administration
2. Click on ‘Backups’ under Datastore
3. 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</li>
   • Windows: \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: \Program Files\Extensis\Universal Type Server\data\backups\2011_03_05T00_38_53_328Z.tar
4. Click on the ‘Restore Database’ button
5. 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.

Related KB Articles:

1. How to set up UTS to connect to a SQL Server named instance
2. How to connect UTS to MS SQL
3. How do I move UTS to another server?
4. How to change where UTS stores its backups, logs, and vault
5. How to restore a backup in Universal Type Server
6. How do I schedule backups in UTS?
7. What Universal Type Server directories need to be excluded from Anti-Virus software?
8. I am unable to log into the UTS Administration

---