This has been in beta for a while, the key thing lacking for our uses, at least with postgres, was full support for DDL.
The lack of "true" replication into postgres RDS instances is one of the things blocking us from fully using it.
AWS Database Migration Service
11–20 of 67 posts
Re: AWS Database Migration Service
#12Re: AWS Database Migration Service
#13How do you back all this stuff up?
Re: AWS Database Migration Service
#14Why is Amazon Redshift not a target for this service?
Re: AWS Database Migration Service
#15What are my chances of a relatively successful SQL Server migration with several hundred tables and complex views to PostgreSQL using their migration tool?
Re: AWS Database Migration Service
#16Earlier quoted context omitted.
Not unless you're ready to try to create a physical host replica, and then fail over to it as a master during downtime.
Is it possible to run a read replica outside of RDS these days?
I don't see why not. Replication is just a command stream over a network. You can secure it over the daabsse's built in TLS support or over VPN. The only question is bandwidth and latency between your DC and AWS's.
Re: AWS Database Migration Service
#17Why is Amazon Redshift not a target for this service?
Syncing to redshift for reporting is a somewhat different use case - you don't always want to sync everything, you want to sync in larger batches, the "migration" never ends.
There are several startups that will do this for you, including mine (Fivetran).
Re: AWS Database Migration Service
#18The truly interesting thing to me about this product is the pricing. Competitors in this space sell software starting at ~$5,000 all the way up into 5, and I presume 6 figures. AWS is giving away their software and only charging for the hardware to run this migration software on. The catch is that you need to be migrating to AWS resources which you are paying for. I'm sure this tool will have less features than the m…
The lock-in is where the catch is right.
Re: AWS Database Migration Service
#19The truly interesting thing to me about this product is the pricing. Competitors in this space sell software starting at ~$5,000 all the way up into 5, and I presume 6 figures. AWS is giving away their software and only charging for the hardware to run this migration software on. The catch is that you need to be migrating to AWS resources which you are paying for. I'm sure this tool will have less features than the m…
The lock-in is where the catch is right.
There's not a whole lot of lock-in using an rds instance. It's MySQL.
Re: AWS Database Migration Service
#20Earlier quoted context omitted.
Not unless you're ready to try to create a physical host replica, and then fail over to it as a master during downtime.
Is it possible to run a read replica outside of RDS these days?
Some RDS flavors now support offsite replication, it's quite easy to set up.