I have had great luck with pgloader transfering data excerpt for one table, plugindata. Does anyone have any hints on the proper casting for the fields? The problem field seems to be named data and defined as a LONGBLOB. The migration is from MySQL 5.1 to Postgresql 9.3 using pgloader version "3.2.0"
Examples of the pgloader errors:
The value 33354273 is not of type (UNSIGNED-BYTE 24).
DEBUG copy-batch plugindata 5 rows [oversized]
Unfortunately sometimes it's just not possible. Not only the XML may take hours (10+) before it fails:
root cause java.lang.ClassNotFoundException: javax.xml.bind.DatatypeConverter not found by com.atlassian.activeobjects.activeobjects-plugin 
And in addition there's no guaranty that even if this specific problem is solved, there won't be more problems after that. Kind of tree hiding the forest situation...
In those situations, a direct DB migration would be a better strategy.
Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events