Page 1 of 1

Copying parts of mantis database

Posted: 14 Dec 2005, 12:44
by winuel
Hi,

did anyone copy part of projects from one mantis server to another? Is it possible to make a simple select from one database and insert to another and it will work?


cheers,
winuel

Posted: 14 Dec 2005, 21:01
by vboctor
If you manage to maintain the same ids for the entities, it will probably work. Maintaining ids is important for the following reasons:

- To keep the links between the different tables intact (e.g. links between issues and their notes, relationships, etc).
- To keep the embedded links to issues and issue notes working. For example, if a description of an issue refers to another one via # [issue number] or ~ [note number].

Regards,
Victor
Checkout Mantis Blog
http://www.futureware.biz/