{"id":2023,"date":"2013-09-17T09:15:00","date_gmt":"2013-09-17T16:15:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/"},"modified":"2024-01-22T22:49:10","modified_gmt":"2024-01-23T06:49:10","slug":"new-amr-tool-simplifying-the-migration-to-in-memory-oltp","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/","title":{"rendered":"New AMR Tool: Simplifying the Migration to In-Memory OLTP"},"content":{"rendered":"<p><span style=\"font-size: small\">As we have addressed in previous blog articles, the transition into SQL Server In-Memory OLTP is not as simple as flipping a switch. One of the design principles of In-Memory OLTP is that you would only need to make surgically precise migrations for your app to reap the most benefit from In-Memory OLTP for the least amount of work. With that in mind, we recognize that it is sometimes difficult to identify the appropriate targets for you to take advantage of In-Memory OLTP. To solve this problem, we have devised and integrated the AMR (Analyze, Migrate, Report) Tool into the SQL Server 2014 CTP 1 Management Studio to assist you in your transition to In-Memory OLTP.<\/span><\/p>\n<p><span style=\"font-size: small\">The AMR Tool works well if you are:<\/span><\/p>\n<ul>\n<li><span style=\"font-size: small\">Uncertain which tables and stored procedures you should migrate into In-Memory OLTP<\/span><\/li>\n<\/ul>\n<blockquote><p><span style=\"font-size: small\">The AMR Tool\u2019s analysis process is built with this goal in mind. With its analysis reports, you can easily identify the tables and stored procedures that can reap the most benefit when moved into In-Memory OLTP.<\/span><\/p><\/blockquote>\n<ul>\n<li><span style=\"font-size: small\">Seeking validation for your migration plans<\/span><\/li>\n<\/ul>\n<blockquote><p><span style=\"font-size: small\">You may understand your workload extremely well. By reading about In-Memory OLTP\u2019s characteristics and playing with it a bit, you know which objects you want to move into this new, efficient engine. The AMR Tool can help you validate your knowledge and support your decision with data straight from your workload instances.<\/span><\/p><\/blockquote>\n<ul>\n<li><span style=\"font-size: small\">Evaluating work needed for the tables and stored procedures you plan to migrate<\/span><\/li>\n<\/ul>\n<blockquote><p><span style=\"font-size: small\">You know from experience and data what objects you need to migrate. You need a list of work items so that you can carefully plan your migration effort, estimate the amount of time needed for each object, and give a completion date of the migration. The AMR Tool can help you by identifying the incompatibilities in these objects and even do some of the work for you.<\/span><\/p><\/blockquote>\n<p><span style=\"font-size: small\">As released in SQL Server 2014 CTP1, the AMR Tool consists of the following components:<\/span><\/p>\n<ul>\n<li><span style=\"font-size: small\">A set of data collectors, leveraging the existing Data Collection framework in SQL Server<\/span><\/li>\n<\/ul>\n<blockquote><p><span style=\"font-size: small\">This set of data collectors are ultra-lightweight and can easily attach to your SQL Server instances (in production or otherwise) as long as they are running SQL Server 2008 or later. They collect performance data points from DMVs in your SQL Server instance and deposit them to a designated database called a Management Data Warehouse for the analysis reports.<\/span><\/p><\/blockquote>\n<ul>\n<li><span style=\"font-size: small\">A set of Management Data Warehouse analysis reports<\/span><\/li>\n<\/ul>\n<blockquote><p><span style=\"font-size: small\">This set of reports ingest data from the Management Data Warehouse into which the AMR data collectors have uploaded data. They use these data points to analyze your workload patterns and provide recommendations for migration based on:<\/span><\/p>\n<ul>\n<li><span style=\"font-size: small\">your workload\u2019s access characteristics,<\/span><\/li>\n<li><span style=\"font-size: small\">your workload\u2019s contention statistics, and<\/span><\/li>\n<li><span style=\"font-size: small\">your workload\u2019s stored procedure CPU usage<\/span><\/li>\n<\/ul>\n<p><span style=\"font-size: small\">The overview reports are designed so that it is easy for you to identify the tables and stored procedures with the best return on investment as illustrated below:<\/span><\/p><\/blockquote>\n<p><span style=\"font-size: small\"><img loading=\"lazy\" decoding=\"async\" style=\"margin-right: auto;margin-left: auto;float: none;background-image: none\" title=\"Recommended Tables Based on Usage\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/0363.clip_image002_thumb_01A6243D.jpg\" alt=\"Recommended Tables Based on Usage\" width=\"561\" height=\"375\" border=\"0\" \/><\/span><\/p>\n<blockquote><p><span style=\"font-size: small\">The reports will provide a set of recommended tables or stored procedures for each basis. For example, if your workload has a contention issue, you may choose to follow the recommendations based on contention statistics and disregard the others. <\/span><\/p>\n<p><span style=\"font-size: small\">Since natively-compiled stored procedures cannot access disk-based tables at this time, we highly recommend that you make your table migrations first. When you are already taking advantage of the multitudes of benefits memory-optimized tables provide, you can run the AMR tool again on a second pass and select stored procedures you want to compile with In-Memory OLTP.<\/span><\/p><\/blockquote>\n<p><span style=\"font-size: small\">The setup and teardown of the AMR Tool is extremely simple:<\/span><\/p>\n<ul>\n<li><span style=\"font-size: small\">First, you need to connect to a SQL Server 2008 or later instance using SQL Server 2014 Management Studio. <b>You do not need a SQL Server 2014 instance to proceed.<\/b>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/li>\n<\/ul>\n<ul>\n<li><span style=\"font-size: small\">Next, you need to establish a Management Data Warehouse (MDW) somewhere. This MDW can reside on any instance on the same network as the workload instance. It could even be your desktop computer.<\/span><\/li>\n<\/ul>\n<blockquote><p><span style=\"font-size: small\">To create a MDW, go to \u201cObject Explorer\u201d, expand \u201cManagement\u201d, right-click \u201cData Collection\u201d, mouse over \u201cTasks\u201d, and choose \u201cConfigure Management Data Warehouse\u201d. The wizard will guide you through the task of creating a MDW for use.<\/span><\/p><\/blockquote>\n<ul>\n<li><span style=\"font-size: small\">After you have a MDW, you will need to establish data collectors on your workload instance. The AMR Tool requires the set of data collectors to situate on your workload instance in order to obtain and store the performance data it needs.<\/span><\/li>\n<\/ul>\n<blockquote><p><span style=\"font-size: small\">To install data collectors on an instance, go to \u201cObject Explorer\u201d, expand \u201cManagement\u201d, right-click \u201cData Collection\u201d, mouse over \u201cTasks\u201d, and choose \u201cConfigure Data Collection\u201d. In the wizard, check \u201cTransaction Performance Collection Set\u201d in the list of collection sets.<\/span><\/p><\/blockquote>\n<ul>\n<li><span style=\"font-size: small\">Once you have finished your migration work and do not want to use the collectors any more, you can remove them easily as well. We provide a graphic user interface for tearing down both the system data collectors the AMR data collectors in SQL Server 2014 Management Studio.<\/span><\/li>\n<\/ul>\n<blockquote><p><span style=\"font-size: small\">To tear down the AMR data collectors if you don\u2019t want them running any more, go to \u201cObject Explorer\u201d, expand \u201cManagement\u201d, right-click \u201cData Collection\u201d, mouse over \u201cTasks\u201d, and choose \u201cClean up Data Collection\u201d. In the wizard, check \u201cTransaction Performance Collection Set\u201d in the list of collection sets.<\/span><\/p><\/blockquote>\n<p><span style=\"font-size: small\">If you are thinking about In-Memory OLTP for your app, why not give the new AMR Tool a try today? We hope that you\u2019ll like it!<\/span><\/p>\n<p><span style=\"font-size: small\">SQL Server 2014 CTP1 is available for download <\/span><a href=\"http:\/\/technet.microsoft.com\/evalcenter\/dn205290?WT.mc_id=Blog_SQL_InMem_SQL2014\"><span style=\"font-size: small\">here<\/span><\/a><span style=\"font-size: small\">, or for more information please see the <a href=\"http:\/\/blogs.technet.com\/b\/dataplatforminsider\/archive\/2013\/06\/26\/sql-server-2014-in-memory-technologies-blog-series-introduction.aspx\" target=\"_blank\" rel=\"noopener\">introduction and index to this complete series<\/a>.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>As we have addressed in previous blog articles, the transition into SQL Server In-Memory OLTP is not as simple as flipping a switch.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-2023","post","type-post","status-publish","format-standard","hentry","content-type-updates","review-flag-1-1593580431-15","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>New AMR Tool: Simplifying the Migration to In-Memory OLTP - Microsoft SQL Server Blog<\/title>\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.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New AMR Tool: Simplifying the Migration to In-Memory OLTP - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"As we have addressed in previous blog articles, the transition into SQL Server In-Memory OLTP is not as simple as flipping a switch.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2013-09-17T16:15:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/0363.clip_image002_thumb_01A6243D.jpg\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"New AMR Tool: Simplifying the Migration to In-Memory OLTP\",\"datePublished\":\"2013-09-17T16:15:00+00:00\",\"dateModified\":\"2024-01-23T06:49:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/\"},\"wordCount\":923,\"commentCount\":10,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/0363.clip_image002_thumb_01A6243D.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/\",\"name\":\"New AMR Tool: Simplifying the Migration to In-Memory OLTP - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/0363.clip_image002_thumb_01A6243D.jpg\",\"datePublished\":\"2013-09-17T16:15:00+00:00\",\"dateModified\":\"2024-01-23T06:49:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/0363.clip_image002_thumb_01A6243D.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/0363.clip_image002_thumb_01A6243D.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"New AMR Tool: Simplifying the Migration to In-Memory OLTP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"New AMR Tool: Simplifying the Migration to In-Memory OLTP - Microsoft SQL Server Blog","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.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/","og_locale":"en_US","og_type":"article","og_title":"New AMR Tool: Simplifying the Migration to In-Memory OLTP - Microsoft SQL Server Blog","og_description":"As we have addressed in previous blog articles, the transition into SQL Server In-Memory OLTP is not as simple as flipping a switch.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2013-09-17T16:15:00+00:00","article_modified_time":"2024-01-23T06:49:10+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/0363.clip_image002_thumb_01A6243D.jpg","type":"","width":"","height":""}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"4 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"New AMR Tool: Simplifying the Migration to In-Memory OLTP","datePublished":"2013-09-17T16:15:00+00:00","dateModified":"2024-01-23T06:49:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/"},"wordCount":923,"commentCount":10,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/0363.clip_image002_thumb_01A6243D.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/","name":"New AMR Tool: Simplifying the Migration to In-Memory OLTP - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/0363.clip_image002_thumb_01A6243D.jpg","datePublished":"2013-09-17T16:15:00+00:00","dateModified":"2024-01-23T06:49:10+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/0363.clip_image002_thumb_01A6243D.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/03\/0363.clip_image002_thumb_01A6243D.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/09\/17\/new-amr-tool-simplifying-the-migration-to-in-memory-oltp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"New AMR Tool: Simplifying the Migration to In-Memory OLTP"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/2023","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=2023"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/2023\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=2023"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=2023"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=2023"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=2023"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=2023"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=2023"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}