Changes between Version 67 and Version 68 of 0.12/TracFaq

Timestamp:

Sep 10, 2004, 1:07:33 PM (20 years ago)

Author:

leigh_trac@…

Comment:

Possible approach to migrating of tickets from one Trac installation to another.

0.12/TracFaq

@@ -171 +171 @@
 For example, is it possible to import and export in the same way as one can using trac-admin for the wiki?
 
+A possible approach (until someone comes up with a better one?!) is to use the sqlite engine to export the tickets and changes, generate a script, and then insert the records into the second trac installation. E.g.:
+
+::
+
+  [root@xgbemf6002 root]# sqlite <path/to/trac_project/db/trac.db>
+  SQLite version 2.8.15
+  Enter ".help" for instructions
+  sqlite> select * from ticket;
+  1|1092797666|1094723786|component1|normal|normal|Martin|someone@somewhere.com|||||reopened||test|testing|
+  sqlite> select * from ticket_change;
+  1|1092798124|leigh|comment||Testing notification
+  1|1092798319|leigh|owner|somebody|Leigh
+  ...
+  ...
+
+
+It should be possible to take this output , and produce a script that would insert records into the ticket and ticket_change tables in the new trac installation.
+
+As provided below, the database schema can be found here_.
+
+.. _here: http://projects.edgewall.com/trac/file/trunk/trac/db_default.py?rev=latest
+
+
 Can Trac automatically update a ticket when I commit a changeset?
 -----------------------------------------------------------------