AmolNaik (9/29/2010)
Create copy of the table that is identically same with the correct structure. Copy data from the existing table to this new table. Switch the table names.After that you might have to do comparison between old and new tables and apply the updates you might have lost during the switch.
Give a try to this approach!
Good luck!
Thanks,
I'd agree with this. If you're stuck at 5 nines support and can't get a LARGE window for downtime (think day(s)) depending on the box, the size of the data pages, and the SAN speed, amongst other things. This is a solution, but be prepared to do a lot of prep work to make it work.
You want the system queueing data changes to an audit table from when the copy is first made, so you need to create a full set of audit triggers. And an audit table. Once that's in place, you work on the copy, do what you need to. You then find yourself a nice 10-20 minute window, and apply all audited changes. Then you run the sp_ for changing object names for the two tables, and let 'er rip. Keep your old copy of the table for a day or two in case anything goes wrong, or somehow something missed an audit.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA