How to migrate MetIDQ Oracle 11g database to WebIDQ?

How to migrate MetIDQ Oracle 11g database to WebIDQ?

Trying to migrate a Oracle 11g database results in the following error logs 


1. Trying the migration wizard the first time fails with



2. Trying the migration wizard afterwards results in



1. Install Oracle 18c XE 

Install Oracle 18c XE on a second PC (let’s called it PC2) (minimum 8GB RAM, recommended 16GB RAM, not recommended 32+GB RAM – potential Oracle database installation problems)


a. Download installer from https://www.oracle.com/database/technologies/xe18c-downloads.html (requires Oracle account)


b. Install Oracle 18c XE database and remember system password for following steps


2. Migrate metkit schema from Oracle 11g to 18c 

a. Prepare METKIT_yyyy-mm-dd.dmp dump file using MetIDQ backup manager on PC1 (where Oracle 11g is installed)


b. Download and extract ImportDumpFile.zip on PC2 (please see the attachment)

c. Copy just created METKIT_yyyy-mm-dd.dmp from PC1 to just extracted ImportDumpFile folder on PC2 and rename it to metkit.dmp

From PC1:



to PC2:




d. Run import_metkit.bat as administrator on PC2



e. When prompted enter the system password defined during install of Oracle 18c XE and press ENTER

f. When prompted check installation directory (should be like C:\app\user\product\18....), type “y” and press ENTER



g. In the end it should say



h. Press any key to close the Metkit import dialog

3. Fix metkit schema in case the migration already failed (can be ommited when migration was never tried on Oracle 11g) 


  1. Download fix_database.zip on PC2 and extract it.
  2. Run fix_database.bat as admin
    a. When prompted enter the system password defined during install of Oracle 18c XE and press ENTER
    b. When prompted check installation directory (should be like C:\app\user\product\18....), type “y” and press ENTER


4. Continue with MetIDQ to WebIDQ migration wizard on PC2


    • Related Articles

    • Database migration from on-premises to cloud version

      Transfer a WebIDQ on-premises database to WebIDQ cloud. Make sure the WebIDQ cloud database does not contain any required data! During the below described procedure, all data in the WebIDQ cloud (target) database will be deleted, which cannot be ...

    • Migration wizard and several other settings are not accessible in WebIDQ account.

      The migration wizard is accessible only with the administrative privileges. If the user don't have admin rights in WebIDQ then Migration wizard in WebIDQ account will not be visible. There are several other functionalities exclusively available for ...

    • WebIDQ on-premises version check

      Read WebIDQ on-premises version 1. Start WebIDQ on-premises. 2. From the main menu select About. 3. Click Third-party licenses 4. The WebIDQ version is shown on top of this page. In this example, version 430.

    • How to reedem the voucher code?

      WebIDQ voucher activation To activate a WebIDQ subscription, please follow this procedure. Activate WebIDQ Login to your mybiocrates account and go to the biocrates web shop > redeem voucher. Every organization is unique and must be registered only ...

    • How to change the sample volume in WebIDQ?

      The sample volume is defined in WebIDQ. Itis the volume which was pipetted to each filter spot of the kit plate. The standard value is 10 µL. This procedure describes, how to change thesample volume in WebIDQ. To update sample volume added to the ...