Here’s a handy powershell script to migrate all alert url’s.

 

Problem: When you perform a content database migration to a new SharePoint farm with a different url, the alerts will not fire as the url’s are stored from the previous farm.

For example, migrating from “Intranet” to “IntranetQA” will not work as the old url’s are stored.

Here’s the script:

http://gallery.technet.microsoft.com/ScriptCenter/877d2abd-fce9-4545-b223-7637936dd888/