Re: RB split
Hi Christian, I just tried that with a test review request and it seems that a lot of stuff is left behind in the database as well. While the review request and associated reviews are indeed gone, the following remained: - File attachments - Change descriptions - Diff set histories - Diff sets - File diffs - Comments - File attachment comments I assume screenshots/screenshot comments would remain as well - I just didn't have any screenshots in the test review request. Given that the file attachment records remained - the search for orphaned attachments wouldn't work either. Regards, Alexey. On 10/14/2014 12:36 PM, christ...@beanbaginc.com wrote: Hi Alexey, There's no easy way to split up a database like you want. The best way is the second way you mentioned -- clone and delete things. Deleting review requests should result in all associated reviews, comments, diffs, file attachment entries, etc. being deleted. It won't delete the actual uploaded file attachments themselves, though, so you'd have to handle that specially. (Maybe loop through the entries in the database and the filesystem and delete any that are orphaned.) Christian -- Christian Hammond - christ...@beanbaginc.com Review Board - https://www.reviewboard.org Beanbag, Inc. - https://www.beanbaginc.com -Original Message- From: Alexey Neyman Reply: reviewboard@googlegroups.com > Date: October 14, 2014 at 12:24:41 PM To: reviewboard@googlegroups.com > Subject: RB split Hi, We are considering splitting an RB installation in two (have separate instances for separate products - with separate administrators, etc.) I wonder if there's a way of exporting a set of review requests (along with any attachments, comment history, etc) and importing it into a new RB instance. It doesn't matter if the review request IDs are different in the new database. We have also thought of just cloning the database and the filesystem storage for the new instance and then deleting the review requests that don't belong to the new instance. Does deleting a review request also delete all the associated database objects and filesystem objects? Regards, Alexey. -- 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/d/optout. -- 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/d/optout.
Re: RB split
Hi Alexey, There's no easy way to split up a database like you want. The best way is the second way you mentioned -- clone and delete things. Deleting review requests should result in all associated reviews, comments, diffs, file attachment entries, etc. being deleted. It won't delete the actual uploaded file attachments themselves, though, so you'd have to handle that specially. (Maybe loop through the entries in the database and the filesystem and delete any that are orphaned.) Christian -- Christian Hammond - christ...@beanbaginc.com Review Board - https://www.reviewboard.org Beanbag, Inc. - https://www.beanbaginc.com -Original Message- From: Alexey Neyman Reply: reviewboard@googlegroups.com > Date: October 14, 2014 at 12:24:41 PM To: reviewboard@googlegroups.com > Subject: RB split > Hi, > > We are considering splitting an RB installation in two (have separate > instances for separate products - with separate administrators, etc.) > > I wonder if there's a way of exporting a set of review requests (along > with any attachments, comment history, etc) and importing it into a new > RB instance. It doesn't matter if the review request IDs are different > in the new database. > > We have also thought of just cloning the database and the filesystem > storage for the new instance and then deleting the review requests that > don't belong to the new instance. Does deleting a review request also > delete all the associated database objects and filesystem objects? > > Regards, > Alexey. > > -- > 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/d/optout. > -- 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/d/optout.
RB split
Hi, We are considering splitting an RB installation in two (have separate instances for separate products - with separate administrators, etc.) I wonder if there's a way of exporting a set of review requests (along with any attachments, comment history, etc) and importing it into a new RB instance. It doesn't matter if the review request IDs are different in the new database. We have also thought of just cloning the database and the filesystem storage for the new instance and then deleting the review requests that don't belong to the new instance. Does deleting a review request also delete all the associated database objects and filesystem objects? Regards, Alexey. -- 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/d/optout.
