• Mike.brickles (11/1/2013)


    how do i index the tables ?

    In 2005, generate the script to create the table by using Script Table As...Create To...New Query Editor window. Then connect to your 2008 database. You already have the table created and populated, so you can't create it unless you drop it first, which would result in removing all the data. So, only run the appropriate commands in the script to create the indexes.

    Next time, I would create the table first and get the indexes and constraints created first, then use the import/export wizard to copy your data over to 2008.