View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004298 | mantisbt | upgrade | public | 2004-08-09 12:21 | 2012-02-20 07:18 |
| Reporter | DamienMcKenna | Assigned To | grangeway | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | no change required | ||
| Product Version | git trunk | ||||
| Summary | 0004298: Database exporter | ||||
| Description | Now that ADOdb is used to provide a database abstraction layer, a tool is needed to convert from the old MySQL tables directly to the desired database. Could also be expanded to allow at-will migration from database to database. | ||||
| Tags | No tags attached. | ||||
|
You mean you want a tool that can take the old MySQL database and produce a file that, once loaded into the same tool configured to use f.e. a MSSQL database, will reproduce the content in the new database? |
|
|
jlatour: Perhaps. I was really thinking of during the upgrade process it would pick up the old db settings and allow you to keep them or change them; if you select to change the db it would automatically upload the contents from the old database for you. |
|
|
But... why? If you already have a database... After all, right now MySQL is still the only database we support, so why should we ask them if they want to use another database? |
|
|
I was under the impression that other databases were being supported with 0.19... as for why to change database, some companies use one as standard but use others when they have to so they can run a specific tool. |
|
|
Other databases should work, or be easier to get working because of our use of ADODB, but we still do not officially support them. Of course if you try getting Mantis to work with a certain database server and encounter problems, feel free to report them so we can try to resolve them. As for your request, I'm more inclined towards adding a migration tool that can be used for other purposes as well. That should work, shouldn't it? |
|
|
Indeed it should. |
|
|
I'm also interested in such a tool, because I want to migrate only a portion of an older mantis database to the new format. Any updates on this? |
|