To transfer the data stored in the TrackStudio database to another DBMS you can use the feature which allows the data to be exported into an XML file.
This feature is available on the Database Management tab of the Server Manager application (available in TrackStudio/SA). To export the data into XML, perform the following steps:
1. Stop TrackStudio, if it is running.
2. Set the options for the connection with the database that the export will be performed from. This can be done on the Database Connectivity tab.
3. On the General tab specify the character encoding of the file the data will be exported from.
4. Specify the name of the file the data will be exported to.
5. Press the Export Database button and wait till the export process is finished.
As the result of the export process, you will have an XML file containing all the information from all the tables of the TrackStudio database. You can edit and view it using any text editor. It can also be imported to create a new database.
You can import the data from XML into a database only in the process of creating a new database in TrackStudio. To import the data, perform the following steps:
1. Stop TrackStudio, if it is running.
2. Set the options for the connection with an empty database containing no old tables or data from TrackStudio.
3. Specify the name of the imported XML file in the Choose XML scheme field.
4. Press the Create Database button and wait till the process of the database creation is finished.
The import is carried out in the following way:
1) Database tables are created.
2) SQL INSERTs based on the XML file are generated and they insert the data into the database.
3) Indexes and constraints are created.
The import/export feature can be used to transfer data only between two similar versions of TrackStudio. In the event that you have a database from an old version of TrackStudio that you want to transfer to another DBMS you should first upgrade the database to the last version.
The SA and WAR versions use the same database scheme and differ only in the distributed components – no special actions are required to transfer the data between the WAR and SA versions.