Converting applications from Jet database to Oracle database

If you have multiple applications that require Oracle database, you can convert the applications from a Microsoft Jet Database to a single Oracle database using Datacap Application copy tool.

About this task

Multiple Datacap applications within a single Oracle instance are differentiated by the user credentials used to access them. You can use the same Oracle database for multiple Datacap applications, as long as each unique Oracle "User" owns the schema for each application.
Note: You cannot combine schemas for multiple Datacap applications into a single Oracle schema.

Procedure

Complete the following steps to create multiple application schemas in a single Oracle database.

  1. Create a unique user for each application. Log on as that user in Oracle and run the base Oracle scripts for Admin, Engine, and Fingerprint databases.
  2. Use DAppCopy tool to convert the applications.
  3. Change the .app name to match the new application name.
  4. Update the datacap.xml and app.ini for tmweb.net. 
  5. Update the application name in the application Admin database.
  6. Verify each application to ensure that it is working properly.