Post reply

Switch out partition from Non Partition to Partitioned Table, different database

  • February 22, 2016 at 2:36 am

    #305014

    Hello

    I have below requirement :

    A non partitioned database with over 50 tables needs to be migrated to the Partitioned Database.

    How can I switch to partition table which resides in different database on same server? If it is not possible, what is the alternate way to do accomplish the same?

    Let me know if more specific information is required to answer this question

    Many Thanks

    dbkulkarni

  • February 22, 2016 at 2:45 am

    #1860026

    A partition switch can only be done within the same database.

    You'll need to create non-partitioned tables in the same DB as the partitioned table (same filegroup as the destination partition), copy the data into them and then do the switch.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 22, 2016 at 3:02 am

    #1860027

    Thank you Gail. I've got hint on next steps. I'll come back if I need more help on moving data.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply