02 - General Backup Guidelines

02 - General Backup Guidelines

When backing up data, the process will vary from one application to another, however, there are some general guidelines that you should always follow:

Always Backup All Data You Will Ever Need

When you are creating a backup, always back up all the data that you will ever need for your project.  For example, if you are doing a full migration from one system to another, always backup everything even if you don't need all the data yet.

While you might think it will allow you to work quicker, it will make the project much more complex. Because you will have a partial view of the database, then it will not be possible for you to reliably verify all the links between the client's data (How can you verify all matters are linked to valid contacts if you didn't backup contacts?). 

When restoring data into a destination system, Universal Migrator requires all the data to be sourced from the same database.

Additionally, many of our processes and procedures expect that you have a full view of the data.  If you don't, then you are making your project much more complicated and taking yourself outside our standard processes.


Always Backup to a New Database

When Universal Migrator backs up a system, it will store all the data in the database you specify.  Unless otherwise directed, always backup data into a brand new, empty database.

Each record that Universal Migrator backs up has a unique ID associated with it.  If you backup to a database that is already in use, you will have conflicting IDs which will cause errors in the process.


Special Considerations Regarding Documents

Before talking about document backups, there are some common terms you need to know.

TermUsage / Meaning
Document

When working with enterprise and cloud-based document management systems, the human-visible name of a document often varies from the actual file path of a document. For example, a document that users refer to as "Motion for Private Process.docx" might have different versions that live at different locations. 

A document is a combination of metadata and one or more versions / BLOBs.  By storing the metadata and blob separately, the legacy application can preserve important information such as Created/Modified dates even when the document is moved from one server to another by an IT administrator.

Document Metadata

Document Metadata represents the human-visible information about a document including the name of the document, the folder path it is in, its created/modified dates, and any contacts/matters it might be linked to.  Metadata is often stored in a database.

Document Metadata looks like this:

Document #1...
... is named Motion for Private Process.pdf
... is associated to Matter ABC.001.
... is viewable in 
the folder \Motions\Drafts\
... 
was created on 2021-01-01 by John Smith 
... 
was most recently modified on 2022-02-02 by Jane Doe.

Document Version

A document version represents an item in the edit history of a document.  It is often stored in a database with a link to a document and a BLOB.

Document Version metadata looks like this:

Version 2 of Document #1:
... was created on 2022-02-02 by Jane Doe.
... lives on a server at BLOB path \\SERVER\Docs\DF1E6A29.docx

 Document BLOB "Binary Large Object".

A blob is a random file path that that has the raw contents of a file in it.  By itself, a blob is not very useful because it will have a random file name and no identifiable information.

A blob is usually a file path like this:

\\SERVER\Docs\DF1E6A29.docx

However, some systems use human-understandable blob paths like:

\\Server\Docs\ABC.001\Motions\Drafts\Motion for Private Process.pdf 


Document Backups involving On-Premise Applications

When backing up an on-premise application, Universal Migrator will not make a second copy of the document BLOBs. Instead, it will use the direct network path that the documents are use to. (For example, \\Server\Docs\ABC.001\Motions\Drafts\Motion for Private Process.pdf ).  After backing up the documents, you should ensure that you can access the documents in this location from your migration workstation.  You may need to mount a network drive or update the ContentPath in the backup database.

Document Backups involving Cloud-Based Applications

In a cloud system such as Clio, NetDocuments, or Smokeball, Universal Migrator will prompt you to provide a Document Content cache path.  You should select a location that has enough space to contain all documents from the system you are backing up.  Ideally, this should be the DOCS folder from your Migration Workspace and not on a file share, network location, or USB Drive.  Also, please note that each document will be temporarily staged to the local TEMP directory before being moved to its final location.

Always Backup to the Same Document Cache

When backing up data from a cloud app, always have Universal Migrator cache the documents to the folder above.

In order to optimize speed, before downloading a file, Universal Migrator will perform an integrity check on each file in the cache and compare the following information:
  1. Created Date
  2. Modified Date
  3. File Size
If all of the attributes above match their expected values, Universal Migrator will save itself a step and just use the cached file.  Otherwise, it will redownload the file.

When preparing for a migration, you can use this capability to deliver a faster migration experience to your customers.  For example, if you are going to do a migration on Thursday, on Monday you can do an initial backup of the documents.  On Thursday, if you backup to the same folder (but a new Database), it will go much faster since it will not need to download all the documents a second time.


    • Related Articles

    • 01 - Tweaking a Backup

      After you have completed a backup, your client may want you to tweak the data before restoring it into their new system. The scripts for any tweaks that you apply should be saved into your Migration Playbook. This will allow you to replay all the ...
    • Training: Overview

      Welcome to the Migration Academy! This series will help you learn everything you need to know in order to deliver high-value, rock-solid data and document migrations. Completion of the academy generally takes 4-8 hours and is required in order to ...
    • 01 - Reviewing a Backup

      The Universal Database contains tables for each type of data you might backup or restore between systems. While most of the columns are unique to each table, certain columns exist on all tables. The purpose of this article is to describe what each ...
    • 03 - Backing Up a Cloud-based System

      This tutorial will guide you through backing up data from a cloud application. While this tutorial will demonstrate backing up data from Clio, the steps are nearly identical for every cloud-based application. In this tutorial we will: Launch the ...
    • 03 - Scoping your First Migration

      When a patient needs an operation, a good surgeon gets as much information as possible from the patient before recommending a course of action or providing a quote. By taking this approach, the surgeon can provide a better, more informed experience ...