{"id":148,"date":"2019-03-12T14:53:00","date_gmt":"2019-03-12T09:23:00","guid":{"rendered":"https:\/\/opstree.com\/blog\/\/?p=148"},"modified":"2019-09-18T16:42:10","modified_gmt":"2019-09-18T11:12:10","slug":"migrate-your-data-between-various-databases","status":"publish","type":"post","link":"https:\/\/opstree.com\/blog\/2019\/03\/12\/migrate-your-data-between-various-databases\/","title":{"rendered":"Migrate your data between various Databases"},"content":{"rendered":"
\n
\n

Data Migration Service<\/h2>\n<\/div>\n
\n
\n
 <\/div>\n
\n
Have you ever thought about migrating your production database from one platform to another<\/div>\n<\/div>\n<\/div>\n
\n
\n
and dropped this idea later, because it was too risky, <\/span>you were not ready to <\/span><\/div>\n
bare a downtime? <\/span><\/div>\n<\/div>\n<\/div>\n
\n
\n
If yes, then please pay attention because this is what we are going to perform
in this article.<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
A few days back we\u2019re trying to migrate our production MySQL RDS from AWS to GCP,  SQL, and we had to migrate data <\/span>without downtime, accurate and
real-time and that too without the help <\/b><\/span>of any Database Administrator.<\/b><\/div>\n<\/div>\n<\/div>\n
\n
\n
 <\/div>\n<\/div>\n<\/div>\n
\n
\n
After doing a bit research and evaluating few services we finally started working on AWS DMS <\/a>(Data Migration Service) <\/span>and figured out this is a great service to migrate a
different kind of data. <\/span><\/div>\n<\/div>\n<\/div>\n
\n
\n
 <\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n
You can migrate your data to and from the most widely used commercial and open-source databases, and database platforms. Databases like<\/span> Oracle, Microsoft SQL Server, and
PostgreSQL, MongoDB.<\/span><\/div>\n<\/div>\n
\n
The source database remains fully <\/span>operational during the migration,<\/span>
The service supports <\/span>homogeneous <\/span>migrations such as Oracle to Oracle,
<\/span>and also heterogeneous migrations between <\/span>different database platforms.<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
 <\/div>\n<\/div>\n<\/div>\n
\n

Let\u2019s discuss some important features of AWS DMS:<\/h4>\n
 <\/div>\n