IBM Support

Consolidating Datacap databases into a single database

Product Documentation


Abstract

The following example is using OOTB application (TravelDocs) by moving admin, engine, and fingerprint databases from individual databases to a single database.

Content

  1. Create a target database, such as SQL, and then run the three Datacap database scripts against this database. For example, run SQL_Adm_base.sql, SQL_Eng_base.sql, and SQL_FP_base.sql against the target database.
  2. Copy the source databases to the target database by using the Datacap Application Copy tool command prompt. For example,

    DAppCopy -from -adb "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Datacap\TravelDocs\TravelDocsAdm.mdb;" -to -adb "Provider=SQLOLEDB;Server=localhost;Database=traveldb;UID=sa;PWD=password;"

    DAppCopy -from -edb "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Datacap\TravelDocs\TravelDocsEng.mdb;" -to -edb "Provider=SQLOLEDB;Server=localhost;Database=traveldb;UID=sa;PWD=password;"

    DAppCopy -from -fdb "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Datacap\TravelDocs\TravelDocsFingerprint.mdb;" -to -fdb "Provider=SQLOLEDB;Server=localhost;Database=traveldb;UID=sa;PWD=password;"

  3. Add the connection string in Datacap Application Manager to point to the new database.

[{"Type":"MASTER","Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZRWV","label":"IBM Datacap"},"ARM Category":[{"code":"a8m0z0000001kK0AAI","label":"Datacap TMS"},{"code":"a8m0z0000001h36AAA","label":"Technote"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1.3;and future releases"}]

Document Information

Modified date:
06 November 2023

UID

swg27050961

Page Feedback