Best method for combining buzilla installs

[DAngelo, Michael]

We currently have two bugzilla instances;  version 2.22.2 and 3.2.2.   Each DB has about 100 bugs.
The original persons who set up our bugzilla versions have left the company.

We have a DBA who will perform this change.

We want to copy these over to one DB, version 3.2.4.  This is a brand new install and everything is default.
All DBs are My SQL

I realize when we combine the two into one DB we will have to change the bug numbers to prevent duplicates.
I believe we need to run checksetup.pl to convert the databases the the 3.2.4 version.

The 3.2.2 version has one custom field. The 2.22.2 version has no custom fields.

Questions:

1.       What is the best method to accomplish what we want to do?

2.       If combining is impractical, can we support two DBs in one instance of bugzilla?

3.       When we convert bug #s, assuming we combine the two DBs into one, will this cause a problem if we change them to something like old-bug#?  Basically append the work "old-" to the beginning of the bug#.

4.       Any other ideas/suggestions?



Thank You

---------------------------------------
Michael D'Angelo
Program Manager
PMO Office
Spansion Inc.
Michael.DAngelo@...<mailto:Michael.DAngelo@...>
[phone]
x48089
_______________________________________________
support-bugzilla mailing list
support-bugzilla@...
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put support-bugzilla@... in the To: field when you reply.

[Gervase Markham]

On 02/11/09 21:59, DAngelo, Michael wrote:

> We currently have two bugzilla instances;  version 2.22.2 and 3.2.2.
> Each DB has about 100 bugs. The original persons who set up our
> bugzilla versions have left the company.
>
> We have a DBA who will perform this change.
>
> We want to copy these over to one DB, version 3.2.4.  This is a brand
> new install and everything is default. All DBs are My SQL
>
> I realize when we combine the two into one DB we will have to change
> the bug numbers to prevent duplicates. I believe we need to run
> checksetup.pl to convert the databases the the 3.2.4 version.
>
> The 3.2.2 version has one custom field. The 2.22.2 version has no
> custom fields.
>
> Questions:
>
> 1.       What is the best method to accomplish what we want to do?

Upgrade both to 3.2.4 separately. Then either:

- Turn on and try and use the "Move Bugs" system.
or
- Use the XML export and import.

Trying to manually merge the databases sounds to me like it would be
fairly complicated.

> 2.       If combining is impractical, can we support two DBs in one
> instance of bugzilla?

No.

> 3.       When we convert bug #s, assuming we combine the two DBs into
> one, will this cause a problem if we change them to something like
> old-bug#?  Basically append the work "old-" to the beginning of the
> bug#.

I don't quite understand what you are asking here. Are you talking about
the bug numbers linked in the comments?

> 4.       Any other ideas/suggestions?

You could use the very new migration framework in 3.5.x and write a
Bugzilla to Bugzilla migrator. :-) That's probably going to be the best
way to do it in the future. But if you want to stick with a stable
version, it might not be best for you.

Gerv
_______________________________________________
support-bugzilla mailing list
support-bugzilla@...
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put support-bugzilla@... in the To: field when you reply.