Insert into Memory Optimized Table from non optimized

Question

I have two database. Primary have a DDL triggers so i can't create memory optimized tables there. So i created secondary database and create there table with memory optimized on. Now, in procedure on primary database i need insert copy data from other table to this optimized.

For example:

INSERT INTO InMemory.dbo.DestTable_InMem SELECT * FROM @T;

And i have:

A user transaction that accesses memory optimized tables or natively compiled modules cannot access more than one user database or databases model and msdb, and it cannot write to master.

Did exists some workarounds from it?

I cannot move my procedure to second database.

SQLpro · Accepted Answer · 2022-03-15 09:52:25Z

0

There is no other way than using a native procedure to INSERT, UPDATE or DELETE in an in-memory table.

See: A Guide to Query Processing for Memory-Optimized Tables

To move from one DB to the other, the source table must exists locally

answered Mar 15, 2022 at 9:52

SQLpro

5,3121 gold badge9 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert into Memory Optimized Table from non optimized

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related