none
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

    Thursday, April 05, 2012 10:26 AM

Answers