There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
String literals as column aliases
Hi, I'm using the tool to migrate the DNN database to Azure, and I'm finding that some old store procedures are using "String literals as columns aliases". i.e. SELECT 'Total users'=1. This is not supported on SQL Azure and the migration wizard
is not detecting this issue.
There is an easy solution that is to replace the single quotes (') by brackets "[" "]", i.e. SELECT [Total users]=1
If this is automated by the wizard, I think that I don't need to touch manually the SQL scripts before upgrading to Azure.
Thanks for your great work.