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

Configuring FactoryTalk Historian for Batch Chapter 2
The SQL database has been successfully initialized with the
FactoryTalk Historian for Batch schema. If you have batch
history data from a previous version of FactoryTalk Batch
stored in a SQL database that you want to move into your new
SQL database, see Migrating Batch History Data from SQL
Server (page 18) for instructions.
If you have existing batch history data stored in an Oracle 8i
database, and you want to begin using FactoryTalk Historian for
Batch to view and analyze your existing batch history data, you must
upgrade your Oracle database to Oracle 9i and migrate your
Oracle 8i batch history data into an Oracle 9i RSBizWare 8.0
database. The following summary describes how to perform the
migration using standard tools provided in Oracle. This summary
does not include details regarding installation, setup, or
configuration of the Oracle environment. Before batch history data
can be migrated, the Oracle environment must be installed and
configured by your site database administrator.
1. Configure the Oracle Management Server for the existing
Oracle 8i database.
2. Open the Oracle 8i Enterprise Manager and connect to the
Oracle Management Server.
3. Select the data management export wizard to export the
BATCHHIS table from the existing Oracle 8i database.
4. Execute the import wizard to import the Oracle 8i
BATCHHIS table into the RSBizWare Oracle 9i database.
5. To transfer the data from this imported BATCHHIS table
into the FactoryTalk Historian for Batch (BHBATCHHIS)
tables, create a query that calls the BHInsert procedure.
Following is an example query:
-- Once the Batchhis table is exported from the source database
and imported in the destination
-- the following example can be used to transfer data from the
Batchhis table to the BHBatchhis
-- table. This example uses a Cursor FOR Loop and calls procedure
BHInsert.
Migrating Batch History Data
From an Oracle 8i Database
To Oracle 9i
Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014 17