How to convert memory optimized table into disk based table in sql server Could anyone please explain the process to convert memory optimized table into disk based table in sql server?

Thanks &amp; Regards,
Phanindhra S
Could anyone please explain the process to convert memory optimized table into disk based table in sql server?


Create a new disk based table and insert the data from the in-memory table or use select into to copy the data over and create the table at the same time. There are various other ways but all are variations on this.

Please note that you cannot remove the in-memory filegroup from the database, so if you're attempting to clean up all traces of in-memory then I'd suggest migrating the data to a completely new database.