{"id":25946,"date":"2016-03-16T10:45:11","date_gmt":"2016-03-16T08:45:11","guid":{"rendered":"https:\/\/mamchenkov.net\/wordpress\/?p=25946"},"modified":"2016-03-16T10:45:11","modified_gmt":"2016-03-16T08:45:11","slug":"aws-database-migration-service","status":"publish","type":"post","link":"https:\/\/mamchenkov.net\/wordpress\/2016\/03\/16\/aws-database-migration-service\/","title":{"rendered":"AWS Database Migration Service"},"content":{"rendered":"\n

\"AWS<\/a><\/p>\n

AWS Database Migration Service<\/a> is yet another one of those tools that you always wished that somebody created, but never actually got to checking if it exists. \u00a0Here is a recent blog post<\/a> showcasing the functionality.<\/p>\n

Do you currently store relational data in an on-premises Oracle, SQL Server, MySQL, MariaDB, or PostgreSQL database? Would you like to move it to the AWS cloud with virtually no downtime so that you can take advantage of the scale, operational efficiency, and the multitude of data storage options that are available to you?<\/p>\n

If so, the new AWS Database Migration Service<\/a> (DMS) is for you! First announced last fall at AWS re:Invent<\/a>, our customers have already used it to migrate over 1,000 on-premises databases to AWS. You can move live, terabyte-scale databases to the cloud, with options to stick with your existing database platform or to upgrade to a new one that better matches your requirements.\u00a0 If you are migrating to a new database platform as part of your move to the cloud, the AWS Schema Conversion Tool<\/a> will convert your schemas and stored procedures for use on the new platform.<\/p><\/blockquote>\n\n","protected":false},"excerpt":{"rendered":"\n

AWS Database Migration Service is yet another one of those tools that you always wished that somebody created, but never actually got to checking if it exists. \u00a0Here is a recent blog post showcasing the functionality. Do you currently store relational data in an on-premises Oracle, SQL Server, MySQL, MariaDB, or PostgreSQL database? Would you … Continue reading AWS Database Migration Service<\/span><\/a><\/p>\n\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"AWS Database Migration Service #AWS #SysAdmin #hosting #database #WebWork","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_links_to":"","_links_to_target":""},"categories":[1,133,62,1334],"tags":[3270,1559,1330,2289],"keyring_services":[],"class_list":["post-25946","post","type-post","status-publish","format-standard","hentry","category-general","category-sysadmin","category-technology","category-web-work","tag-amazon-aws","tag-databases","tag-web-development","tag-web-hosting"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":25090,"url":"https:\/\/mamchenkov.net\/wordpress\/2015\/12\/28\/5-aws-mistakes-you-should-avoid\/","url_meta":{"origin":25946,"position":0},"title":"5 AWS mistakes you should avoid","author":"Leonid Mamchenkov","date":"December 28, 2015","format":false,"excerpt":"\"5 AWS mistakes you should avoid\" is a rather opinionated piece on what you should and shouldn't do with your infrastructure, especially, when using AWS. \u00a0Here's an example: A typical web application consists of at least: load balancer scalable web backend database and looks like the following figure. This pattern\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"typical-web-application","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2015\/12\/typical-web-application-500x298.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":27030,"url":"https:\/\/mamchenkov.net\/wordpress\/2016\/12\/01\/amazon-snowmobile-a-truck-with-up-to-100-petabytes-of-storage\/","url_meta":{"origin":25946,"position":1},"title":"Amazon Snowmobile – a truck with up to 100 Petabytes of storage","author":"Leonid Mamchenkov","date":"December 1, 2016","format":false,"excerpt":"Back in my college days, I had a professor who frequently used Andrew Tanenbaum's quote in the networking class: Never underestimate the bandwidth of a station wagon full of tapes hurtling down the highway. I guess he wasn't the only one, as during this year's Amazon re:Invent 2016 conference, the\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"aws-snowmobile","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2016\/12\/AWS-Snowmobile-500x313.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":28504,"url":"https:\/\/mamchenkov.net\/wordpress\/2018\/04\/20\/registry-of-open-data-on-aws\/","url_meta":{"origin":25946,"position":2},"title":"Registry of Open Data on AWS","author":"Leonid Mamchenkov","date":"April 20, 2018","format":false,"excerpt":"AWS News Blog covers the Registry of Open Data on AWS: Almost a decade ago, my colleague Deepak Singh introduced the AWS Public Datasets in his post\u00a0Paging Researchers, Analysts, and Developers. I\u2019m happy to report that Deepak is still an important part of the AWS team and that the Public\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/04\/aws-open-data-500x333.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":28416,"url":"https:\/\/mamchenkov.net\/wordpress\/2018\/02\/27\/7-ways-to-do-containers-on-aws\/","url_meta":{"origin":25946,"position":3},"title":"7 ways to do containers on AWS","author":"Leonid Mamchenkov","date":"February 27, 2018","format":false,"excerpt":"\"7 ways to do containers on AWS\" covers a variety of different ways to run containers on the Amazon AWS cloud infrastructure.\u00a0 These include most of the usual suspects, like Amazon Elastic Container Service (ECS), Amazon Elastic Container Service for Kubernetes (EKS), and hand-rolled vanilla containers on EC2, as well\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/02\/amazon-containers-500x250.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":28187,"url":"https:\/\/mamchenkov.net\/wordpress\/2017\/11\/06\/how-did-you-significantly-reduce-your-aws-cost\/","url_meta":{"origin":25946,"position":4},"title":"How did you significantly reduce your AWS cost?","author":"Leonid Mamchenkov","date":"November 6, 2017","format":false,"excerpt":"This Hacker News thread is full of tips, tricks, and references to reducing Amazon AWS costs.\u00a0 There is plenty of good advice from cleaning up the data and releasing unused resources, to monitoring the reserved instances usage, to moving data from elastic volumes to the Amazon S3 for cheaper storage\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":28969,"url":"https:\/\/mamchenkov.net\/wordpress\/2018\/11\/12\/using-aws-cli-query-option-to-simplify-output\/","url_meta":{"origin":25946,"position":5},"title":"Using aws-cli –query Option To Simplify Output","author":"Leonid Mamchenkov","date":"November 12, 2018","format":false,"excerpt":"Eric Hammond shares a super-handy tip for those of us who work with Amazon AWS via the command line: I just learned about a recent addition to aws-cli: The\u00a0--query\u00a0option lets you specify what parts of the response data structure you want output. Instead of wading through pages of JSON output,\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/25946","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/comments?post=25946"}],"version-history":[{"count":0,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/25946\/revisions"}],"wp:attachment":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/media?parent=25946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/categories?post=25946"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/tags?post=25946"},{"taxonomy":"keyring_services","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/keyring_services?post=25946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}