Monday , December 4 2023

Generate In-Memory OLTP Migration Checklists(Objects in the Database is practicable to In-Memory OLTP?)

In this article, I will share What is Generate In-Memory OLTP Migration Checklists. If you want to learn What is In Memory OLTP and In-Memory OLTP inhancements in SQL Server 2016 and SQL Server 2017, you should read the article “In Memory OLTP in SQL Server 2014, SQL Server 2016 and SQL Server 2017

Generate In-Memory OLTP Migration Checklists

Its a new feature has been added to the new Management Studio which shows us whether the objects in the database are practiceable to In-Memory OLTP.

Right-click on the database and click Tasks and Generate In-Memory OLTP Migration Checklists as follows.

On the screen that appears, we click “Do not show this page again” and proceed by clicking next.

On the next screen we see 2 options as follows.

By selecting the first option, we can perform this check for all tables and stored procedures in the database.

By selecting the second option, we can only perform this check for the specified table and stored procedures.

Convert Existing Table To Memory Optimized Table

First, you should check your table is practiceable to in memory oltp as described in the beginning of the article. Then if its practiceable, you can create a memory optimized table and move your existing tables to memory optimized table. I described all the details in the article named “In Memory OLTP in SQL Server 2014, SQL Server 2016 and SQL Server 2017“. If you have an identitiy column or your table is big you may want to read the article named(third method) “What is Database File Group And How To Recreate Large Tables In Another File Group”


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *