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.

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”

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

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.

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

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.

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.

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

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)