Home > Case Studies > Migration Playbook Makes SQL Server Upgrade a Success

Migration Playbook Key To Online Retailers SQL Server Upgrade

This global online retailer was past due for a large-scale SQL Server upgrade project. With numerous mission critical website databases to upgrade, the lean on IncWorx to develop a Migration Playbook to get them moved.

Industry

Online Retailer

Technology

SQL Server

Employees

1001-5000

Challenge

This global online retailer was past due for a large-scale SQL Server upgrade project. They were specifically interested in working with an organization that had a history with and knew how to upgrade SQL Server 2008 R2 to 2014. Additionally, they were looking for guidance that included mapping out detailed system test plans to ensure all applications functioned properly. These applications included several websites, a Great Plains instance and multiple Excel/VBA-based reports. Upgrading to SQL Server 2014 would also provide improved features and functionality important to their continued growth.

The customer’s team provided some key requirements, which included:

  • A well-developed strategic plan that would pass an internal review
  • Architecture and build out of updated SQL Server staging and production environments
  • Development and execution of detailed system test plans
  • Project management efforts, given the complex technical nature of the project

Solution

IncWorx architected and designed two brand new SQL Server environments. The first would serve as a staging environment and the second served as a production environment complete with Failover Clustering capabilities. Once the configuration was complete, our team went to work migrating and testing the data. Over the course of multiple test upgrades, a Migration Playbook was created. This playbook was a step-by-step checklist that would ensure the final cutover was thorough and accurate. Highlights of the project include:

  • Setup and configuration of new Staging and Production environments
    • SQL Server installation
    • Setup of Failover Cluster Instance
  • Migration of users and jobs via scripts
  • Development of a Migration Playbook
  • Development of detailed test plans to test key functionality with each application/system that touches the database server

Result

As a result of the SQL Server upgrade, this retailer eliminated one of their greatest IT risks. The new SQL environment – full of accurately migrated data – provided high availability and redundancy that did not previously exist. Additionally, the improved features of SQL Server 2014 meant they could continue to serve the needs of their internal and external customers.

Conclusion

It is important to keep your SQL Server environment updated to the latest platform available. Keeping your environment current means stability, improved features and functionality and most importantly upgraded security. A new environment meant this online retailer could focus their customers and not worry that their data technology could not keep up with the ever-changing demands and growth. With the right process and expertise, a SQL Server upgrade will not be scary it will be a smooth process that offers nothing but benefit.

Want to learn more?

This is just one of the many solutions IncWorx has delivered for our customers.

To learn more about this or other solutions we’ve delivered, please contact us today.

[wpforms id="1422"]
<div class="wpforms-container wpforms-container-full" id="wpforms-1422"><form id="wpforms-form-1422" class="wpforms-validate wpforms-form" data-formid="1422" method="post" enctype="multipart/form-data" action="/case-studies/sql-server-upgrade-online-retailer" data-token="563a68a352dfd4eab659a741d7367a69"><noscript class="wpforms-error-noscript">Please enable JavaScript in your browser to complete this form.</noscript><div class="wpforms-field-container"><div id="wpforms-1422-field_0-container" class="wpforms-field wpforms-field-name" data-field-id="0"><label class="wpforms-field-label" for="wpforms-1422-field_0">Full Name <span class="wpforms-required-label">*</span></label><input type="text" id="wpforms-1422-field_0" class="wpforms-field-large wpforms-field-required" name="wpforms[fields][0]" required></div><div id="wpforms-1422-field_1-container" class="wpforms-field wpforms-field-email" data-field-id="1"><label class="wpforms-field-label" for="wpforms-1422-field_1">Email <span class="wpforms-required-label">*</span></label><input type="email" id="wpforms-1422-field_1" class="wpforms-field-large wpforms-field-required" name="wpforms[fields][1]" required></div><div id="wpforms-1422-field_3-container" class="wpforms-field wpforms-field-phone" data-field-id="3"><label class="wpforms-field-label" for="wpforms-1422-field_3">Phone <span class="wpforms-required-label">*</span></label><input type="tel" id="wpforms-1422-field_3" class="wpforms-field-large wpforms-field-required wpforms-masked-input" data-inputmask="&#039;mask&#039;: &#039;(999) 999-9999&#039;" data-rule-us-phone-field="true" data-inputmask-inputmode="tel" name="wpforms[fields][3]" required></div><div id="wpforms-1422-field_2-container" class="wpforms-field wpforms-field-textarea" data-field-id="2"><label class="wpforms-field-label" for="wpforms-1422-field_2">How can we help you? <span class="wpforms-required-label">*</span></label><textarea id="wpforms-1422-field_2" class="wpforms-field-small wpforms-field-required" name="wpforms[fields][2]" required></textarea></div><div id="wpforms-1422-field_15-container" class="wpforms-field wpforms-field-html" data-field-id="15"><div id="wpforms-1422-field_15"><p style="padding-top: 10px; padding-bottom: 10px; font-family: 'Open Sans', sans-serif; font-size: 10px; color: #333333;">By clicking the button below, you are agreeing to our <span style="text-decoration: underline;"><span style="color: #000000;"><a style="color: #000000; text-decoration: underline;" href="https://www.incworx.com/privacy-policy">Privacy Policy</a></span></span>.</p></div></div><div id="wpforms-1422-field_7-container" class="wpforms-field wpforms-field-hidden" data-field-id="7"><input type="hidden" id="wpforms-1422-field_7" name="wpforms[fields][7]" value="Migration Playbook Makes SQL Server Upgrade a Success"></div><div id="wpforms-1422-field_9-container" class="wpforms-field wpforms-field-hidden" data-field-id="9"><input type="hidden" id="wpforms-1422-field_9" name="wpforms[fields][9]" value="85.208.98.29"></div><div id="wpforms-1422-field_10-container" class="wpforms-field wpforms-field-hidden" data-field-id="10"><input type="hidden" id="wpforms-1422-field_10" name="wpforms[fields][10]"></div></div><div class="wpforms-field wpforms-field-hp"><label for="wpforms-1422-field-hp" class="wpforms-field-label">Message</label><input type="text" name="wpforms[hp]" id="wpforms-1422-field-hp" class="wpforms-field-medium"></div><div class="wpforms-submit-container" ><input type="hidden" name="wpforms[id]" value="1422"><input type="hidden" name="wpforms[author]" value="2"><input type="hidden" name="wpforms[post_id]" value="8556"><button type="submit" name="wpforms[submit]" class="wpforms-submit " id="wpforms-submit-1422" value="wpforms-submit" aria-live="assertive" data-alt-text="Sending..." data-submit-text="Submit">Submit</button></div></form></div> <!-- .wpforms-container -->