Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

merge two bugzilla database

4 views
Skip to first unread message

Srinivas

unread,
Jul 12, 2004, 12:32:54 AM7/12/04
to
hi all,

i have bugzilla running on two different servers(redhat9),

is there any way to merge two into one server, any perl script to get the
two data merged in to one database..??

any help or url on the internet will do,

thanks in advance

Srinivas S


Gervase Markham

unread,
Jul 14, 2004, 4:34:55 PM7/14/04
to
Srinivas wrote:
> i have bugzilla running on two different servers(redhat9),
>
> is there any way to merge two into one server, any perl script to get the
> two data merged in to one database..??

Nope - I'm afraid you'll need to do this by hand. XML export and import
is probably the way to go.

Gerv

Eladamry

unread,
Jul 16, 2004, 9:18:00 AM7/16/04
to
Gervase Markham <ge...@mozilla.org> wrote in message news:<cd45dq$lr...@ripley.netscape.com>...

> Nope - I'm afraid you'll need to do this by hand. XML export and import
> is probably the way to go.
>
> Gerv

You will need to write a layer which increments bug ids in all tables
one db by the number of bugs in the other db. Otherwise, bug ids will
clash.

Gervase Markham

unread,
Jul 19, 2004, 9:25:55 AM7/19/04
to
Eladamry wrote:

> You will need to write a layer which increments bug ids in all tables
> one db by the number of bugs in the other db. Otherwise, bug ids will
> clash.

I believe XML import ignores the bug number field in the XML.

Gerv

Eladamry

unread,
Jul 20, 2004, 12:03:29 PM7/20/04
to
Gervase Markham <ge...@mozilla.org> wrote in message
> I believe XML import ignores the bug number field in the XML.
>
> Gerv

What about bug numbers in dependency lists, keywords, etc? I would
imagine keeping those around would create a lot of confusion, as they
would be pointing toward the wrong things. Getting rid of bug numbers
completely would turn the bugzilla bug tacking system into nothing
better than a bunch of non-interconnected sticky notes.

Am I missing something about XML import/export utility?

Gervase Markham

unread,
Jul 21, 2004, 8:15:10 AM7/21/04
to
Eladamry wrote:
> What about bug numbers in dependency lists, keywords, etc?

I don't know of any situation where keywords could contain bug numbers.

The import script was designed for moving individual bugs from one
Bugzilla to another. Therefore it can't assume much about the
relationship between the two. So, for example, all the comments in the
bug are catted into the Initial Description in the new bug, because
people on one Bugzilla may not have accounts on the other.

> Am I missing something about XML import/export utility?

Its original purpose :-)

If you want to do better, you'll need to write a script for your
specific situation.

Gerv

Gisbert Amm

unread,
Dec 21, 2005, 3:36:11 AM12/21/05
to

Did anything come off it at that time? I got the same problem - merge
two bugzilla databases - and would be very interested in any working
solution.

I suppose the two Bugzilla instances have to have the same major
version. Is that right?

Thanks in advance for your help,
Gisbert

0 new messages