migratordotnet 0.8 + elmah SqlServer migration script
I’ve been using the excellent error logging module elmah in a project for some time now. This same project uses the migratordotnet framework to maintain the different versions of the database schema, this tool works great and it’s pretty easy to use. But, when trying to get the elmah SqlServer script to execute from a migration I discovered a bug in migratordotnet :(
So, instead of being able to do a call like
Database.ExecuteNonQuery(@”[ENTIRE SQL SCRIPT HERE]”);
I had to separate all the different components of the SqlServer script to execute separately. It took some time and patience but I finally got it working. I put the code up in pastebin for all of you to enjoy.
I hope to Jebus they don’t change the SqlServer script any time soon…
