Overview

This is simply a utility that will help you tally up the total record counts in each of your tables.  It will also help you identify what fields are using the auto-enter serial number option, and let you know what the next serial number is set to.  Implementing this into your ‘source’ table prior to performing a data migration usually takes only a minute or two, and can save you the headache of tracking down this valuable information manually.

Installation

Here’s what you need to do to implement it:

1. Copy the “MigrationAssistant” table from this solution to yours
2. Copy the “MigrationAssistant” layout from this solution to yours (or feel free to roll your own)
3. Copy the “Migration Assisstant” script folder from this solution to yours

That’s it!
Once you’ve completed those steps, simply run the “Run Migration Assistant Report” script, and you will be presented with your own MigrationAssistant report