Migration Playbook Key To Online Retailers SQL Server UpgradeThis 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.
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
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
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.
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.