Support Memory Optimized Tables

[ddbtrmatic]

Hello,

When testing any procedure that touches a memory optimized table, TSLQT fails due to its use of save points.
The only comment I've been able to find on this issue is from 2016 - https://stackoverflow.com/questions/35655656/how-can-i-test-memory-optimized-tables-using-tsqlt

Is there any work around for this issue, and if not, is there any plan to support memory optimized tables?

Thank you

[thegoatherder]

@ddbtrmatic I'm facing this issue also... the framework looked sooooo promising to assure a large db project refactor, but my target schema for the migration includes memory optimised tables.

Did you manage to find any viable solution for testing them?

[ddbtrmatic]

@ddbtrmatic I'm facing this issue also... the framework looked sooooo promising to assure a large db project refactor, but my target schema for the migration includes memory optimised tables.

Did you manage to find any viable solution for testing them?

Our current solution is to run the database scripts through a pre-processor to remove unsupported features as part of our build and testing pipeline.

For example:

    -- @pp if ENV != 'test'
    WITH (MEMORY_OPTIMIZED = ON, DURABILITY = SCHEMA_AND_DATA)
    -- @pp endif