July 28, 2014 at 2:50 am
A few months back I raised some Connect items requesting that Transactional Replication is enhanced in a future version of SQL Server to allow replication of Columnstore and In-Memory objects. I also asked that Columnstore indexes could be used within an Indexed View.
These have now all been closed as "Won't Fix". This means that we should not expect any enhancements to replication in these areas.
In my opinion it also means that organisations should be planning their exit strategy if they are using transactional replication of any form. This may mean a move to the Attunity product line (www.attunity.com), or more likely a move to Availability Groups.
For many people this news merely confirms what has been implicitly understood from the SQL 2014 release, but for others this may be more important for their future plans.
The relevant Connect items are listed below, you need to sign in to Connect to see the details:
807668 Allow the use of Columnstore indexes with Transactional Replication
807667 Allow use of Columnstore index with Indexed View
807670 Allow use of Memory-Optimised tables with transactional replication
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply