We have to change a field datatype in 3 different tables from int to
bigint. The tables have 5 million, 25 million, and 18 million rows.

Initially, we tried using a script generated by EM for each table that
copied the data to a holder table, recreated the table with the new
datatype, and inserted the data back into the new table, etc.

Well, the table with 5 million rows finished in a few hours, but the one
with 25 million rows has been going for about 36 hours with no end in
sight and the table with 18 million rows hasn't even started. You can
imagine the user community is a little miffed right now.

We've stopped the script that was changing the 25 million row table, but
it's now in massive rollback mode.

There's got to be a better way! Any suggestions on what we can do now to
mitigate the damage would be greatly appreciated!!!

Steve


MS Sql Server LazyDBA home page