Screenshot of Alert Migration Utility

Here is the Alert Migrator in action, and here's how it works.

1. You choose your SQL Database instance at the top left, and add your sql credentials. (User must be a sysadmin, or have read access to all SQL databases on the server).

2. Then press Connect, the utility then goes to the backend, and gets a list of all databases that it recognizes as valid Sharepoint databases. It puts this list together, and then shows that list in the 'Select a source Sharepoint database'.

3. If you click on a database within the 'Source' list, it will populate the Data Grid below with all the Alerts that it found for that particular database.

4. You can select alerts you wish to migrate, and check off the Migrate selected Alerts only.

5. If you click Refresh, this will show all the potential Site Collections that can have alerts migrated to.

6. At this point it's up to you, the user, to make sure that the site collection that you are migrating to has the structure necessary to accept the alerts that you are migrating from. Sharepoint likes to add tokens to the URL and this sometimes confuses the issue (and it's likely the reason they decided to NOT bring alerts over, because of this confusion).

7. You can make an adjustment to the numer of tokens to strip from the Source, by changing the 'Number of Tokens to remove' text box in the upper center portion of the form. If you have a Site of /a/b/c in your database, and you want it to go to a site collection that looks like /d/b/c, then you put 1 in the number of tokens to remove box, and this will strip out the /a/ in the source site, and deposit it behind the /d/ in the destination site.

8. Select a destination site to move the alert's to, and then try the 'Test Migrate Alerts' button. This will tell you if any of the Alerts are going to have problems when you try and migrate them.

9. Once you are satisfied that all Alerts will be going the right place, then click the Live Migrate Alerts button, and watch the utility do it's work.

That's really all there is to it, comments on this app are welcome.