Copying Partitioned table data to another table on different SQL Server
BCP works fine.


First, you create the target table.
Then export data with the select and filter you need.
Import data with BCP will fit the correct partitions.


I did this before. I was on SQL 2014, but it will be fine on 2012.