AWS Database Migration Service Primary Use Case

Prashant Sukhe - PeerSpot reviewer
Sr Director / Architect at a computer software company with 201-500 employees

We used the solution for live replication but faced many access challenges. We moved to make a full copy and then use column-level filtering to achieve incremental load. Over time, we get the necessary access permissions, allowing us to switch to live replication. We experienced a delay of roughly two minutes, which was not an issue for our use case.

View full review »
Ram-Krishnan - PeerSpot reviewer
Data engineer architect at Freelance

We were using the solution for the migration and replication of data.

View full review »
Shady Mogawer - PeerSpot reviewer
IT Manager at Arabian Cement Company

My company uses AWS Database Migration Service as a small data warehouse.

View full review »
Buyer's Guide
AWS Database Migration Service
April 2024
Learn what your peers think about AWS Database Migration Service. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,578 professionals have used our research since 2012.
IrshadAhamed - PeerSpot reviewer
Business Proces Specialist at a manufacturing company with 5,001-10,000 employees

Currently, in our company, we use the product as a part of our strategy since we recently got involved in the area of migration.

I use AWS Database Migration Service in my company for whatever applications are developed on an on-premises infrastructure since such applications have fewer scalability features when compared to the cloud. Suppose you move the applications to the cloud. In that case, the scalability can be very high, and the number of users who are going to use the product can be controlled. AWS should develop an industry-competent product so that its users can compete with other technologies and companies.

View full review »
Didar Moldabekov - PeerSpot reviewer
Senior Database Administrator at Overonix Technologies

All of our infrastructure is on Amazon, so we used AWS Database Migration Service to perform a database migration from one relational database to another within the AWS cloud. The migration was from an Oracle database to PostgreSQL database, and AWS DMS helped us transfer all the tables and other objects from the one database to the other automatically.

View full review »
Mikael Kohlmyr - PeerSpot reviewer
Engineering Manager / Lead Software Engineer at a tech vendor with 11-50 employees

We use this solution for change data capture (CDC). Essentially turning PostgreSQL (RDS) database commits into an event source for triggering other services via an event streaming solution.

View full review »
HW
Director at Fujitsu

We primarily use the solution to migrate databases. 

We have an Oracle database on-premise, and then we have a plan to install the new system with a database for another application service. Therefore, we need to duplicate, to copy, our Oracle database to the Postgres database on AWS. 

View full review »
Shreyank Vyavahare - PeerSpot reviewer
Data Engineering Manager at a consumer goods company with 201-500 employees

We use this solution to get our data into Lakehouse with the CDC. So, Change Data Capture is also very important for us. AWS Database Migration Service has an inbuilt functionality for capturing change data.

The identifier of this solution informs us whether it's an insert operation, an update operation, or a delete operation. Since our main data is OLTP, the status of the order can keep changing; it can easily go from payment to successful and resend to cancel. 

View full review »
SR
Senior Technical Analyst

We have taken that as a Platform as a Service. So, how we are running here, we just migrated whatever database instance in the rack was there to AWS. It was an "as-it-is" migration. 

For data, we tried to use SSIS to transfer the data from the patch to AWS.

View full review »
ZC
Principal DBA at LendingClub

We looked for Oracle to Aurora conversion migrations. This has two parts, one is called the static table schema migrations, which is a one-time snapshot that we just stamp and load. The other is the CDC replications, or real-time streaming replications, heterogeneously from Oracle to Aurora. 

View full review »
Consolador Daroy - PeerSpot reviewer
Development Team Manager/Chief Solutions Architect at a consultancy with 11-50 employees

We're currently moving our whole database from AWS to Oracle. We want to avoid interrupting production systems, so we're using DMS to continuously replicate data from the AWS RDS database to the Oracle database in OCI. Once we're sure all data is consistent, we'll switch over to Oracle and shut down the AWS database.

This should minimize downtime to about 15 minutes, and all our services in AWS then point to the Oracle database.

View full review »
JB
Senior Cloud Admin at Brillio

We use this solution to enable us to carry out heavy, data-level migrations across multiple ETL tools.

