[DW] Addressing the Challenges of Data Warehouse Upgrades and Migrations

Upgrading data warehouse solutions can be a daunting proposition. With different data warehouse engines, numerous complex SSIS packages and customised components the scope of work can be complex and overwhelming.

In this session we will discuss the challenges faced by organisations upgrading and migrating SQL Server BI platforms and how to address them.

If your SQL Server BI Platform is out of mainstream support then your organisation needs to upgrade and migrate to a later version of the SQL server BI platform.

In this session we will cover:

• Lift and shift migration strategies

• Platform Migration strategies

• Azure

• Parallel Data Warehouse

• How to standardise your Codebase

• Upgrade Custom Components and Third Party Components

• How to utilise the new features in SQL Server 2012 and 2014

• Integration Services Catalog

• Why the Upgrade wizard does not always work

If you are faced with an upgrade and migration project then this session is for you!