Lets us make sure everything is fine for data transfer and as we are using our source server (SQL Server 2014) with Linked Server to SQL Server 2016, let us insert a couple of ObjectIds to the T1 table that we have created in the [Test] database:
123 INSERT INTO [.\SQL16].Test.dbo.T1 (C1)SELECT so.object_idFROM sys.objects so;
This statement will result in the error message that you can find below, telling us something about Cursors (????):
12 Msg 35370, Level 16, State 1, Line 1Cursors are not supported on a table which has a clustered columnstore index.
WHAT ? SORRY ? THERE ARE NO CURSORS HERE !
We have no cursors, we just have a Clustered Columnstore Index on our table!
Read on to see how to get around this error, to the extent that you can.