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) matters.  Here's what you'll do:

Add the Script to your Playbook and Run It

First, write the script to apply the tweaks you want.  You can use a script like this as a template:

1. If a task is related to an archived matter, mark it as complete
   

In your script, make sure to update the records so that the ones you are changing have the higuest Action_Group value.

Launch Universal Restore

Open Universal Migrator and choose the Universal Restor option that you want.

Apply the Tweaks

On the restore screen, do the following:

1. Uncheck all options
   
2. Re-Check the option that matches the table that has the data you want to tweak
   
3. Uncheck Restore New Records
   
4. Check Tweak Existing Records
   
5. Click Next

How Tweaks Work

When Universal Migrator tweaks a record, it sends the necessary commands to the destination system to make the record match what is in the backup.  It is important to remember that Universal Migrator will ensure that all the columns match the backup and not just the one you just adjusted.  For example, if a customer had manually edited the description for one of the tasks that we tweaked, applying the tweak will reset the record so it matches what is in the backup.

• Related Articles

• 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 Action_Group The Action_Group allows you to mass-segment data. Only the data with the highest Action_Group in ...

• 03 - Pre-Restore Processes

  Between the time that you took your initial backup and wrote your playbook, some time will have elapsed. During this time, the client has likely added or changed data in their source system. Prior to completing the restore, you should do the ...

• 04 - Pre-Restore Review

  All Consultants Prior to restoring data into a destination system, you should thoroughly review and test your playbook. Your playbook should be complete and cover all the data that you expect to migrate as part of your project. Thoroughly review and ...

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