# In ignition which format data is stored in databases? **URL:** \ **Category:** Ignition\ **Created:** [July 1, 2026, 3:46am UTC](https://forum.inductiveautomation.com/t/in-ignition-which-format-data-is-stored-in-databases/116223 "2026-07-01T03:46:16Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![adithya.karre](https://avatars.discourse-cdn.com/v4/letter/a/eb8c5e/32.png) [@adithya.karre](https://forum.inductiveautomation.com/u/adithya.karre)\ **Post date:** [July 1, 2026, 3:46am UTC](https://forum.inductiveautomation.com/t/in-ignition-which-format-data-is-stored-in-databases/116223/1 "2026-07-01T03:46:16Z")
which type of format data stores in different types of databases in ignition. ---
**Author:** ![michael.flagler](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/michael.flagler/32/26272_2.png) [@michael.flagler](https://forum.inductiveautomation.com/u/michael.flagler)\ **Post date:** [July 1, 2026, 4:30am UTC](https://forum.inductiveautomation.com/t/in-ignition-which-format-data-is-stored-in-databases/116223/2 "2026-07-01T04:30:18Z")
Ignition can work with about every data type possible in databases if you want to use your own table structures. I've written custom software for clients to store their own custom data outside of the historian and transaction modules. ---
**Author:** ![adithya.karre](https://avatars.discourse-cdn.com/v4/letter/a/eb8c5e/32.png) [@adithya.karre](https://forum.inductiveautomation.com/u/adithya.karre)\ **Post date:** [July 1, 2026, 5:06am UTC](https://forum.inductiveautomation.com/t/in-ignition-which-format-data-is-stored-in-databases/116223/3 "2026-07-01T05:06:37Z")
Hi Michael, could you please share custom software for clients. ---
**Author:** ![michael.flagler](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/michael.flagler/32/26272_2.png) [@michael.flagler](https://forum.inductiveautomation.com/u/michael.flagler)\ **Post date:** [July 1, 2026, 5:50am UTC](https://forum.inductiveautomation.com/t/in-ignition-which-format-data-is-stored-in-databases/116223/4 "2026-07-01T05:50:32Z")
I cannot share that as that is proprietary and contains intellectual property of my client. You're not going to be limited by what Ignition can do. It's up to you to program your project to meet your needs. ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [July 1, 2026, 5:56am UTC](https://forum.inductiveautomation.com/t/in-ignition-which-format-data-is-stored-in-databases/116223/5 "2026-07-01T05:56:06Z")
> [@adithya.karre](#): > > could you please share custom software for clients Lol ---
**Author:** ![adithya.karre](https://avatars.discourse-cdn.com/v4/letter/a/eb8c5e/32.png) [@adithya.karre](https://forum.inductiveautomation.com/u/adithya.karre)\ **Post date:** [July 1, 2026, 8:18am UTC](https://forum.inductiveautomation.com/t/in-ignition-which-format-data-is-stored-in-databases/116223/6 "2026-07-01T08:18:00Z")
thank you for your information... were should i look for data store format in ignition. ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [July 1, 2026, 8:25am UTC](https://forum.inductiveautomation.com/t/in-ignition-which-format-data-is-stored-in-databases/116223/7 "2026-07-01T08:25:26Z")
It is not clear what you are trying to do and where you are stuck. Please explain. There is free training available here: > **[Learn Ignition at Your Own Pace](https://inductiveuniversity.com/)** > > Learn SCADA software (and get a credential!) for free with Inductive > University’s online Ignition SCADA courses, taught by industrial automation experts. ---
**Author:** ![adithya.karre](https://avatars.discourse-cdn.com/v4/letter/a/eb8c5e/32.png) [@adithya.karre](https://forum.inductiveautomation.com/u/adithya.karre)\ **Post date:** [July 1, 2026, 8:35am UTC](https://forum.inductiveautomation.com/t/in-ignition-which-format-data-is-stored-in-databases/116223/8 "2026-07-01T08:35:50Z")
i want to know which format data will store in ignition databases. ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [July 1, 2026, 10:59am UTC](https://forum.inductiveautomation.com/t/in-ignition-which-format-data-is-stored-in-databases/116223/9 "2026-07-01T10:59:23Z")
You have said that three times. It does not give us enough information to help you. Write your question in your own language and add a Google translation. Explain clearly what you are trying to understand and where you are stuck. - What kind of information are you trying to store? - What database engine are you using? ---
**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:** [July 1, 2026, 11:16am UTC](https://forum.inductiveautomation.com/t/in-ignition-which-format-data-is-stored-in-databases/116223/10 "2026-07-01T11:16:22Z")
> [@Transistor](#): > > - What kind of information are you trying to store? > - What database engine are you using? This. ↑↑↑ ---
**Author:** ![adithya.karre](https://avatars.discourse-cdn.com/v4/letter/a/eb8c5e/32.png) [@adithya.karre](https://forum.inductiveautomation.com/u/adithya.karre)\ **Post date:** [July 1, 2026, 11:33am UTC](https://forum.inductiveautomation.com/t/in-ignition-which-format-data-is-stored-in-databases/116223/11 "2026-07-01T11:33:38Z")
"I am using Microsoft SQL Server with Ignition. I want to understand how data is stored in the database, what happens if the database connection fails, and how Ignition handles data during a connection loss. Does Ignition buffer/store data locally? If so, where is it stored, and how is it synchronized back to SQL Server once the connection is restored? Please explain the complete data flow briefly." ---
**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:** [July 1, 2026, 11:49am UTC](https://forum.inductiveautomation.com/t/in-ignition-which-format-data-is-stored-in-databases/116223/12 "2026-07-01T11:49:23Z")
> **[Store and Forward | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.3/platform/store-and-forward)** > > The Store and Forward system provides a reliable way for Ignition to store data to the database. In Ignition, systems such as the Tag Historian and SQL Bridge (Transaction Groups) use Store and Forward to ensure that data reaches its destination in... videos about databases / Store and Forward > **[Inductive University Course List - Learn Ignition Free](https://inductiveuniversity.com/courses/ignition/databases-in-ignition/8.3)** > > Learn the fundamentals and advanced features of Ignition while earning your IU credential ---
**Author:** ![adithya.karre](https://avatars.discourse-cdn.com/v4/letter/a/eb8c5e/32.png) [@adithya.karre](https://forum.inductiveautomation.com/u/adithya.karre)\ **Post date:** [July 1, 2026, 12:33pm UTC](https://forum.inductiveautomation.com/t/in-ignition-which-format-data-is-stored-in-databases/116223/13 "2026-07-01T12:33:52Z")
thank you... ---
**Author:** ![smcfarlane](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/smcfarlane/32/42150_2.png) [@smcfarlane](https://forum.inductiveautomation.com/u/smcfarlane)\ **Post date:** [July 1, 2026, 12:38pm UTC](https://forum.inductiveautomation.com/t/in-ignition-which-format-data-is-stored-in-databases/116223/14 "2026-07-01T12:38:55Z")
Ignition has multiple ways of storing data to a database. You can use named queries > **[Using Named Queries - Example | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/platform/sql-in-ignition/named-queries/using-named-queries-example)** > > A Named Query Example You can use python functions to run a sql query right in your python script. > **[system.db.runPrepQuery | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-db/system-db-runPrepQuery)** > > Runs a prepared statement against the database, returning the results in a PyDataSet. Ignition can also store tag values (among other things) in databases in groups using transaction manager > **[Understanding Transaction Groups | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/ignition-modules/sql-bridge-transaction-groups/understanding-transaction-groups)** > > Transaction Group Workspace The most common way ignition stores data to databases is through enabling history on a tag. This will automatically log values on change or on a fixed time interval > **[Configuring Tag History | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/ignition-modules/tag-historian/configuring-tag-history)** > > In 8.1.17, the Tag Editor was redesigned to improve usability. The new Tag Editor now requires fewer clicks and keeps relevant tag information visible while modifying bindings, alarms, and event scripts. To prevent data loss when losing connection to a database, Ignition supports store-and-forward which will keep data locally until a connection to the database can be re-established. The data buffer is not unlimited. If the connection is down for long enough you will lose data. > **[Connections - Store & Forward | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/platform/gateway/status/connections/connections-store-and-forward)** > > Store & Forward The inductive university training goes over all of this in detail. You should start there. ---
**Author:** ![adithya.karre](https://avatars.discourse-cdn.com/v4/letter/a/eb8c5e/32.png) [@adithya.karre](https://forum.inductiveautomation.com/u/adithya.karre)\ **Post date:** [July 1, 2026, 12:42pm UTC](https://forum.inductiveautomation.com/t/in-ignition-which-format-data-is-stored-in-databases/116223/15 "2026-07-01T12:42:51Z")
thank you, now i received correct information. ---
**Author:** ![michael.flagler](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/michael.flagler/32/26272_2.png) [@michael.flagler](https://forum.inductiveautomation.com/u/michael.flagler)\ **Post date:** [July 3, 2026, 2:22pm UTC](https://forum.inductiveautomation.com/t/in-ignition-which-format-data-is-stored-in-databases/116223/16 "2026-07-03T14:22:47Z")
> [@smcfarlane](#): > > The data buffer is not unlimited It may not be, but I had Maker running at home and forgot to start my DB one day and came back it a few weeks later and had 14 million records in S&F. Started the DB and they all flushed/forwarded just fine. ---
**Author:** ![Alistair](https://avatars.discourse-cdn.com/v4/letter/a/f6c823/32.png) [@Alistair](https://forum.inductiveautomation.com/u/Alistair)\ **Post date:** [July 6, 2026, 4:33am UTC](https://forum.inductiveautomation.com/t/in-ignition-which-format-data-is-stored-in-databases/116223/17 "2026-07-06T04:33:17Z")
14 million records at home?! Serious stuff 👍 ---
**Author:** ![michael.flagler](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/michael.flagler/32/26272_2.png) [@michael.flagler](https://forum.inductiveautomation.com/u/michael.flagler)\ **Post date:** [July 6, 2026, 6:10am UTC](https://forum.inductiveautomation.com/t/in-ignition-which-format-data-is-stored-in-databases/116223/18 "2026-07-06T06:10:04Z")
I've got a 48 port switch that I'm monitoring the bandwidth (both Rx and TX) on every port every few seconds plus other values around the house, but the bandwidth was a test to see what I could get it to do on my home network for historian. On my old hardware it was flushing the records to TimescaleDB at about 5-6k records per second.