Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010

    Question Unanswered: Convert Table into Partitioned Table

    hi guys,

    i want to convert table 70 GB of data into partition table.

    is there any method to do that?

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    I think you need to:

    1) Create a new table that is partitioned and indexes
    2) Load the data from the old table
    3) Drop the old table
    4) Rename the new table to the old table
    5) Create any Foreign keys that were dropped when the old table was dropped
    6) Do runstats on the new table
    7) Rebind any packages that referenced the old table


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts