Upgrade mantis to 1.2.3 - Copy custom field Target Version

[jeremfg]

Hi...

We have been using Mantis 1.0.7 for a few years now here at the space agency, and are now preparing for migrating it to our new clustered servers...
Since there are quite a few interesting new features, we also decided to upgrade.
In order to use the new roadmap feature, I've learned that it uses the new «Target Version» field.

We have been using our own «Target version» (spelled exactly like that) field and I'm looking for a way to copy this data to the new field...

I've been looking at the latest stable version : 1.2.3 There is a functionnality called «Copy Custom Field to Standard Field» in the «System Utilities» section of Admin. However it does not seem to be fully implemented yet.

My question is:
1. Is there a sql script currently existing that I could use? My custom field is currently only a string field, not an enumeration one. So there might be some bad data integrity. If we loose a few target versions during the process, we wouldn't be too sad. Those string match the displayed value stored in the versions dropdown.

2. If there is none, could you tell me what I need to make one? Like in witch tables are the new Target Version stored, etc...

Thank you for your help!

[atrol]

Versions are stored in table mantis_project_version_table
You could use the UI of MantisBT (Manage -> Manage Projects) to add the versions and to fill the table.
After that you can assign the target version to issues by updating the column target_version of table mantis_bug_table