On 09/10/11 16:23 +0200, Cédric Krier wrote:
> On 09/10/11 15:23 +0200, Cédric Krier wrote:
> > On 09/10/11 08:36 +0200, Cédric Krier wrote:
> > > On 30/09/11 21:48 +0200, Cédric Krier wrote:
> > > > On 27/08/11 18:55 +0200, Cédric Krier wrote:
> > > > > On 27/08/11 12:17 -0400, Douglas Morato wrote:
> > > > > > > So I'm looking for some help to work on this migration. I think 
> > > > > > > we will use a
> > > > > > > repositories to store all the customizations of each softwares. 
> > > > > > > So the
> > > > > > > development could be distributed and I could provide some 
> > > > > > > "annonymized data"
> > > > > > > from the bugtracker and codereview.
> > > > > > I would love to help, just tell me how could I assist
> > > > > 
> > > > > So the first step is to have a script to convert a roundup sqlite 
> > > > > database
> > > > > into a postgresql. Perhaps there is already existing script if so it 
> > > > > needs to be
> > > > > tested. I can give you a database dump (user password are crypted 
> > > > > with SHA :-)
> > > > 
> > > > Have you done any progress on this topic?
> > > 
> > > I check it. I think I could write a script that fill the PostgreSQL 
> > > database
> > > with the SQLite data.
> > 
> > Here is my script.
> > It seems to work, I will make some more tests and if everything works I will
> > migrate roundup.
> > 
> > > By the way, I will try to make it generic like that it could be used to
> > > migrate Tryton database also.
> > 
> > There is some hack in the script that are specific to roundup schema but the
> > basis should work for Tryton database. I did not test it but if someone 
> > wants
> > to test it, I will appreciate feedback.
> 
> I forgot to update the sequences.

Done.


-- 
Cédric Krier

B2CK SPRL
Rue de Rotterdam, 4
4000 Liège
Belgium
Tel: +32 472 54 46 59
Email/Jabber: [email protected]
Website: http://www.b2ck.com/

Attachment: pgp92BHa5UHbI.pgp
Description: PGP signature

Reply via email to