Home Dashboard Directory Help

Add cross database transaction support for in memory OLTP by New Registered User



Sign in
to vote
Type: Bug
ID: 812017
Opened: 12/19/2013 1:06:53 PM
Access Restriction: Public
User(s) can reproduce this bug


SQL Server 2014 does not support cross database transactions for in memory OLTP. We have a use case where we want all tables in our Staging database to use the in memory OLTP with schema option and we want to load data in our target DataWarehouse database on the same server using a MERGE statement. Given the current product limitations, we will have to move all of our tables from the Staging database to the DataWarehouse database.

I don't want these temporary staging tables in the DataWarehouse. In a database that already has 500 objects, adding another 500 staging tables is a lot of extra unnecessary clutter. It also means I have to alter my security so that users can read all tables except for the staging tables.
Sign in to post a comment.
Posted by Microsoft on 12/20/2013 at 3:12 PM
Thanks very much for the suggestion.
Cross-database transaction support would indeed be useful. We will not be able to deliver this in SQL2014 RTM, but are a considering the feature for the next release.

Jos de Bruijn - SQL Server PM
Sign in to post a workaround.