# Export or copy Microsoft SQL Server data from Ignition?

**URL:** <https://forum.inductiveautomation.com/t/export-or-copy-microsoft-sql-server-data-from-ignition/91706>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [June 11, 2024, 7:32pm UTC](https://forum.inductiveautomation.com/t/export-or-copy-microsoft-sql-server-data-from-ignition/91706 "2024-06-11T19:32:33Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Arnold\_Harrison](https://avatars.discourse-cdn.com/v4/letter/a/74df32/32.png) [@Arnold\_Harrison](https://forum.inductiveautomation.com/u/Arnold_Harrison)\
**Post date:** [June 11, 2024, 7:32pm UTC](https://forum.inductiveautomation.com/t/export-or-copy-microsoft-sql-server-data-from-ignition/91706/1 "2024-06-11T19:32:33Z")

</div>

How can I export or copy my entire Microsoft SQL Server data from Ignition?

---

<div class="post-metadata">

**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\
**Post date:** [June 11, 2024, 8:34pm UTC](https://forum.inductiveautomation.com/t/export-or-copy-microsoft-sql-server-data-from-ignition/91706/2 "2024-06-11T20:34:15Z")

</div>

Do you mean data you've queried from your database or do you mean your database connection setup? What are you trying to accomplish by exporting this? What is the expected workflow?

---

<div class="post-metadata">

**Author:** ![Arnold\_Harrison](https://avatars.discourse-cdn.com/v4/letter/a/74df32/32.png) [@Arnold\_Harrison](https://forum.inductiveautomation.com/u/Arnold_Harrison)\
**Post date:** [June 24, 2024, 1:59pm UTC](https://forum.inductiveautomation.com/t/export-or-copy-microsoft-sql-server-data-from-ignition/91706/3 "2024-06-24T13:59:51Z")

</div>

We would like to use the data externally for personnel w/o access to Ignition for them to analyze the data.

---

<div class="post-metadata">

**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\
**Post date:** [June 24, 2024, 2:06pm UTC](https://forum.inductiveautomation.com/t/export-or-copy-microsoft-sql-server-data-from-ignition/91706/4 "2024-06-24T14:06:57Z")

</div>

Exporting data from SQL has nothing to do with Ignition. Use SSMS and export the data in the way you see fit.

---

<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:** [June 24, 2024, 2:13pm UTC](https://forum.inductiveautomation.com/t/export-or-copy-microsoft-sql-server-data-from-ignition/91706/5 "2024-06-24T14:13:02Z")

</div>

Or provide suitably-credentialed access to your SQL Server to the other personnel.

---

<div class="post-metadata">

**Author:** ![leonardo.godoi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/leonardo.godoi/32/27178_2.png) [@leonardo.godoi](https://forum.inductiveautomation.com/u/leonardo.godoi)\
**Post date:** [June 24, 2024, 2:25pm UTC](https://forum.inductiveautomation.com/t/export-or-copy-microsoft-sql-server-data-from-ignition/91706/6 "2024-06-24T14:25:53Z")

</div>

Query your database from ignition, your result if i'm not mistaken comes in the form of a dataset, use an function like [system.dataset.exportExcel](https://www.docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-dataset/system-dataset-exportExcel) or [system.dataset.exportCSV](https://www.docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-dataset/system-dataset-exportCSV).  
That's what i would do but unfortunately it's been years since i've had the opportunity to work on an ignition project with a database connection.