-
Type:
Suggestion
-
Resolution: Unresolved
-
Component/s: Jira - Migration Assistant - Export
-
None
-
2
Sometimes the source server site can’t be used for migrations due to reasons like
- Upgrade is not possible on production site
- Networking can’t be opened from source site.
In phased migrations this increases the risk of duplicates. As every time the clone is created for a new phase, it has no history of the past migrations.
This feature request has been opened to allow the ability of taking backup of JCMA tables on Jira servers and then restoring that backup on the next version of the clone server (which has no history of previous migration history)
Workaround
Manually export/import JCMA tables.
- Getting the list of JCMA tables
PostgreSQL
SELECT tablename FROM pg_catalog.pg_tables where tablename like 'AO_6FF49D_%' ; - Export the data into CSV files, from Clone instance: How to Export PostgreSQL Data to a CSV or Excel File
- Import the data into source source instance: Importing Data from CSV in PostgreSQL