It would be beneficial if the connection string and provider of the model is updated when migrations are executed via the migrations menu.
refer: http://www.mindscapehq.com/forums/thread/364656