|
Posted by Neil on 12/31/07 01:37
> OK, so there is obviously a lot of air in that table. No idea where it
> came from.
Yeah, it seems that we'll never get to the bottom of that.
> o Rename it.
> o Create it again.
> o Move the data to the new table.
> o Recreate triggers, indexes and constraints.
> o Move referencing constraints.
> o Drop the old table.
> o Shrink the database.
I think that's a good idea. What about the idea of just exporting it to a
blank db, like I did today, with the triggers, indexes, and constraints in
place, and then reimporting it with those? Then only the referencing
constraints would have to be recreated.
> I would suggest that you first do this in a test environment to see that
> it works well. And, oh, I would also suggest that you download SQL Compare
> from Red Gate (www.red-gate.com) to compare the schema of the database
> after the change with a reference copy. SQL Compare has a price tag, but
> there is a preview period you could benefit from. Caveat: I don't know if
> they support SQL 7.
I'll look into that. Thanks!
Neil
Navigation:
[Reply to this message]
|