Import XML file data direct into Database

[Suresh Choudhari]

Can I import XML file data directly into a database table?

Is there any way that I can do this in server instance?

Or if there is any way by programmatically so what is the way?

[Nic Brough -Adaptavist-]

No.  The xml is not a database structure, it's a Jira structure - you need a Jira to read it correctly.

Programatically you can do it - you will need to replicate all of the code that does an import from xml in Jira and writes it back into the database.

[Suresh Choudhari]

I want to move one project from one jira cloud instance to another jira cloud instance..

I was trying using server instance but for a server instance, I need to configure the server properties which is Custom Field Type, Workflows and workflow schemes, Issue Types, status, etc.  but the limitation is I don't have admin access to jira cloud instance from which I need to export the project.

Is there any way that I can do this using the backup XML file. 
Or I can find a way to prepare my server instance same as cloud and do importing things? 

Is there any tool which I can use?

[Nic Brough -Adaptavist-]

Cloud to Cloud project migrations are not easy and there's no way to do it in full with Apps.  You have to download BOTH Cloud systems with the backup XML, create a temporary server system from the download of the target system, merge in the project(s) from the download of the system that has the one(s) to move, then re-upload the new data into the Cloud, overwriting the old system.

[Dave Theodore [Coyote Creek Consulting]]

What are you trying to do?