# FactorySQL migration to Ignition

**URL:** <https://forum.inductiveautomation.com/t/factorysql-migration-to-ignition/14397>\
**Category:** Ignition\
**Created:** [May 25, 2017, 10:05pm UTC](https://forum.inductiveautomation.com/t/factorysql-migration-to-ignition/14397 "2017-05-25T22:05:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![heybales](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/heybales/32/3358_2.png) [@heybales](https://forum.inductiveautomation.com/u/heybales)\
**Post date:** [May 25, 2017, 10:05pm UTC](https://forum.inductiveautomation.com/t/factorysql-migration-to-ignition/14397/1 "2017-05-25T22:05:37Z")

</div>

I have a customer running FactorySQL version 5 (this is reported in the export) who is planning to migrate to Ignition. I see a couple of mentions in the forum of “legacy import” but no mention of this in current documentation.

Is there a way to automate this?

Also, will SQL Bridge write to the existing tables in the same manner so that existing custom reporting software will still work?

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [May 26, 2017, 12:31pm UTC](https://forum.inductiveautomation.com/t/factorysql-migration-to-ignition/14397/2 "2017-05-26T12:31:45Z")

</div>

Legacy Upgrade is in the Backup/Restore section of the gateway. When I had done it (this was back in 7.0), it was pretty seamless, but there is a separate tool that Colby had talked about:

[http://forum.inductiveautomation.com/t/upgrading-from-factorysql-to-ignition-when-problems-arise/3454?u=jordancclark](http://forum.inductiveautomation.com/t/upgrading-from-factorysql-to-ignition-when-problems-arise/3454?u=jordancclark)

---

<div class="post-metadata">

**Author:** ![heybales](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/heybales/32/3358_2.png) [@heybales](https://forum.inductiveautomation.com/u/heybales)\
**Post date:** [May 26, 2017, 7:04pm UTC](https://forum.inductiveautomation.com/t/factorysql-migration-to-ignition/14397/3 "2017-05-26T19:04:53Z")

</div>

@JordanCClark, thanks for that. I don’t know how I missed that. FYI, the import has been enhanced to give you options of importing to an existing project, mapping to existing DB connections, and specifying which groups to import.

I am once again pleased by the functionality and elegance of this product.

@Colby.Clegg will SQL Bridge write to the existing tables in the same manner so that existing custom reporting software will still work? And legacy data will be preserved?

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [May 31, 2017, 11:05pm UTC](https://forum.inductiveautomation.com/t/factorysql-migration-to-ignition/14397/4 "2017-05-31T23:05:52Z")

</div>

Hi,

Sorry for the delay- but yeah, it should all work the same, with the existing tables, and it shouldn’t affect the previous data.