AWS For Admins For Dummies

Chapter 11

Moving Data Using Database Migration Service

IN THIS CHAPTER

Defining the Database Migration Service (DMS) feature set

Managing data movement between homogenous databases

Managing data movement between heterogeneous databases

Moving data between databases is an essential administration task. You can find all sorts of reasons to move data. Some of the most common reasons are

• Changing the database vendor
• Creating a common platform for all elements of an organization
• Upgrading to obtain an improved feature set
• Changing platforms (such as moving from a corporate server to the cloud)

Many other reasons exist for moving data, but the essential goal is to make data available to end users. If you consider all the kinds of data movement for a moment, you find that user needs trump everything else. Even data analysis boils down to serving a user need in some respect, such as the creation of recommender systems to help improve sales or productivity by predicting other choices that the user might want to have from a complex list of choices. The first section of this chapter helps you understand how the Amazon Web Services (AWS) Database Migration Service (DMS) improves your capability ...