Sql Azure Migration wizard doesnot supprt the creation of data dictionary for databse objects.

Question

Migration Wizard skip all the statement required to create data dictionary, while migrating the script......

EXEC

sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The address Id of the address in the system' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'M_ADDRESSMASTER', @level2type=N'COLUMN',@level2name=N'ADDRESS_ID'

GO

EXEC

sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The street number of the address' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'M_ADDRESSMASTER', @level2type=N'COLUMN',@level2name=N'STREET_NUMBER'

GO

EXEC

sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The street name of the address' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'M_ADDRESSMASTER', @level2type=N'COLUMN',@level2name=N'STREET_NAME'

GO

EXEC

sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The street direction of the address' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'M_ADDRESSMASTER', @level2type=N'COLUMN',@level2name=N'STREET_DIRECTION'

GO

Answer 1

afaik, SQL Azure doesnt support Extended Properties...