False Positive on user_id?

Nov 4, 2009 at 6:58 PM

Hello,

 

I am running version 1.8 of the Azure Migration Wizard using the SQL Script tab.  I am getting an error "user_id is not supported in current version of SQL Azure" against a user defined column.  I am not using the USER_ID() function.  Is this a false positive?

 

--~ user_id is not supported in current version of SQL Azure
IF NOT EXISTS (SELECT name FROM sysindexes WHERE id  = object_id(N'[dbo].[usergroups]') AND name =N'idx2_usergroup')
CREATE index [idx2_usergroup] on [dbo].[usergroups](usergroup_name,user_id)

 

Thanks and Regards,

Tony Fedirko

Coordinator
Nov 5, 2009 at 2:45 PM
Edited Nov 5, 2009 at 2:47 PM

Hi Tony,

Yes, you are correct.  That is an error on my part.  If you want, you can edit NotSupportedByAzureFile.config go to line 210 and change (S)?USER_ID to suser_id\s?\(['\w\s]*\). The finished line would look like this:

<NotSupported Text="(IS_SRVROLEMEMBER|SETUSER|SYSTEM_USER|suser_id\s?\(['\w\s]*\))" ReplaceWith="" SeverityLevel="2" ReplaceString="false" DisplayWarning="true" DefaultMessage="true" WarningMessage="" />

This should fix the issue.

If you want, just ignore the message.  The next time I upload SQLAzureMW I will have the fix in there.

Thanks for bringing this to my attention.

George

 

 

 

Coordinator
Nov 7, 2009 at 7:59 PM

Hi Tony,

v1.9.1 has the changes to NotSupportedByAzureFile.config.

Regards,

George