Databasmigration från SQL Server till Amazon Redshift

Sammanfattning: Growing databases create a need for improved storage and analysis solutions. One company with that need is Bring SCM, who have been looking for a solution to better analyze their business data, which is currently hosted on a SQL Server-database by Elastic Mobile. To improve this solution, this paper will examine a data warehouse solution to the problem, specifically using the cloud-based Amazon Redshift data warehouse. Additionally, Amazon’s Database Migration Service will be examined as an alternative to the current migration solution. For Database Migration Service, both the migration of the full database as well as the continuous data replication are tested. Redshift is tested based on performance for eight SQL statements that Bring SCM currently use in their work. This is performed both on a storage-optimized cluster and a computation-optimized one. Finally, the costs of running the different clusters are used to evaluate the cost-effectiveness of the solutions. Database Migration Service showed great potential compared to the current migration solution, and the storage-optimized Redshift-cluster gave both good performance and cost-efficiency. The computation-optimized cluster performed worse than expected, especially in relation to the cost. Redshift and Database Migration Service are very promising alternatives to the current SQL Server-solution for analysis purposes, but when implementing such a system, consideration should be taken regarding optimizing the data structure for data warehouse use.