Convert Data from the Origin Database to the Destination Database Using the Database Conversion Utility

Below the ODBC Status Report section of the Database Conversion Utility is a Convert button. The Convert button is disabled until both the origin database and the destination database have successfully been specified and all conditions required for conversion are met.

Once the required conversion conditions have successfully been specified, the Convert button becomes enables, and you are ready to convert the data from the origin database to the destination database. To do so, click the Convert button. When you click on this button, you will be required to confirm the conversion by one of the following two dialogs.

image\dbcadd.gif

The dialog above will appear if you have specified a new destination database that has not yet been created. Clicking the "Yes" button will command VTS to create a new destination database for you based on a template, using the path, name, and extension specified in the Selection field of the Destination section of the Database Conversion Utility.

image\dbcreate.gif

The dialog above will appear if you have specified an existing destination database. Clicking the "Yes" button will command VTS to convert the data from the origin database and add it to the destination database.

In either case, if you wish to stop the conversion, click the "No" button and the conversion process will be aborted.

Once you've chosen to convert the data from the origin database to the destination database by clicking the Convert button, the Database Conversion Utility will begin the transfer of data.

If you have chosen to convert data to an existing destination database, and some of the records in the destination database have the same first field or primary key as the records in the origin database, the records in the origin database will overwrite the matching records in the destination database.

Any new records (appearing in the origin database but not in the destination database) will be added to the destination database, and any existing records (appearing in the destination database but without duplicate records in the origin database) will be left untouched.