# Transaction group migration from factorysql to ignition 7.8.4

**URL:** <https://forum.inductiveautomation.com/t/transaction-group-migration-from-factorysql-to-ignition-7-8-4/17479>\
**Category:** Ignition\
**Created:** [March 23, 2018, 6:10pm UTC](https://forum.inductiveautomation.com/t/transaction-group-migration-from-factorysql-to-ignition-7-8-4/17479 "2018-03-23T18:10:57Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![roshanbhosale](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/roshanbhosale/32/4899_2.png) [@roshanbhosale](https://forum.inductiveautomation.com/u/roshanbhosale)\
**Post date:** [March 23, 2018, 6:10pm UTC](https://forum.inductiveautomation.com/t/transaction-group-migration-from-factorysql-to-ignition-7-8-4/17479/1 "2018-03-23T18:10:57Z")

</div>

Hi,  
Is there any easier way to migrate transaction groups from FactorySQL to ignition 7.8.4  
Currently, I found out that, factorySQL only export transaction groups in.CSV format and ignition 7.8.4 imports transaction groups in either binary or XML format.

I didn’t found any fastest way of doing so, I started migrating transaction groups one by one manually.  
But since the groups are in large numbers (around 400 with additional block groups having more than 20 tags in each) it will consume much time to do so.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [March 23, 2018, 6:15pm UTC](https://forum.inductiveautomation.com/t/transaction-group-migration-from-factorysql-to-ignition-7-8-4/17479/2 "2018-03-23T18:15:07Z")

</div>

Take one of the transaction groups you’ve converted manually and export it as XML. Compare it against the original CSV to produce a python or PHP script that will produce that XML from the CSV content. Prepare a loop that reads the CSV and spits out the XML to import.

---

<div class="post-metadata">

**Author:** ![roshanbhosale](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/roshanbhosale/32/4899_2.png) [@roshanbhosale](https://forum.inductiveautomation.com/u/roshanbhosale)\
**Post date:** [March 23, 2018, 6:27pm UTC](https://forum.inductiveautomation.com/t/transaction-group-migration-from-factorysql-to-ignition-7-8-4/17479/3 "2018-03-23T18:27:33Z")

</div>

Thanks for the reply @pturmel ,i will try the resolution suggested by you.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [March 23, 2018, 7:44pm UTC](https://forum.inductiveautomation.com/t/transaction-group-migration-from-factorysql-to-ignition-7-8-4/17479/4 "2018-03-23T19:44:21Z")

</div>

You can restore a full backup (rather than an individual group export) from FactorySQL into any Ignition version; go to Configure → Backup/Restore → Legacy Upgrade:

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/49336d982831b102e913fc03c68c912926031a58.png)

---

<div class="post-metadata">

**Author:** ![roshanbhosale](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/roshanbhosale/32/4899_2.png) [@roshanbhosale](https://forum.inductiveautomation.com/u/roshanbhosale)\
**Post date:** [March 23, 2018, 7:57pm UTC](https://forum.inductiveautomation.com/t/transaction-group-migration-from-factorysql-to-ignition-7-8-4/17479/5 "2018-03-23T19:57:42Z")

</div>

In ignition some of the transaction groups are already running … and most importantly, we cant shutdown the ignition even for few seconds since it is playing an important role in the plant architecture which is running 24/7.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [March 23, 2018, 8:07pm UTC](https://forum.inductiveautomation.com/t/transaction-group-migration-from-factorysql-to-ignition-7-8-4/17479/6 "2018-03-23T20:07:26Z")

</div>

Then install a local copy of Ignition that’s not connected to any databases, restore the FSQL backup, and export the groups from that instance so that you can import them to the main server.