Skip to content

Support Memory Optimized Tables #210

Open
Open
Support Memory Optimized Tables#210

Description

@ddbtrmatic
ddbtrmatic
opened on Mar 19, 2025

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

Activity

  1. thegoatherder commented on Jun 10, 2025

    @thegoatherder
    thegoatherder
    on Jun 10, 2025

    @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?

  2. ddbtrmatic commented on Jun 10, 2025

    @ddbtrmatic
    ddbtrmatic
    on Jun 10, 2025
    Author

    @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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions