Migrating from sqlite3 to MySQL or PostgreSQL

2014-04-11 Thread Joe
Hello, I believe I'm still running my review board in sqlite3 (how to confirm it) Are there any scripts from review board to convert this database to MySQL or PostgreSQL. Also which one (MySQL or PostgreSQL) is better option. Best regards, Joe. -- Get the Review Board Power Pack at http://

Re: Migrating from sqlite3 to MySQL or PostgreSQL

2014-04-11 Thread David Trowbridge
Joe, There are two management commands you can use for this. They aren't well-documented, but there's an example of how to use them at http://www.reviewboard.org/docs/releasenotes/reviewboard/1.6.4/ I don't think there's a strong reason to choose either over the other. It usually comes down more

Re: Migrating from sqlite3 to MySQL or PostgreSQL

2014-04-12 Thread Michael Zhilin
Hi Joe, David, Few years ago I've used Django command dump db to json format. Hope it will be useful for you Best regards, Michael. On Apr 12, 2014 10:30 AM, "David Trowbridge" wrote: > Joe, > > There are two management commands you can use for this. They aren't > well-documented, but there's a

Re: Migrating from sqlite3 to MySQL or PostgreSQL

2014-04-14 Thread Joe
David: When I tried this, I get the following errors: 1. rb-site manage /path/to/site dumpdb > database.json Success. Database.json was created 2. rb-site manage /path/to/site loaddb database.json Interestingly it said that database.json doesn't exist, while it exists. It started running when

Re: Migrating from sqlite3 to MySQL or PostgreSQL

2014-04-15 Thread Joe
Hello, Anyone who can say what could be the issue that I have mentioned below. Best regards, Joe. On Monday, April 14, 2014 3:45:48 PM UTC+2, Joe wrote: > > David: > > When I tried this, I get the following errors: > > 1. rb-site manage /path/to/site dumpdb > database.json > > Success. Databas

Re: Migrating from sqlite3 to MySQL or PostgreSQL

2014-04-15 Thread Christian Hammond
loaddb and loaddata both require that you have an existing database schema in place. You'll need to first use the version of Review Board you were using for the sqlite database. I'm assuming in this case that it's the same one and that you aren't also trying trying to upgrade the software. If you

Re: Migrating from sqlite3 to MySQL or PostgreSQL

2014-04-24 Thread Joe
Hi Christian, Thanks for the details. When I run the below command I get the error --no-initial-data is not an avaialble option. Am I missing something here: # rb-site manage /var/www/reviewboard syncdb -- --no-initial-data Usage: /usr/local/lib/python2.6/dist-packages/ReviewBoard-1.7.22-py2

Re: Migrating from sqlite3 to MySQL or PostgreSQL

2014-04-24 Thread Joe
Hi Christian, It worked when I gave without the "--no-initial-data". So following are the steps I followed: I have assumed the /path/to/reviewboard in my case as /var/www/reviewboard 1. Stop reviewboard 2. # rb-site manage /var/www/reviewboard dumpdb > database.json 3. In reviewboard folder go

Re: Migrating from sqlite3 to MySQL or PostgreSQL

2017-06-05 Thread dave . anderson
I attempted the same, moving from SQLite to MySQL. It didn't go well First I was asked to install a django package, then it tried but failed on a LOT of FK constraints: sudo rb-site manage `pwd` dumpdb > ~/database.json (change settings_local.py) sudo rb-site manage `pwd` loaddb ~/database

Re: Migrating from sqlite3 to MySQL or PostgreSQL

2017-06-05 Thread Christian Hammond
Hi Dave, Converting the data between databases is very tricky. The loaddb/dumpdb scripts were an attempt at this, but we'll be throwing them away, because they were the wrong approach. Off-hand, I don't know why this particular attempt is failing the way it is, but I suspect it's an ordering probl

Re: Migrating from sqlite3 to MySQL or PostgreSQL

2017-06-05 Thread dave . anderson
Sure, I'd be willing to try it, thanks. I'm back up and running on SQLite for now but we haven't rolled out yet so I have a lot of freedom to play with it. I'm going to go back to MySQL and clear out all but the bare schema. On Monday, June 5, 2017 at 2:39:41 PM UTC-7, Christian Hammond wrote: