[rt-users] RT migration and upgrade

[Michael Erana]

Hmmm,
 
My take on this would be to:
 
1. Re-dump from original with the proper flags.
2. dump from current with proper flags
3. Diff dump from orign and dump from new and set aside changes
4. restore original to 'safe' DB
5. restore diff results over top of original in 'safe' DB
 
In theory, this should re-stablish the last known state, isolate the changes, then re-append the changes.
 
This is of course the ugly way to do it. If you were doing binary logging and you started that on the go-live date, then you could just re-roll forward those transactions (assuming they hadn't been flushed) over top of a restore of the original. The method above is my 'ugly' sqlDBA crippled method (referring to my particular skills and not necessarily yours)...
 
G'luck

Michael Eraña, CISSP
CTO
PC Network, Inc.          
eranam at lanusa.com   

 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060330/62905af4/attachment.htm>