1
00:00:00,260 --> 00:00:01,830
‫So we have seen in this section

2
00:00:01,830 --> 00:00:04,140
‫so many different database technologies

3
00:00:04,140 --> 00:00:06,020
‫and the question is how do you migrate data

4
00:00:06,020 --> 00:00:07,660
‫from one database to another?

5
00:00:07,660 --> 00:00:10,820
‫For this we can use DMS which is properly named

6
00:00:10,820 --> 00:00:13,020
‫the Database Migration Service.

7
00:00:13,020 --> 00:00:15,770
‫So we use source database and once we extract the data

8
00:00:15,770 --> 00:00:17,300
‫so we'll run an EC2 instance

9
00:00:17,300 --> 00:00:19,130
‫that will be running the DMS software.

10
00:00:19,130 --> 00:00:21,190
‫We'll extract the data from the source database

11
00:00:21,190 --> 00:00:23,900
‫and then DMS will insert the data back

12
00:00:23,900 --> 00:00:26,760
‫into a target database that will be somewhere else.

13
00:00:26,760 --> 00:00:30,650
‫So with DMS we get a quick and secure database migration

14
00:00:30,650 --> 00:00:34,220
‫into AWS that's going to be resilient and self healing.

15
00:00:34,220 --> 00:00:35,970
‫And the cherry on the cake,

16
00:00:35,970 --> 00:00:38,900
‫the source database remains available during the migration

17
00:00:38,900 --> 00:00:40,810
‫so we don't have to take it down.

18
00:00:40,810 --> 00:00:43,040
‫It supports many kinds of migration.

19
00:00:43,040 --> 00:00:45,960
‫So one it's called an homogeneous migration

20
00:00:45,960 --> 00:00:47,880
‫where you have Oracle to Oracle for example.

21
00:00:47,880 --> 00:00:51,340
‫So it's the same database technology for the source database

22
00:00:51,340 --> 00:00:53,100
‫and the target database.

23
00:00:53,100 --> 00:00:55,780
‫Or it supports heterogeneous migrations

24
00:00:55,780 --> 00:00:57,370
‫when the source database technology

25
00:00:57,370 --> 00:00:59,790
‫and the target are different for example

26
00:00:59,790 --> 00:01:02,220
‫a Microsoft SQL Server to Aurora.

27
00:01:02,220 --> 00:01:04,550
‫And in that case, DMS is smart enough

28
00:01:04,550 --> 00:01:06,590
‫to know how to convert data

29
00:01:06,590 --> 00:01:08,910
‫from the source into the target.

30
00:01:08,910 --> 00:01:12,980
‫So any time in the exam you see migration of a database,

31
00:01:12,980 --> 00:01:14,820
‫DMS is going to be the answer for it.

32
00:01:14,820 --> 00:01:15,930
‫I hope that was helpful

33
00:01:15,930 --> 00:01:17,880
‫and I will see you in the next lecture.