408032 - [Oracle] Make bzdbcopy.pl work with Oracle

Status: RESOLVED FIXED

(Bugzilla :: Database, enhancement)

Description

[Max Kanat-Alexander]

bzdbcopy and Bugzilla in general require a few modifications in order to make bzdbcopy.pl work with Oracle.

Comment 1

[Max Kanat-Alexander]

Attachment: v1

Okay, here we go! I'm glad that bzdbcopy is a contrib script, because there's some pretty hackish stuff in here. :-)

Anyhow, this worked fine to copy over the bugs_tip database to Oracle on landfill, so I'm pronouncing it done.

Comment 2

[Max Kanat-Alexander]

Oh, and the patch also fixes a totally separate bug about Oracle naming FK triggers incorrectly.

And it also makes bzdbcopy output nice progress indicators using indicate_progress.

Comment 3

[Max Kanat-Alexander]

Okay, I'm granting myself approval now, but I'm going to sleep on this before checking it in.

Comment 4

[Max Kanat-Alexander]

Attachment: v2

Okay, glad I slept on it. I found a few things that needed fixing or improving.

Comment 5

[Max Kanat-Alexander]

Checking in Bugzilla/DB.pm;
/cvsroot/mozilla/webtools/bugzilla/Bugzilla/DB.pm,v  <--  DB.pm
new revision: 1.105; previous revision: 1.104
done
Checking in Bugzilla/DB/Oracle.pm;
/cvsroot/mozilla/webtools/bugzilla/Bugzilla/DB/Oracle.pm,v  <--  Oracle.pm
new revision: 1.3; previous revision: 1.2
done
Checking in Bugzilla/DB/Schema.pm;
/cvsroot/mozilla/webtools/bugzilla/Bugzilla/DB/Schema.pm,v  <--  Schema.pm
new revision: 1.94; previous revision: 1.93
done
Checking in Bugzilla/DB/Schema/Mysql.pm;
/cvsroot/mozilla/webtools/bugzilla/Bugzilla/DB/Schema/Mysql.pm,v  <--  Mysql.pm
new revision: 1.19; previous revision: 1.18
done
Checking in Bugzilla/DB/Schema/Oracle.pm;
/cvsroot/mozilla/webtools/bugzilla/Bugzilla/DB/Schema/Oracle.pm,v  <--  Oracle.pm
new revision: 1.3; previous revision: 1.2
done
Checking in Bugzilla/Install/Util.pm;
/cvsroot/mozilla/webtools/bugzilla/Bugzilla/Install/Util.pm,v  <--  Util.pm
new revision: 1.11; previous revision: 1.10
done
Checking in contrib/bzdbcopy.pl;
/cvsroot/mozilla/webtools/bugzilla/contrib/bzdbcopy.pl,v  <--  bzdbcopy.pl
new revision: 1.6; previous revision: 1.5
done
Checking in template/en/default/global/messages.html.tmpl;
/cvsroot/mozilla/webtools/bugzilla/template/en/default/global/messages.html.tmpl,v  <--  messages.html.tmpl
new revision: 1.68; previous revision: 1.67
done