I have a web applcation deployed in GateIn 3.1. I changed the database from hsqldb to Oracle by editing the configuration.properties(GateIn-3.1.0-GA\server\default\conf\gatein\configuration.properties) and tables were generated both in idm and jcr services.
The problem is with data migration.I had added several portlets before changing the database connection to Oracle, and that data resides in hsqldb.How can i migrate those data to Oracle, so that i don't need to start from scratch.Is there any migration tool available or any other mechanism which could transfer data without any loss. Thanks in advance....
Hi Poornima, there is. Gatein Management tool. It's still work in progress but already usable. You can export/import portal layout, pages and navigation. Try using the version 1.0.0.alpha02 which should be usable on GateIn 3.1. The bits are attached to this doc by Nick Scavelli: http://community.jboss.org/wiki/GateIn-ExportImport.
Thanks for the quick reply.
I could export data using the command line tool.But was unable to import data using it.
Can u plz help me to fix this.
This is the exception i am getting while importing data
2011-10-14 19:40:22,158 INFO [Importer] Starting import of file epp-exports\portal-objects_2011-10-14_12-28-24.zip for portal container portal
2011-10-14 19:40:22,376 INFO [Importer] Overwrite set to true, overwriting all data.
2011-10-14 19:40:22,689 ERROR [ImportHandler] Exception during import.
2011-10-14 19:40:22,720 INFO [ImportHandler] Rolling back any changes that occurred during import.
2011-10-14 19:40:22,720 INFO [ImportHandler] No portal configs were overwritten during import
2011-10-14 19:40:22,720 INFO [ImportHandler] No portal configs were creating during import
2011-10-14 19:40:22,720 INFO [ImportHandler] No pages were overwritten during import
2011-10-14 19:40:22,720 INFO [ImportHandler] No pages were creating during import
2011-10-14 19:40:22,720 INFO [ImportHandler] No navigations were overwritten during import
2011-10-14 19:40:22,720 INFO [ImportHandler] No navigations were creating during import
2011-10-14 19:40:22,720 INFO [Importer] Import was successful.