none
SQL Server Database Reports RRS feed

  • Question

  • I know that the information I require is available by accessing the database directly but the SQL Server database reports show the status of the database

    Status=ONLINE,   Updateability=READ_WRITE, UserAccess=RESTRICTED_USER, Recovery=SIMPLE,   Version=706, Collation=Latin1_General_CI_A

     However this information is truncated and is useless if we are using it to match candidate databases for Azure SQLDB migration using the Collation. can we please have this increased to show the fill extent of the Status data from the database please

    On another note are there plans to incorporate the DTU calculator into MAP to help with SQLDB migration planning?

    Regards

    Andy

    Tuesday, August 2, 2016 9:56 AM

All replies

  • OK I have had a look @ the database and this appears to be because the Table

    SqlServer_Inventory.DatabaseProperties

    has

    [Status]

    [nvarchar](128)NULL

    which is truncating the data

    Friday, August 12, 2016 1:13 PM