SQL SERVER – Generating In-Memory OLTP Migration CheckList

During recent Comprehensive Database Performance Health Check, one of my customer asked if I can also help them to check their readiness of In-Memory OLTP Migration as well as the help them build a checklist which can help them with In-Memory OLTP Migration.

I consider myself as a SQL Server Performance Tuning Expert and I believe if there is any troubleshooting issue with SQL Server performance, I am sure I would have seen them in the past. I like to engage myself in the performance tuning issues which are very difficult to solve. In the normal case, I would not like to divert myself to different task while working on a performance problem. However, in this case, generating a checklist was a very simple task, hence, I immediately helped them to generate one.

SQL SERVER - Generating In-Memory OLTP Migration CheckList inmemorychecklist0

In this blog post, we will see how quickly we can generate an In-Memory OLTP Migration Checklist.

First, go to SQL Server Management Studio and go to Object Explorer and right click over it. Right after that following the image below and go to Tasks and select “Generate In-Memory OLTP Migration Checklists”

SQL SERVER - Generating In-Memory OLTP Migration CheckList inmemorychecklist1

It will bring you to the introduction screen. Click Next on the same.

SQL SERVER - Generating In-Memory OLTP Migration CheckList inmemorychecklist2

In the next screen, you can specify the location where you want to save your files. Additionally, here you have an option to either select specific table and stored procedure or just go ahead with all the objects in the database.

SQL SERVER - Generating In-Memory OLTP Migration CheckList inmemorychecklist3

Once you click next it will bring you to the final Summary screen. Click on the Finish over here.

SQL SERVER - Generating In-Memory OLTP Migration CheckList inmemorychecklist4

Next, you will see a screen which will show you the results of the generating migration checklist. There is a good chance that for every single object you will see the result as a “Passed“, however, please note that this result is only informing you that they have created the checklist. To see if your object has passed the In-Memory OLTP Migration Checklist or not, you will have to go to the folder which you have specified earlier.

SQL SERVER - Generating In-Memory OLTP Migration CheckList inmemorychecklist5

Once you go to the folder you will find your database name and under the name of the database, you will see folders for Tables and Stored Procedure.

SQL SERVER - Generating In-Memory OLTP Migration CheckList inmemorychecklist6

Click on any of the HTML files and you can see that the actual result of the migration test.

SQL SERVER - Generating In-Memory OLTP Migration CheckList inmemorychecklist7

If you see Validation Result as a successful, you do not have to worry about anything but if your validation has failed, you will see the status as Failed: More Information. Over here you can click on the file and it will open Microsoft Documentation for further help.

Reference: Pinal Dave (https://blog.SQLAuthority.com)

In-Memory OLTP, SQL Migration, SQL Reports, SQL Server
Previous Post
SQL SERVER – Retrieving Rows With All Alphabets From Alphanumeric Data
Next Post
SQL SERVER – Automated SQL Server Consolidation and Right Sizing – Save 50% Data Platform Costs

Related Posts

5 Comments. Leave new

  • Pinal, thanks. It would seem helpful if you could indicate for readers which versions of both SSMS and SQL Server support this.

    • Good Point. I have always used latest and greatest available :)

      • Fair enough, but of course not everyone can. Are you affirming that you would or would not be updating this post to clarify things. It’s just not clear from your answer.

        I appreciate that you’re very busy and do post so much already. Just want to set expectations for other readers who may be interested to know.

      • Hi Charlie,

        SQL Server changes so much nowadays. It is impossible to keep count on when various features were introduced. I personally have no idea when this feature was added. However, it works in the latest version of SQL Server and the latest SSMS when the blog post was written.

        I have stopped providing information about version as it had created a lot of confusion for people and also there are many different varieties. Additionally, some features of SSMS works with some earlier version of SQL Server as well. It is an impossible task, in all reality.

        To answer your question, if you install the latest SQL Server and SSMS on the date when the blog was written, you will see this feature. I will be not updating the blog post with version information.

    • Hi Charlie,

      As per my knowledge, this feature is available from SQL Server 2016. So, if anybody installs SQL Server 2016, they can be able to use the feature in SSMS.



Leave a Reply