Post reply

Migrating a database from standard to enterprise Edition?

  • July 20, 2018 at 8:36 am

    #354823

    Hi,

    Source : Sqlserver2008 Standard Edition
    Destination: Sqlserver2016 Enterprise Edition 

    Can database migrate from Sqlserver2008 standard    to      Sqlserver2016 enterprise Edition? What is the best way .

    Thank you.

  • July 20, 2018 at 8:42 am

    #1998418

    adisql - Friday, July 20, 2018 8:36 AM

    Hi,

    Source : Sqlserver2008 Standard Edition
    Destination: Sqlserver2016 Enterprise Edition 

    Can database migrate from Sqlserver2008 standard    to      Sqlserver2016 enterprise Edition? What is the best way .

    Thank you.

    Yes you can migrate from 2008 Standard to 2016 Enterprise. I would do a straightforward backup and restore from one to the other but make sure you do plenty of performance testing before going into production and 2016 can/does perform differently from 2008.

    Thanks

  • July 20, 2018 at 8:48 am

    #1998422

    NorthernSoul - Friday, July 20, 2018 8:42 AM

    adisql - Friday, July 20, 2018 8:36 AM

    Hi,

    Source : Sqlserver2008 Standard Edition
    Destination: Sqlserver2016 Enterprise Edition 

    Can database migrate from Sqlserver2008 standard    to      Sqlserver2016 enterprise Edition? What is the best way .

    Thank you.

    Yes you can migrate from 2008 Standard to 2016 Enterprise. I would do a straightforward backup and restore from one to the other but make sure you do plenty of performance testing before going into production and 2016 can/does perform differently from 2008.

    Thanks

    Thank you ..

  • July 20, 2018 at 9:18 am

    #1998435

    adisql - Friday, July 20, 2018 8:48 AM

    NorthernSoul - Friday, July 20, 2018 8:42 AM

    adisql - Friday, July 20, 2018 8:36 AM

    Hi,

    Source : Sqlserver2008 Standard Edition
    Destination: Sqlserver2016 Enterprise Edition 

    Can database migrate from Sqlserver2008 standard    to      Sqlserver2016 enterprise Edition? What is the best way .

    Thank you.

    Yes you can migrate from 2008 Standard to 2016 Enterprise. I would do a straightforward backup and restore from one to the other but make sure you do plenty of performance testing before going into production and 2016 can/does perform differently from 2008.

    Thanks

    Thank you ..

    Also, i think it would be nice if you could do some stress on the luns, mount points or where you will be storing your data files.
    You could try using diskspd that will give you some diagnostics on performance issues or disk issues  these tools are provided for free from Microsoft.
    https://github.com/microsoft/diskspd

  • July 20, 2018 at 11:27 am

    #1998457

    Alejandro Santana - Friday, July 20, 2018 9:18 AM

    adisql - Friday, July 20, 2018 8:48 AM

    NorthernSoul - Friday, July 20, 2018 8:42 AM

    adisql - Friday, July 20, 2018 8:36 AM

    Hi,

    Source : Sqlserver2008 Standard Edition
    Destination: Sqlserver2016 Enterprise Edition 

    Can database migrate from Sqlserver2008 standard    to      Sqlserver2016 enterprise Edition? What is the best way .

    Thank you.

    Yes you can migrate from 2008 Standard to 2016 Enterprise. I would do a straightforward backup and restore from one to the other but make sure you do plenty of performance testing before going into production and 2016 can/does perform differently from 2008.

    Thanks

    Thank you ..

    Also, i think it would be nice if you could do some stress on the luns, mount points or where you will be storing your data files.
    You could try using diskspd that will give you some diagnostics on performance issues or disk issues  these tools are provided for free from Microsoft.
    https://github.com/microsoft/diskspd

    Thank you..

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply