From the course: Data Warehousing on Google Cloud Platform

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Data migration

Data migration - Google Cloud Platform Tutorial

From the course: Data Warehousing on Google Cloud Platform

Start my 1-month free trial Buy for my team

Data migration

“

- [Instructor] Let's talk about a few cloud database migration options and some proper use cases. Let's say you already have a database solution that is working well. It's hosted on-premise or through another cloud provider. You'd like to take advantage of the scalability and the availability of cloud-based solutions or you're looking to integrate with other Google Cloud services. In this case, we'll want to just move the database over instead of starting all over again. This is known as lift and shift. Google Cloud Database Migration Service can migrate PostgreSQL and MySQL databases to Google Cloud. Within the web UI, you can create a new database migration job using the database migration API. In the search bar, type in data migration. Let's click here. You'll have to enable the data migration API. First, you'll have to define the connection profiles. This defines the connection profiles to your source data. Click on create migration job. These jobs can be set up to run one time or…

Contents