View Issue Details

IDProjectCategoryView StatusLast Update
0004298mantisbtupgradepublic2012-02-20 07:18
ReporterDamienMcKenna Assigned Tograngeway  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionno change required 
Product Versiongit trunk 
Summary0004298: 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.

TagsNo tags attached.

Activities

jlatour

jlatour

2004-08-09 12:23

reporter   ~0006882

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?

DamienMcKenna

DamienMcKenna

2004-08-09 12:33

reporter   ~0006883

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.

jlatour

jlatour

2004-08-09 12:40

reporter   ~0006884

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?

DamienMcKenna

DamienMcKenna

2004-08-09 15:16

reporter   ~0006889

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.

jlatour

jlatour

2004-08-09 15:31

reporter   ~0006890

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?

DamienMcKenna

DamienMcKenna

2004-08-09 16:48

reporter   ~0006894

Indeed it should.

dingetje

dingetje

2005-03-09 10:45

reporter   ~0009502

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?