{"id":163,"date":"2017-05-24T11:36:02","date_gmt":"2017-05-24T05:36:02","guid":{"rendered":"https:\/\/intentwise.com\/blog\/?p=163"},"modified":"2024-02-06T06:27:02","modified_gmt":"2024-02-06T14:27:02","slug":"database-migration","status":"publish","type":"post","link":"https:\/\/www.intentwise.com\/blog\/technology\/database-migration\/","title":{"rendered":"Database Migration","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>It&#8217;s a great place to be when your initial platform is ready to scale and having performance issues. This clearly shows that we are growing and in the process making the right decisions in choosing and building our platform. One of our data sore is PostgresSQL hosted on AWS through our provider <a href=\"https:\/\/www.elephantsql.com\/\">elephantsql<\/a>. We have been quite happy with this provider as they met our needs during the early stages and continue to do so. We will continue to leverage them in the future. However, one of the key issues is the growth of our data and the amount of cost involved to pay for that infrastructure. We feel that pay per use model of clouds is a perfect companion for startups.<\/p>\n<p>We are building a new platform for which we feel that a solution like a Redshift makes a great sense. So if we have to migrate some of our data into this new DB how do we go about it? There are 2 approaches<\/p>\n<ul>\n<li>Use the standard approach of backup and restore with the additional tasks of schema and data type management.<\/li>\n<li>Use a provider who will support this migration and make your life a bit simpler but of course at a small&nbsp;price.<\/li>\n<\/ul>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-1280 size-full\" title=\"aws database migration\" src=\"https:\/\/intentwise.com\/blog\/wp-content\/uploads\/2017\/05\/AWS-DMS.png\" alt=\"AWS DMS\" width=\"799\" height=\"369\"><\/p>\n<p><a href=\"https:\/\/aws.amazon.com\/dms\/\">AWS DMS<\/a> is a great service if you haven\u2019t used it. A few of the features that it provides are of great help to businesses who love to not dirty their hands \ud83d\ude42 for non-needed tasks.<\/p>\n<ol>\n<li>Replication<\/li>\n<li>Data streaming<\/li>\n<li>Synchronization between the source and destination<\/li>\n<\/ol>\n<p>Redshift which is an MPP DB mainly suited for Datawarehouse related large data processing is ideally suited if you need to handle data growing from a small single node to multiple multi-node clusters.<\/p>\n<p>One of the neat features is that you can add or remove compute nodes to the cluster without any interruption to the service. This is fantastic as this enables you to handle your performance based on your traffic growth. Other key features that Redshift supports are your normal Admin activities such as backup, replication, monitoring on cloud watch to name a few.<\/p>\n<p>We highly recommend trying out AWS DMS as it can provide a great deal of stability, quality, and performance for your DB migration-related tasks.<\/p>\n<p><em>Read our post &#8220;<a href=\"https:\/\/www.intentwise.com\/blog\/technology\/database-connection-tools\/\">Database Connection Tools<\/a>&#8221; to learn about the best tools for your business to connect to a database.<\/em><\/p>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>It&#8217;s a great place to be when your initial platform is ready to scale and having performance issues. This clearly shows that we are growing and in the process making the right decisions in choosing and building our platform. One of our data sore is PostgresSQL hosted on AWS through our provider elephantsql. We have [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":4,"featured_media":22882,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","cybocfi_hide_featured_image":"yes","footnotes":""},"categories":[10],"tags":[9],"class_list":["post-163","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","tag-cloud-data-infrastructure"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.7 (Yoast SEO v27.8) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Best Approach for SQL Database Migration<\/title>\n<meta name=\"description\" content=\"Is database migration proving to be a challenge for you? In this blog post we present two approaches for migrating your SQL databases.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.intentwise.com\/blog\/technology\/database-migration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database Migration\" \/>\n<meta property=\"og:description\" content=\"Is database migration proving to be a challenge for you? In this blog post we present two approaches for migrating your SQL databases.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.intentwise.com\/blog\/technology\/database-migration\/\" \/>\n<meta property=\"og:site_name\" content=\"Intentwise Blog\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ragskashyap\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-24T05:36:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-06T14:27:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2017\/05\/AWS-DMS.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"700\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Raghu Kashyap\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ragskashyap\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Raghu Kashyap\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/technology\\\/database-migration\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/technology\\\/database-migration\\\/\"},\"author\":{\"name\":\"Raghu Kashyap\",\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/#\\\/schema\\\/person\\\/2ee23f4b06970f050e08dc0add723572\"},\"headline\":\"Database Migration\",\"datePublished\":\"2017-05-24T05:36:02+00:00\",\"dateModified\":\"2024-02-06T14:27:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/technology\\\/database-migration\\\/\"},\"wordCount\":393,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/technology\\\/database-migration\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/05\\\/AWS-DMS.jpg\",\"keywords\":[\"Cloud Data Infrastructure\"],\"articleSection\":[\"Technology\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/technology\\\/database-migration\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/technology\\\/database-migration\\\/\",\"url\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/technology\\\/database-migration\\\/\",\"name\":\"Best Approach for SQL Database Migration\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/technology\\\/database-migration\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/technology\\\/database-migration\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/05\\\/AWS-DMS.jpg\",\"datePublished\":\"2017-05-24T05:36:02+00:00\",\"dateModified\":\"2024-02-06T14:27:02+00:00\",\"description\":\"Is database migration proving to be a challenge for you? In this blog post we present two approaches for migrating your SQL databases.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/technology\\\/database-migration\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/technology\\\/database-migration\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/technology\\\/database-migration\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Technology\",\"item\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/.\\\/technology\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database Migration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/\",\"name\":\"Intentwise Blog\",\"description\":\"Amazon Analytics &amp; Advertising Software\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/#organization\",\"name\":\"Intentwise\",\"url\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/favicon256.png\",\"contentUrl\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/07\\\/favicon256.png\",\"width\":256,\"height\":256,\"caption\":\"Intentwise\"},\"image\":{\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/#\\\/schema\\\/person\\\/2ee23f4b06970f050e08dc0add723572\",\"name\":\"Raghu Kashyap\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/lh3.googleusercontent.com\\\/a\\\/ACg8ocKsh7N3FROrYn40qt13SBywMxAdYxWpCZiEEhbZxcVS5sy0rFSw\",\"url\":\"https:\\\/\\\/lh3.googleusercontent.com\\\/a\\\/ACg8ocKsh7N3FROrYn40qt13SBywMxAdYxWpCZiEEhbZxcVS5sy0rFSw\",\"contentUrl\":\"https:\\\/\\\/lh3.googleusercontent.com\\\/a\\\/ACg8ocKsh7N3FROrYn40qt13SBywMxAdYxWpCZiEEhbZxcVS5sy0rFSw\",\"caption\":\"Raghu Kashyap\"},\"description\":\"I help Advertisers on Marketplaces such as Amazon, Walmart, Way-fair, Overstock, and Instacart leverage the Intentwise technology platform to scale better. Additionally, I oversee our product development, Customer Success, and Marketing initiatives.\",\"sameAs\":[\"https:\\\/\\\/kashyaps.com\",\"https:\\\/\\\/www.facebook.com\\\/ragskashyap\",\"https:\\\/\\\/www.instagram.com\\\/ragskashyap\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/raghukashyap\\\/\",\"https:\\\/\\\/x.com\\\/ragskashyap\"],\"honorificPrefix\":\"Mr\",\"gender\":\"male\",\"knowsAbout\":[\"advertising\",\"marketing\",\"Data platform\",\"technology\"],\"knowsLanguage\":[\"English\",\"Kannada\",\"Tamil\",\"Telugu\",\"Hindi\"],\"jobTitle\":\"CTO, Founder\",\"worksFor\":\"Intentwise\",\"url\":\"https:\\\/\\\/www.intentwise.com\\\/blog\\\/author\\\/raghukashyap\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Best Approach for SQL Database Migration","description":"Is database migration proving to be a challenge for you? In this blog post we present two approaches for migrating your SQL databases.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.intentwise.com\/blog\/technology\/database-migration\/","og_locale":"en_US","og_type":"article","og_title":"Database Migration","og_description":"Is database migration proving to be a challenge for you? In this blog post we present two approaches for migrating your SQL databases.","og_url":"https:\/\/www.intentwise.com\/blog\/technology\/database-migration\/","og_site_name":"Intentwise Blog","article_author":"https:\/\/www.facebook.com\/ragskashyap","article_published_time":"2017-05-24T05:36:02+00:00","article_modified_time":"2024-02-06T14:27:02+00:00","og_image":[{"width":700,"height":400,"url":"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2017\/05\/AWS-DMS.jpg","type":"image\/jpeg"}],"author":"Raghu Kashyap","twitter_card":"summary_large_image","twitter_creator":"@ragskashyap","twitter_misc":{"Written by":"Raghu Kashyap","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.intentwise.com\/blog\/technology\/database-migration\/#article","isPartOf":{"@id":"https:\/\/www.intentwise.com\/blog\/technology\/database-migration\/"},"author":{"name":"Raghu Kashyap","@id":"https:\/\/www.intentwise.com\/blog\/#\/schema\/person\/2ee23f4b06970f050e08dc0add723572"},"headline":"Database Migration","datePublished":"2017-05-24T05:36:02+00:00","dateModified":"2024-02-06T14:27:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.intentwise.com\/blog\/technology\/database-migration\/"},"wordCount":393,"commentCount":0,"publisher":{"@id":"https:\/\/www.intentwise.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.intentwise.com\/blog\/technology\/database-migration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2017\/05\/AWS-DMS.jpg","keywords":["Cloud Data Infrastructure"],"articleSection":["Technology"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.intentwise.com\/blog\/technology\/database-migration\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.intentwise.com\/blog\/technology\/database-migration\/","url":"https:\/\/www.intentwise.com\/blog\/technology\/database-migration\/","name":"Best Approach for SQL Database Migration","isPartOf":{"@id":"https:\/\/www.intentwise.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.intentwise.com\/blog\/technology\/database-migration\/#primaryimage"},"image":{"@id":"https:\/\/www.intentwise.com\/blog\/technology\/database-migration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2017\/05\/AWS-DMS.jpg","datePublished":"2017-05-24T05:36:02+00:00","dateModified":"2024-02-06T14:27:02+00:00","description":"Is database migration proving to be a challenge for you? In this blog post we present two approaches for migrating your SQL databases.","breadcrumb":{"@id":"https:\/\/www.intentwise.com\/blog\/technology\/database-migration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.intentwise.com\/blog\/technology\/database-migration\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.intentwise.com\/blog\/technology\/database-migration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Technology","item":"https:\/\/www.intentwise.com\/blog\/.\/technology\/"},{"@type":"ListItem","position":2,"name":"Database Migration"}]},{"@type":"WebSite","@id":"https:\/\/www.intentwise.com\/blog\/#website","url":"https:\/\/www.intentwise.com\/blog\/","name":"Intentwise Blog","description":"Amazon Analytics &amp; Advertising Software","publisher":{"@id":"https:\/\/www.intentwise.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.intentwise.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.intentwise.com\/blog\/#organization","name":"Intentwise","url":"https:\/\/www.intentwise.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.intentwise.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2021\/07\/favicon256.png","contentUrl":"https:\/\/www.intentwise.com\/blog\/wp-content\/uploads\/2021\/07\/favicon256.png","width":256,"height":256,"caption":"Intentwise"},"image":{"@id":"https:\/\/www.intentwise.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.intentwise.com\/blog\/#\/schema\/person\/2ee23f4b06970f050e08dc0add723572","name":"Raghu Kashyap","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/lh3.googleusercontent.com\/a\/ACg8ocKsh7N3FROrYn40qt13SBywMxAdYxWpCZiEEhbZxcVS5sy0rFSw","url":"https:\/\/lh3.googleusercontent.com\/a\/ACg8ocKsh7N3FROrYn40qt13SBywMxAdYxWpCZiEEhbZxcVS5sy0rFSw","contentUrl":"https:\/\/lh3.googleusercontent.com\/a\/ACg8ocKsh7N3FROrYn40qt13SBywMxAdYxWpCZiEEhbZxcVS5sy0rFSw","caption":"Raghu Kashyap"},"description":"I help Advertisers on Marketplaces such as Amazon, Walmart, Way-fair, Overstock, and Instacart leverage the Intentwise technology platform to scale better. Additionally, I oversee our product development, Customer Success, and Marketing initiatives.","sameAs":["https:\/\/kashyaps.com","https:\/\/www.facebook.com\/ragskashyap","https:\/\/www.instagram.com\/ragskashyap\/","https:\/\/www.linkedin.com\/in\/raghukashyap\/","https:\/\/x.com\/ragskashyap"],"honorificPrefix":"Mr","gender":"male","knowsAbout":["advertising","marketing","Data platform","technology"],"knowsLanguage":["English","Kannada","Tamil","Telugu","Hindi"],"jobTitle":"CTO, Founder","worksFor":"Intentwise","url":"https:\/\/www.intentwise.com\/blog\/author\/raghukashyap\/"}]}},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/posts\/163","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/comments?post=163"}],"version-history":[{"count":0,"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/posts\/163\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/media\/22882"}],"wp:attachment":[{"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/media?parent=163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/categories?post=163"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.intentwise.com\/blog\/wp-json\/wp\/v2\/tags?post=163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}