On Tuesday, January 16, 2018 at 8:28:57 AM UTC-8, W. Martin Borgert wrote: > > Hi, > > I like to Trac instances. Both instances have tickets, wiki, and git > repos. > I'm using Trac 1.2 with PostgreSQL on Debian stable. > I came across > https://reinout.vanrees.org/weblog/2009/05/28/merging-trac.html, > but it does not talk about tickets, users, milestones, etc. > Does anybody know of a more complete recipe? > > TIA! >
* Git repository is very simple: Just add the Git repository to the configuration and resync if you have a cached repository type. * Wiki is simple if there are no page name collisions. You can just export/import using TracAdmin. However, you can also do this by dump/load of the wiki table, and since you have to handle a number of other tables, that is the way to go. * Milestones are stored in the database, so you can do a database dump/load of the table, and it will go smooth assuming there are no naming collisions * You can dump and reload tickets from the database, but the ticket numbering will change, assuming the ticket numbering of both system started at 1. You could dump the ticket table, change the numbering by an offset and load into the new system. You'll need to modify the attachments, ticket_custom and the ticket_change tables as well, to account for the new ticket ids. * There are some other tables you should be concerned with, like Versions, Priorities ... and other associated with the ticket system. Also, the permissions table. Here is the list of tables: https://trac.edgewall.org/wiki/TracDev/DatabaseSchema * You can ignore: auth_cookie, cache, node_change, revision. As mentioned, I'd also ignore the repository table and just add the new repository manually. * Users - depends on the authentication mechanism. It might just be a matter of merging htpasswd or htdigest files. I'd start with a backup of both systems and start working on a script. Feel free to post here for advice on the script as it progresses. If you refine the script it could be posted as a script on trac-hacks.org, so happy to help you get it refined. The trac-admin hotcopy utility can be used to dump the database on the system you are migrating away from. Which Trac version and which database type? Do you have plugins installed? - Ryan -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/trac-users. For more options, visit https://groups.google.com/d/optout.
