Changing the database provider

You copy the Datacap application databases that exist in a database provider and move them to another database provider. For example, you can move application databases from a Microsoft Access database in one environment to a DB2® database in another environment.

About this task

For any database except Microsoft Access, the destination database must be installed and able to run the scripts that create the database schema. When updating an existing application, the updated application must be the same application as the existing application. For example, you cannot update a TravelDocs application with an Accounts Payable application.

Procedure

To change the database provider:

  1. At the prompt, type DAppCopy followed by these commands all on one line.
  2. In the -from command, specify the following options for the source environment.
    1. -an: the name of the Datacap application database to copy.
      Skip this step if you want to copy only the database and not the application files.
    2. -af: the path name of the folder from which to copy the Datacap application.
    3. -edb, -adb, -fdb: The connection strings that are used by the application database.
    4. -how: the migration option to use as -online or -datafile.
  3. In the -to command, specify the same options for the destination environment. Use the connection strings for the new database provider.

Example

In this example APT application databases are moved from Microsoft SQL Server in the source environment to DB2 in the destination environment by using the online migration option.

DAppCopy -from -an APT -af c:\Datacap\APTSQL 
-adb "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=APTAdm;" 
-edb "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=APTEng;" 
-fdb "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=APTFP;" 
-how online 
-to -af C:\Datacap\APTDB2 
-adb "Provider=IBMDADB2;Server=MyDB2:5000;Database=APTAdm;UID=myUserName;PWD=myPassword;"
-edb "Provider=IBMDADB2;Server=MyDB2:5000;Database=APTEng;UID=myUserName;PWD=myPassword;"
-fdb "Provider=IBMDADB2;Server=MyDB2:5000;Database=APTFP;UID=myUserName;PWD=myPassword;"
-how onlineDAppCopy -from -an APT -af C:\Datacap\APT