Migration Wizard and Raiserror oldstyle

Aug 8, 2011 at 8:13 AM

I'm using Migration Wizard v.3.7.4 to Analyze/Migrate my T-sql file.

This works fine for most part.

But one thing that the Wizard don't give me a warning about, but give an error when try to deploy the database on  SQLAzure is Raiserror.

Msg 40512, Level 16, State 1, Procedure ti_abstrakt_tid, Line 33

Deprecated feature 'Oldstyle RAISERROR' is not supported in this version of SQL Server

Shouldn't the Wizard give a warning or migrate this?

 

 

Coordinator
Aug 8, 2011 at 2:06 PM

Yes, the wizard should catch this.  I will contact you offline and to get an example from you so that I can create a rule to catch it.

Thanks,
George

Coordinator
Aug 8, 2011 at 3:27 PM

Just to close the loop for people interested:

Edit NotSupportedByAzureFile.Config and go to line 53, you will find:

 

        <NotSupported Text="RAISERROR\s+[0-9]+\s+['].*" ReplaceWith="" SeverityLevel="2" ReplaceString="false" DisplayWarning="true" DefaultMessage="false" WarningMessage="Deprecated feature 'Oldstyle RAISERROR' is not supported in this version of SQL Server: {0}" />

 

 

Change line 53 to look like this:

 

        <NotSupported Text="RAISERROR\s+([@[\w]|[0-9])+\s+['@].*" ReplaceWith="" SeverityLevel="2" ReplaceString="false" DisplayWarning="true" DefaultMessage="false" WarningMessage="Deprecated feature 'Oldstyle RAISERROR' is not supported in this version of SQL Server: {0}" />

 

Regards,

George

 


Aug 8, 2011 at 3:36 PM

Thank's alot, I will change this in the config file.