Post reply

MIGRATE INDEXES FOR THE TABLE

  • October 26, 2008 at 4:16 pm

    #200361

    I used import and export wizard to import a table from one server to another. But the indexes were not included. Does anyone tell me how to include indexes?

    Thank you !

  • October 27, 2008 at 1:17 am

    #889841

    You can script the indexes and just apply them on the other server. Import/export just moves the data

    Go to object explorer in management studio, expand out until you see the indexes you want. Right click and choose script index as...

    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

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

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