iManage Cloud: Post-Migration SQL Scripts

iManage Cloud: Post-Migration SQL Scripts

The following scripts should be run after a migration into iManage Cloud.
They should be run directly on the iManage database server by either your IT support person or iManage support.

Displaying the Original Created/Modified Dates

When documents are uploaded to the iManage Cloud API, the original Created/Modified dates of the document are preserved, however, the iManage web interface does not show these dates.  Instead, the iManage web interface shows the upload date of the documents.


  2. --The following script will replace the upload date of documents with the actual created/modified dates:
  3. UPDATE
  4.     MHGROUP.DOCMASTER
  5. SET
  6.     ENTRYWHEN = FILEENTRYWHEN,
  7.     EDITWHEN = FILEEDITWHEN,
  8.     EDITPROFILEWHEN = FILEEDITWHEN

Displaying the Original Created/Modified Dates

Sometimes the iManage API does not accept Operator/LastUser fields.  These commands will update that.

  2. --The following script will replace the Operator/LastUser fields withthe Author field.
  3. UPDATE
  4.     MHGROUP.DOCMASTER
  5. SET
  6.     OPERATOR = AUTHOR,
  7.     LASTUSER = AUTHOR


    • Related Articles

    • iManage Cloud: Special Permissions When Injecting

      When injecting into iManage Cloud, for best results, the injecting user should be a member of the "nrtadmin" group. To set these permissions, log into iManage Cloud, and navigate to the Control Center: Then click on Groups > NrtAdmin: Then click on ...

    • iManage Cloud: Creating the UniversalMigrator OAuth Application

      For best results, when importing data into iManage Cloud, you should authenticate using an OAUTH Application. The following steps will guide you through the process. 1. Enter your iManage username and password and login: 2. Authenticate to the ...

    • Perfect Law Cloud Extractions

      The Perfect Law cloud environment is locked down in a way that makes data backups take more work than necessary. These instructions will help you gain access to your Perfect Law environment in a way that will assist in a data migration. Connecting ...

    • MyCase Drive: Post-Migration Operations

      Clear the MyCase Drive Cache After a large migration of documents into MyCase, you should clear your MyCase Drive cache. To do that, do the following: Click on the "Show More Icons" ^ in the system tray. Right-click on the MyCase Drive icon. Click on ...

    • Amicus Cloud Extractions: Read Me First

      When backing up data from Amicus Cloud there are a few things you should be aware of. Data is Deduplicated and Merged In the Amicus Cloud database, the contacts are stored multiple times. An algorithm is used to detect duplicate items and merge them ...