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 tweaks on a recent backup when it is time to do the final backup. This will also allow our team to support you if you have any questions.
You are required to store all tweaks in your migration playbook.
Failure to do so may result in removal from the Universal Consultant partner program.
Most firms will have the same or similar requests so we have put together two prebuilt libraries for you to leverage.
If you ever need a script something that isn't in our library, let us know and we will consider writing it for you and adding it to the library.
SQL Script Library
The SQL Script Library is a collection of scripts that are designed to be used by a migration specialist to apply mass-tweaks.
For example:
- If a task is related to an archived matter, mark it as complete
- Delete unused Practice Areas
- Synthesize Missing Matters for Documents
SQL Spreadsheets
The SQL Spreadsheet Library is a collection of scripts-that-generate-spreadsheets-that-generate-scripts.
These are designed to be used in coordination with a law firm to apply targeted tweaks.
For example:
Nearly every migration you do will involve the Legacy User Mapping.
Related Articles
01 - Tweaking a Restore
Sometimes after restoring a backup, a customer may want you to tweak the data that is in their new system. Tweaking data post-restore is easy! Let's say that the customer wants you to "mark as complete" all tasks that are related to archived (closed) ...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 ...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 ...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 ...02 - Restore-Specific Database Columns
The following columns are commonly used when Universal Migrator is restoring data into a destination system. Restore Ordering and Priority Batch_Number The Batch_Number allows you to mass-segment data. Only the data with the lowest Batch_Number in ...