1. Launch sman (available in TrackStudio SA only).
2. Switch to the Database Connectivity tab.
3. Fill-in the database connection properties.
4. Switch to the Database Management tab.
5. Click the Create Database button to initialize a database.
6. Enter a name for the export file.
7. Click the Export Database button.

Open the created TrackStudio XML export file using any XML editor or text editor. The XML file looks as follows:

<tsExportData>
  <table name="TABLENAME">
    <row>
      <data name="COLUMNNAME1"><![CDATA[DATA1]]></data>
      <data name="COLUMNNAME2"><![CDATA[DATA2]]></data>
      ...
    </row>
    ...
  </table>
  ...
</tsExportData>

Where

• TABLENAME -- the name of a table in the database
• COLUMNNAMEi -- the name of a column in the current database
• DATAi -- the values of table fields for the current record

To import a task, create a record in the GR_TASK table. To import a user, create a record it the GR_USER table. To find out what tables should be modified to create an object: 

1. Export the database. 

2. Log into TrackStudio and create the needed object using the web interface (workflow, message, etc). 

3. Export the database once again. 

4. Compare the file created at step 3 with the file created at step 1. 

Each record has a unique primary key, for example task_id, user_id. TrackStudio uses the GUID generator to set the value of the primary key. When importing data, you can use any method to define the primary key-- just take care that the record keys are unique for each table. The maximum key length is 32 bytes.

1. Create a new empty database.
2. Launch sman
3. Switch to the Database Connectivity tab.
4. Fill-in the database connection properties.
5. Switch to the Database Management tab.
6. Specify the name of the XML file.
7. Click the Create Database button.

To simplify installation we don't send license with embedded evaluation period by e-mail. Instead, TrackStudio estimates the evaluation period based on submit date of your tasks. This feature has a side effect: if you import tasks submitted more than 90 days ago you will got the License Exception during Login process. To workaround this issue set the task_submitdate to the current date for all your imported tasks. After purchase you can re-import those tasks with actual submit dates.