I just wanted to say thanks for the feedback on SQLAzureMW.
In regards to your items:
DB_NAME() (and DB_ID()) both work in SQL Azure. You are correct.
I removed it from NotSupportedByAzureFile.config and it will reflected in the next release.
For now, if you want, find the MetadataFunction tag and remove the second child with “"DB_(ID|NAME)\s*\”
I changed the regex in NotSupportedByAzureFile.config to force a space before INTO.
You can modify NotSupportedByAzureFile.config and look under GeneralTSQL (about 6 child down) and modify it to look like “SELECT[\w\W][^;]*\sINTO”.
This will also be in my next release.
I agree. I had actually written this both ways (one to file and one to textbox) and found the same thing.
I choose writing to the textbox so people could see something happening and cancel if they wish.
I ran into the issue of writing to a textbox (or in this case rich textbox) a long time ago and there was a way to tell the textbox not to refresh (something … It has been so long I can’t remember) and remove the performance hit.
I will revisit this issue and see if I can come up with a good idea.
In regards to VM-Role or TS, you lost me.
Were you able to somehow make SQLAzureMW a non-interactive batch process?
I would love to understand what you did here.
Going from many hours to less than 25 min is quite awesome.
Thanks again for your feedback!