Cerenade Extractions: Pre-Extraction Database Optimizations

Cerenade Extractions: Pre-Extraction Database Optimizations

At one point in Cerenade's development history, it stored documents directly within its own database.
The Cerenade developers later migrated the documents to Azure storage, however, artifacts may still exist in customer databases who have been using Cerenade for a long time.
Because these artifacts can slow down the data extraction, we highly recommend purging them.  To do so, run the following scripts:


  2. UPDATE CaseInsuranceClaimDocuments SET FileContent = null WHERE FileStorageLocationID = 3
  3. UPDATE OrganizationDocuments SET FileContent = null WHERE FileStorageLocationID = 3
  4. UPDATE ClientVisas SET FileContent = null WHERE FileStorageLocationID = 3
  5. UPDATE CaseUSCISReceipts SET FileContent = null WHERE FileStorageLocationID = 3
  6. UPDATE QuestionnaireDocuments SET FileContent = null WHERE FileStorageLocationID = 3
  7. UPDATE ClientCustomDocuments SET FileContent = null WHERE FileStorageLocationID = 3
  8. UPDATE ClientDocuments SET FileContent = null WHERE FileStorageLocationID = 3
  9. UPDATE CaseCustomReceipts SET FileContent = null WHERE FileStorageLocationID = 3
  10. UPDATE ClientI94s SET FileContent = null WHERE FileStorageLocationID = 3
  11. UPDATE InternalEmailDocuments SET FileContent = null WHERE FileStorageLocationID = 3
  12. UPDATE CaseDocuments SET FileContent = null WHERE FileStorageLocationID = 3
  13. UPDATE ClientPassports SET FileContent = null WHERE FileStorageLocationID = 3
  14. UPDATE ClientPictures SET FileContent = null WHERE FileStorageLocationID = 3
  15. UPDATE CaseHealthcareLogDocuments SET FileContent = null WHERE FileStorageLocationID = 3


    • Related Articles

    • Time Matters: Custom Field Extractions

      Among practice management systems, Time Matters is unique in terms of how it stores custom field data. This translates into a unique experience backing it up and working with it. The purpose of this article is to help you understand how Time Matters ...

    • 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 ...

    • MyCase Injections: Pre-Migration Homework

      Prior to restoring data into MyCase the following items should be cleaned up in your legacy system. Activities with Sub-Decimal Hours When activities are transferred to MyCase, the duration of all entries will be rounded up to the nearest 0.1 hours. ...

    • 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 ...

    • Prevail Backups: Database Conversions

      Converting the Database Prevail uses an object-oriented database named Postgres. Recover your username and password to Postgres Refer to the Training: POSTGRES - Recovering username/pw article for instructions on preparing your database for ...