Database Migration from RB-Beta to RB-1.0.3

[Kunjal]

Hello,

We have existing RB-Beta setup on linux machine.
We have MySql database with lots of review data. (20,000 +)
Now, as more and more team are comply with ReviewBoard usage, we want
to move foraward with RB 1.0.3.

We have purchased new server to install latest version. My issue is
how the existing database from RB-Beta verison will migrate to
RB-1.0.3?

Do you provide any tool utility to export database tables in such a
way that if you have introduce any new tables as part of latest 1.0.3
release, our data still remains ok?

Thanks
Kunjal

[Christian Hammond]

Hi,

We use a database schema migration tool called django-evolution, which rb-site invokes on upgrades. You should be able to move your existing database and site installation over to the new server, install the new Review Board 1.0.4, and run rb-site upgrade on the site directory.

Of course, make sure you have a backup in case anything goes wrong.

Christian

--
Christian Hammond - chi...@chipx86.com
Review Board - http://www.reviewboard.org
VMware, Inc. - http://www.vmware.com

To unsubscribe from this group, send email to
reviewboard...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/reviewboard?hl=en
-~----------~----~----~----~------~----~------~--~---

[Kunjal]

Thanks Chris,

The existing reviewboard database is on machine X.
The new RB installation is on machine Y.
When I run the rb-site upgrade on machine Y, how it will find the
database stored in machine X?

-Kunjal

On Oct 20, 5:07 pm, Christian Hammond <chip...@chipx86.com> wrote:
> Hi,
>
> We use a database schema migration tool called django-evolution, which
> rb-site invokes on upgrades. You should be able to move your existing
> database and site installation over to the new server, install the new
> Review Board 1.0.4, and run rb-site upgrade on the site directory.
>
> Of course, make sure you have a backup in case anything goes wrong.
>
> Christian
>
> --

> Christian Hammond - chip...@chipx86.com
> Review Board -http://www.reviewboard.org
> VMware, Inc. -http://www.vmware.com

>
>
>
> On Tue, Oct 20, 2009 at 4:14 PM, Kunjal <kunjal.par...@gmail.com> wrote:
>
> > Hello,
>
> > We have existing RB-Beta setup on linux machine.
> > We have MySql database with lots of review data. (20,000 +)
> > Now, as more and more team are comply with ReviewBoard usage, we want
> > to move foraward with RB 1.0.3.
>
> > We have purchased new server to install latest version. My issue is
> > how the existing database from RB-Beta verison will migrate to
> > RB-1.0.3?
>
> > Do you provide any tool utility to export database tables in such a
> > way that if you have introduce any new tables as part of latest 1.0.3
> > release, our data still remains ok?
>
> > Thanks
> > Kunjal
>
> > > To unsubscribe from this group, send email to

> > reviewboard...@googlegroups.com<reviewboard%2Bunsubscribe@googlegr­oups.com>

> > For more options, visit this group at
> >http://groups.google.com/group/reviewboard?hl=en

> > -~----------~----~----~----~------~----~------~--~---- Hide quoted text -
>
> - Show quoted text -

[Christian Hammond]

You will need to copy the database over. That's something Review Board can't help with. Either copy over the entire database directory, or do an SQL dump using the database's own tools and re-integrate that into your new database on the new server.

Christian

--

Christian Hammond - chi...@chipx86.com
Review Board - http://www.reviewboard.org
VMware, Inc. - http://www.vmware.com