# Export Project - Compare named queries for changes

**URL:** <https://forum.inductiveautomation.com/t/export-project-compare-named-queries-for-changes/54992>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [January 13, 2022, 6:06pm UTC](https://forum.inductiveautomation.com/t/export-project-compare-named-queries-for-changes/54992 "2022-01-13T18:06:14Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![fleclerc](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/fleclerc/32/20480_2.png) [@fleclerc](https://forum.inductiveautomation.com/u/fleclerc)\
**Post date:** [January 13, 2022, 6:06pm UTC](https://forum.inductiveautomation.com/t/export-project-compare-named-queries-for-changes/54992/1 "2022-01-13T18:06:14Z")

</div>

We are comparing exported projects using the lastModification.timestamp in “resource.json” to find out what was changed. It does not work for Named Query, because in Designer, simply opening a Named Query and saving a project cause it to be “modified” even without change it.

Is there a way to compare two “data.bin” of the same Named Query to check if it is identical or not?

Is there other ways to compare two Named Query automaticly?

---

<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:** [January 13, 2022, 6:57pm UTC](https://forum.inductiveautomation.com/t/export-project-compare-named-queries-for-changes/54992/2 "2022-01-13T18:57:05Z")

</div>

If you upgrade, named queries will be serialized into a `query.sql` file on disk.

---

<div class="post-metadata">

**Author:** ![fleclerc](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/fleclerc/32/20480_2.png) [@fleclerc](https://forum.inductiveautomation.com/u/fleclerc)\
**Post date:** [January 14, 2022, 1:23am UTC](https://forum.inductiveautomation.com/t/export-project-compare-named-queries-for-changes/54992/3 "2022-01-14T01:23:14Z")

</div>

Funny, I just upgraded from 8.1.3 to 8.1.13 this week, but havent exported my project yet.

It seems, that only Named Queries **with no parameters** are exported as **query.sql** file; those with parameters are still as **data.bin**.

---

<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:** [January 14, 2022, 4:09pm UTC](https://forum.inductiveautomation.com/t/export-project-compare-named-queries-for-changes/54992/4 "2022-01-14T16:09:19Z")

</div>

That’s not the condition. The condition is opening them at least once in the designer.

---

<div class="post-metadata">

**Author:** ![fleclerc](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/fleclerc/32/20480_2.png) [@fleclerc](https://forum.inductiveautomation.com/u/fleclerc)\
**Post date:** [January 14, 2022, 9:29pm UTC](https://forum.inductiveautomation.com/t/export-project-compare-named-queries-for-changes/54992/5 "2022-01-14T21:29:29Z")

</div>

It is wonderful, I just reopened some of my queries and now they are exported as “query.sql”. It will be really helpful to found changes (of the lack of) between versions.

It is a real pleasure to see how quick Ignition is improving vs the competition.

---

<div class="post-metadata">

**Author:** ![fleclerc](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/fleclerc/32/20480_2.png) [@fleclerc](https://forum.inductiveautomation.com/u/fleclerc)\
**Post date:** [January 19, 2022, 7:43pm UTC](https://forum.inductiveautomation.com/t/export-project-compare-named-queries-for-changes/54992/6 "2022-01-19T19:43:04Z")

</div>

What is the Gateway version needed for queries to be serialized into query.sql?

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [January 19, 2022, 7:58pm UTC](https://forum.inductiveautomation.com/t/export-project-compare-named-queries-for-changes/54992/7 "2022-01-19T19:58:51Z")

</div>

8.1.6+