View full review »
SC
Software Engineer at a financial services firm with 10,001+ employees

I'm using AWS Database Migration Service for migrating data from an on-premise Oracle database to a database on AWS.

View full review »
StevenLai - PeerSpot reviewer
Sr. Data Engineer at a real estate/law firm with 1,001-5,000 employees

We are moving everything to the cloud and we need a migration service to migrate our on-premise data warehouse to the cloud and this is what we use AWS Database Migration Service for.

View full review »
KK
Software architect at a computer software company with 51-200 employees

The tool is offered as part of AWS stacks. We use it for data migrations from on-premise to AWS stack via PostgreSQL and MySQL. We also use it for the infrastructure configuration to simplify the setup because we are going on RDS. The AWS platform will manage everything. We use it for the simplification of migration. We do not do a lot of study on how exactly to map the database provisioning.

View full review »
VishalSharma2 - PeerSpot reviewer
Infrastructure Lead at a computer software company with 51-200 employees

We've used the product for database migration from on-prem to AWS for an Oracle database.

View full review »
JoshuaEfienokwu - PeerSpot reviewer
Cloud Engineer at a tech services company with 10,001+ employees

I am using AWS Database Migration Service for migrations and relationship migrations.

View full review »
Adnan Shafiq - PeerSpot reviewer
Associate Vice President - Database Management (Principal Solutions Architect) at Northbay

We utilize it for mostly heterogeneous migration when you are migrating from one RDBMS platform to another. Obviously, we can use it for homogeneous migrations as well. However, it really comes in handy when you are migrating from the same source platform to the same destination. 

You get a lot of other options for migration, for example, you get different types of backups. You get the option for the native replication being supported by the RDBMS engines. However, when you are migrating from one platform to another platform, which is a heterogeneous case, you need some kind of Golden Gate, CDC, and all that. DMS with heterogeneous migration is, therefore, really very handy, particularly with data transformation and migration use cases.

View full review »
SR
Principal engineer at a tech vendor with 10,001+ employees

We have a database team that supports migrations to public, private, and hybrid clouds depending on the client's needs.

View full review »
SP
Digital Services & Engagement Senior Manager at a insurance company with 10,001+ employees

Our primary use case is that I can easily automate. I don't want many resources working on setting up a new IDE and creating an application and so on. We can make use of the existing applications in the cloud and I can do a workflow management very easily.

View full review »
VinodKumar9 - PeerSpot reviewer
Data Analyst at a tech services company with 51-200 employees

AWS Database Migration Service is a very useful tool for our organization. One example of how we use it is when we need to save the data to ensure we don't lose it. To eradicate this risk, we save the database where we can extract it through commands. We can do a lot of with just simple commands that will assist in accessing the data with ease.

Also, we can select from the API where we will use the data connections to the API where the client can easily access the data. At the day's end, we set some data from our website and view the API connection to the ABL link to the client. They can access that data to the API and the database will give the function and connect.

View full review »
AQ
Senior Solutions Architect at DBSolution

I use AWS Database Migration Service to migrate Oracle databases and PostgreSQL databases. I work with both databases and work with different migration scenarios.

View full review »
JS
Lead Oracle Developer and DevOps Engineer at Versent

We are using the solution for a database migration.

View full review »
DB
Net Full-Stack developer at a tech services company with 201-500 employees

We don't use Data Migration Services regularly. We only use it when we need to migrate a relatively large database from on-premises to the cloud. From my point of view, it was the best option in this case.

View full review »
RC
Consultant Architect at a tech services company with 10,001+ employees

We use this program to migrate from SQL to RDS, or from Oracle to RDS, or from Oracle to Aurora and so on.

View full review »
it_user1171743 - PeerSpot reviewer
Tech Lead at a tech services company with 201-500 employees

We're primarily using the solution to migrate our archive and data, which we are storing in our local servers, to the cloud.

View full review »
Buyer's Guide
AWS Database Migration Service
April 2024
Learn what your peers think about AWS Database Migration Service. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,578 professionals have used our research since 2012.