move data from a partitioned table to a different server

• Admingod

  SSCertifiable

  Points: 5997

  More actions

  December 1, 2017 at 10:48 am

  #409821

  Hi... can please someone tell me if there is a way to move data from a SQL Server 2014 partitioned table to a table to a different SQL Server 2008 server and keep the old Partitioned table as is. My table is on a Quarterly partition (based on date). Is this possible. If yes, please let me know the steps that needs to be done. Do you think I should create a base table in Sql server 2008 and create partitions and then move the data using BCP?

  Thanks

• goher2000

  SSCertifiable

  Points: 5479

  More actions

  December 1, 2017 at 11:32 am

  #1970351

  That is one way of doing it,  you could use replication [snapshot?]  or   use import export wizard

• December 3, 2017 at 11:58 pm

  This was removed by the editor as SPAM