Can reviews be exported and imported somehow ?

On Friday, May 1, 2015 at 1:07:39 PM UTC-7, Christian Hammond wrote:
>
> Hi Robert,
>
> Review Board really wasn't designed to do that. There's more than database 
> IDs at stake. We also have JSON blobs referencing IDs in various places 
> that would all need to be updated as well, and there just isn't a tool to 
> do any of this.
>
> A possible approach would be to generate a database dump using the 
> existing dumpdata command, then post-processing this to choose new IDs 
> (keeping a mapping of all ID transitions), post-processing any JSON blobs, 
> and replicating that in the database. It's likely very error-prone. I 
> wouldn't do it with the primary server running, since you won't want the 
> database to be modified at all when this is happening.
>
> There isn't an easy way for this, though. Translating IDs in a database is 
> not an easy task.
>
> Christian
>
> -- 
> Christian Hammond - [email protected] <javascript:>
> Review Board - http://www.reviewboard.org
> Beanbag, Inc. - http://www.beanbaginc.com
>
> On Fri, May 1, 2015 at 10:53 AM, Robert Orr <[email protected] 
> <javascript:>> wrote:
>
>> We created a new reviewboard server after using an old one for a while, 
>> and after a few hundred reviews were done on the new server, realized that 
>> we'd have to make room for porting old reviews to the new server. So - we 
>> need to move reviews ID < 600 to above id = 100000. I've been munging 
>> around with a python sqlalchemy script to do this, but I keep running into 
>> the integrity checks you've got in  place. Is there any easier way to do 
>> this ? Its not like we need to do it more than once, just once to get the 
>> new items out of the way, and once again to port the old database entries.
>>
>> -- 
>> Supercharge your Review Board with Power Pack: 
>> https://www.reviewboard.org/powerpack/
>> Want us to host Review Board for you? Check out RBCommons: 
>> https://rbcommons.com/
>> Happy user? Let us know! https://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 [email protected] <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
Supercharge your Review Board with Power Pack: 
https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons: 
https://rbcommons.com/
Happy user? Let us know! https://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 [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to