Technical information

Database Wizard
37
RMS Quick Start Guide
Enter destroy and click OK to continue.
After the database has been removed, the Database Wizard performs a database
connection test and then returns to the main menu.
Importing Data
The RMS Database Wizard can import data files that were exported using this
tool. This data file is an XML formatted collection of all the records in the
database. This process is useful if you have created a new database and want to
import data from an existing alternate database.
After selecting Import from the Import / Export menu, you are prompted to select
the import file. After selecting the import file, click Next to begin the import
process.
After the import file has been processed, the Database Wizard will return to the
main menu.
Exporting Data
The RMS Database Wizard can export all records in a database to a data file. This
data file is an XML formatted collection of all the records in the database. This
process is useful if you want to migrate to another database platform and want to
export all records from your existing database. It can also be used to store
backups of the data in your database.
After selecting Export from the Import / Export menu, you are prompted to select
the export file. After selecting the export file, click Next to begin the export
process.
After the export file has been completed, the Database Wizard returns to the main
menu.
Converting A Database
The Database Wizard can fully automate the steps required to migrate from an
existing database to an alternate database platform. The RMS Database Wizard
can migrate between any of the following database platforms.
 Microsoft SQL Server 2000
 Microsoft SQL Server 2005
The steps required to migrate are as follows: