Your steps look like exactly what I would do, so unless I'm forgetting something, it's correct.
Try considering one more time if you can ask for an export of the whole database + the assetstore, it's much easier and much faster to restore this than to recreate the community/collection structure and import the items. It's like glueing together fragments when you could just ask for the whole vase. Should you need it, here's DSpace database schema (never mind its version, there have been only minor changes since): https://wiki.duraspace.org/display/DSPACE/DSpace+2.0+Requirements+and+Issues#DSpace2.0RequirementsandIssues-DatabaseOverviewGraphic Since AFAIK there are no interface controls in the UIs to do it, should you need to update community/subcommunity or community/collection relationship, here's how you move collection with internal ID 139 (his is not handle) to community 85: UPDATE "community2collection" SET "id" = '139', "community_id" = '85', "collection_id" = '139' WHERE "id" = '139'; If you prefer to create the whole structure by hand, here's how: INSERT INTO "community2community" ("id", "parent_comm_id", "child_comm_id") VALUES ((SELECT max(id)+1 FROM "community2community"), '139', '85'); Remember that only top-level communities don't have a row in the community2community table. Here's how you get the internal resource ID from its handle: SELECT * FROM "handle" WHERE handle LIKE '%/18574'; I think that should be enough to get you started. If you run into any problems, just ask. Regards, ~~helix84 ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
