Posted byBill Ramos | On October 14th, 2016 | InDatabase Migration,SQL Server | Tags:database migration, DB2 , In-Memory OLTP , MS SQL Server , oracle , sql server , SSMA

This continues our video blog series about new features on the new capabilities of SQL Server Migration Assistant 7.0 . SQL Server 2016 In-Memory OLTP significantly improves OLTP database application performance and allows running large queries against the same tables using clustered and non-clustered columnstore indexes . This technology was introduced in SQL Server 2014 and now SSMA 7.0 supports migrating Oracle Database In-Memory tables to In-Memory OLTP with SQL Server 2016.

Background on SQL Server In-Memory OLTP and Oracle Database In-Memory

SQL Server 2016 In-Memory OLTP is a high performance, memory-optimized engine, designed for modern hardware trends. It allows users to move data into memory resident tables while keeping other data in traditional, disk-based table structures. In-Memory OLTP introduces two fundamentally new concepts: memory-optimized tables and natively compiled stored procedures . But the most important moment about this technology is that data in memory-optimized tables resides in RAM which helps speed up data processing transactions up to 30x.

Oracle introduced Database In-Memory technology in 12c version. It provides a dual-format architecture that enables tables to be simultaneously represented in memory using traditional row format and a new in-memory column format.

If you use the databases for high performance transactions, real-time analytics, business intelligence, and reports and now plan to convert them into SQL Server In-Memory OLTP, we highly recommend you to use SSMA 7.0. The tool will also help you convert ordinary tables into SQL Server In-Memory OLTP.

In this video below we show you how to convert Oracle Database In-Memory into SQL Server In-Memory OLTP and demonstrate several conversion options for Oracle Database In-Memory tables. Additionally, we explain conversion of regular tables into SQL Server In-Memory OLTP.

For IBM DB2 users, if you have tables that use BLU Acceleration , you can migrate them into SQL Server In-Memory OLTP using the SSMA 7.0 for DB2 .

Known issues migrating Oracle Database In-Memory

There are some limitations which you have to consider when migrating to the SQL Server In-Memory OLTP.

The total size of all In-Memory tables in SQL Server should not exceed the half of all available memory. The user should review the memory allocation on the target SQL Server to make sure that this option will work properly. The memory-optimized table must contain a primary key. There’s a list of unsupported column data types which includes: (n)text, image, (n)varchar(max), varbinary(max), rowversion (and timestamp), sql_variant, CLR types (hierarchyid and spatial types), XML for In-Memory Oracle tables and datetimeoffset, geography, geometry, hierarchyid, rowversion, xml, sql_variant, CLR-UDT for ordinary source tables. SSMA doesn’t analyze materialized views that are enabled for in-memory. There’s no support in SSMA for In-memory priority and compression options, as well as the query hints. SSMA does not have the option to convert ordinary Oracle tables to Memory Optimized with Non-clustered columnstore and Clustered Columnstore options. This is because SSMA provides different sets of options of conversion depending on whether the source table is column or row-organized. Generally speaking, columnstore in-memory technology from DB2 and Oracle is best mapped on the SQL Server columnstore indexes while rowstore technology is best mapped on the In-Memory OLTP tables or traditional rowstore tables.

Useful references for using SSMA for Oracle to SQL Server Migration, Oracle Database In-Memory and SQL Server In-Memory OLTP

Oracle Database In-Memory: http://www.oracle.com/technetwork/database/in-memory/overview/index.html . In-Memory OLTP support in SQL Server 2016: https://msdn.microsoft.com/library/dn133186.aspx .

Stay tuned to our blog for more information about the new features in the SQL Server Migration Assistant (SSMA) 7.0.

本文数据库(mssql)相关术语:熊片数据库 mssql数据库 oracle数据库 pubmed数据库 access数据库 万方数据库

主题: SQLSQL ServerXMLIBM
分页:12
转载请注明
本文标题:SSMA for Oracle 7.0 ― What’s New ― Using In-Memory OLTP in SQL Server 2016
本站链接:http://www.codesec.net/view/484015.html
分享请点击:


1.凡CodeSecTeam转载的文章,均出自其它媒体或其他官网介绍,目的在于传递更多的信息,并不代表本站赞同其观点和其真实性负责;
2.转载的文章仅代表原创作者观点,与本站无关。其原创性以及文中陈述文字和内容未经本站证实,本站对该文以及其中全部或者部分内容、文字的真实性、完整性、及时性,不作出任何保证或承若;
3.如本站转载稿涉及版权等问题,请作者及时联系本站,我们会及时处理。
登录后可拥有收藏文章、关注作者等权限...
技术大类 技术大类 | 数据库(mssql) | 评论(0) | 阅读(28)