I am a software developer working for a municipal government organization. We recently went through a re-organization here, and because of this numerous sharepoint sites and site collections had to be moved around and placed into different sharepoint directories.
The way that we accomplish this is by using the default export/import functionality of sharepoint. It was soon discovered that Alerts do not make the journey from source to destination, and we needed to create a way for those alerts to be moved over.
Because of this issue, I created what I call the 'Alert Migrator'. It is a 32bit/64bit windows application built using Microsoft Visual Studio 2010, in the language of C#.
I have a working copy of the application, and you are welcome to contact me about it's use. I plan on documenting it's creation here within this blog site. If you are interested in using it, or would like to see it have the ability to do something, let me know.
You can reach me at firstname.lastname@example.org, please put the title Alert Migrator in the title.