So the easy answer is definitely just "don't do it".
If you wanted to try, though, here's what I'd do:
1. Freeze activity on the new server
2. Systematically merge the user, repository, review group, etc. tables.
This would require mapping any duplicates to their counterparts on the new
server, and copying data for any missing ones. As you do this, update the
pk fields on the old db in order to keep foreign keys matching (I'm making
an assumption that the foreign keys have ON UPDATE CASCADE, which I really
hope is true). Doing this through the python shell might be easier than
with raw SQL.
3. Update all review request pks on the old server to not conflict with
ones on the new.
4. Dump the database, filter out duplicates, and insert all the old data
into the new db.
This is probably a ton of work, and not a lot of benefit.
On Wed, Feb 12, 2014 at 6:36 AM, Stephen Gallagher <
> So, I suspect this is going to be a tricky situation to solve:
> I've been hosting a Review Board instance on Red Hat's public OpenShift
> for quite a while while we worked on getting a supported version hosted
> in the Fedora Hosted infrastructure. There are now over 1500 reviews in
> this OpenShift instance that we would like to keep for posterity.
> Does anyone on this list know of a way to export the review history from
> one ReviewBoard instance into another, merging the two together?
> Let's assume that it's perfectly fine for the reviews to change numbers
> (and that we'd figure out a way to remap them, probably by forwarding
> rules from the old URL).
> I strongly suspect the answer is going to boil down to: "Switch to the
> new one and leave the old server in read-only mode for posterity.", but
> I figured I may as well ask.
> Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
> Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
> Happy user? Let us know at http://www.reviewboard.org/users/
> You received this message because you are subscribed to the Google Groups
> "reviewboard" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to reviewboard+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
Happy user? Let us know at http://www.reviewboard.org/users/
You received this message because you are subscribed to the Google Groups
To unsubscribe from this group and stop receiving emails from it, send an email
For more options, visit https://groups.google.com/groups/opt_out.