Migrating to SQL Server 2017

ow do you design and implement a safe and successful migration from an older version of SQL Server to SQL Server 2017 with no data loss and virtually no downtime? What if you have a limited hardware budget for the upgrade effort and you are worried about the core-based licensing in SQL Server 2017? How can you choose your hardware wisely in light of the new licensing model? How can you convince your organization that the time is right to upgrade to SQL Server 2017? This session will cover several different methods for migrating your data to SQL Server 2017 while meeting these objectives and minimizing your hardware and licensing costs. You will also learn how to help make the case that a complete data platform upgrade makes excellent sense from a business perspective. You will also learn how to do effective capacity planning for the new environment to ensure that you have the best performance possible with a manageable SQL Server 2017 licensing cost.

Glenn Berry works as a principal consultant at SQLskills in Elizabeth, CO. He is a Data Platform MVP and has a collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests! His expertise includes DMVs, high availability, hardware selection, and storage subsystems. Glenn is also an adjunct faculty member at University College – University of Denver, where he has taught since 2000.

Nguồn: https://kuherbal.com/

Xem thêm bài viết khác: https://kuherbal.com/category/cong-nghe


  1. I want to migrate from SQL Server 2017 to Oracle 18c with RAC and Dataguard.

  2. Would I still need to update the Service pack if I'm migrating to SQL 2017 onto a new machine running Windows Server 2016? Currently on SQL 2008R2 on Windows Server 2008R2.

  3. One migration method that wasn't mentioned was joining 2017 servers to an existing AlwaysOn availability group. Is that something you can comment on? Is it just as simple as adding them to the group, and then making that server the primary?

Leave a Reply

Your email address will not be published. Required fields are marked *