sql2012 and sql 2016 comparison RRS feed

  • Question

  • Hi everyone,

    W are just doing a migration from sql 2012 enterprise  to sql 2016 standard. This involves migrating lots of sql jobs running on sql 2012. I would like to make sure that performance doesn't degrades after we migrate. I would like to check and compare all configurations ( Sever  as well as DB level) on two machines. can someone help with quick sql script which I can ran on both machines and see if there is any differences?



    Monday, July 6, 2020 3:41 AM

All replies

  • is this a better way to do this?


    SELECT *
    FROM sys.configurations
    ---where value_in_use = 1
    ORDER BY name ;

    Monday, July 6, 2020 4:25 AM
  • How do you migrate your dbs?

    Use DMA or other migration tools?

    Tuesday, July 7, 2020 7:15 AM
  • No I just did a simple restore with backup of old DB.
    Wednesday, July 8, 2020 12:27 AM
  • Hi 

    If you wnant to compare the difference after restore in one new version,please monitor the performacne with Qury Store.

    Helpful information: query-store-usage-scenarios



    Wednesday, July 8, 2020 6:43 AM
  • Hi SSIS123,

    Is the reply helpful?



    Thursday, July 9, 2020 1:27 AM
  • Hi,

    I'm following this open case and is the issue solved?

    You can choose to mark the helpful reply as answer  to close this case.



    Friday, July 24, 2020 9:26 AM