I have a rowstore table which contains ~10 billion records. The table is partitioned on an INT field and has about 1,400 active partitions. I also have a clustered columnstore table built on the same Partition Scheme / Function. Can I switch an active partition from the Rowstore table to the Columnstore table?
ALTER TABLE [dbo].[RowstoreTable] SWITCH PARTITION 741 TO [dbo].[ColumnstoreTable] PARTITION 741
This database resides on SQL Server 2014 Enterprise Edition.