Rockwell Automation FactoryTalk Historian Classic for Batch User Guide - Manual (Page 19)

Configuring FactoryTalk Historian for Batch Chapter 2
4. In the Source Database area, from the Server Name
drop-down, select the name of the computer where the Batch
History database, containing your batch data, is located.
5. From the Source DB drop-down, select the name of the
database where your batch data is currently stored.
6. In the Admin User field, enter the name of the user with
administrative rights to the batch history database you selected
from the Source DB list.
7. In the Source Database area, in the Password field, enter the
password for the admin user you entered.
8. In the Destination Database area, from the Local Drives
drop-down, select a local drive on the destination database
server where temporary SQL files will be copied during the
migration process. If this drive does not contain a Temp
directory, one will be created by the data migration utility.
NOTE
Approximately 50 MB to 65 MB is required for a Batchhis table
containing one million records.
9. From the Server Name drop-down, select the name of the
computer where the destination database is located.
10. From the Destination DB drop-down, select the name of the
database into which you want to transfer your batch data.
The BHBatchhis table in the destination database must be
blank in order to import batch data.
11. In the User Name field, enter the owner of the destination
database.
Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014 19