# Wonderware Historian Data

**URL:** <https://forum.inductiveautomation.com/t/wonderware-historian-data/2200>\
**Category:** Ignition\
**Created:** [September 15, 2010, 3:01pm UTC](https://forum.inductiveautomation.com/t/wonderware-historian-data/2200 "2010-09-15T15:01:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Joseph\_Mendonca](https://avatars.discourse-cdn.com/v4/letter/j/58f4c7/32.png) [@Joseph\_Mendonca](https://forum.inductiveautomation.com/u/Joseph_Mendonca)\
**Post date:** [September 15, 2010, 3:01pm UTC](https://forum.inductiveautomation.com/t/wonderware-historian-data/2200/1 "2010-09-15T15:01:22Z")

</div>

Hello,  
I’m currently working on converting our Wonderware system to IA Ignition. We have had Intouch for at least 15 plus years and have accumulated that many years of data. It would be fantastic to convert either the native intouch historian or the Insql historian data to an open data base such as the one used in IA. Any thoughts? I briefly looked at the history files but did not do a thorough analysis thus far. Any input will be appreciated.  
Thanks

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [September 17, 2010, 4:58pm UTC](https://forum.inductiveautomation.com/t/wonderware-historian-data/2200/2 "2010-09-17T16:58:20Z")

</div>

Sorry you’ve been left hanging here, but I don’t have any experience with this file format. I’m guessing its some sort of proprietary Wonderware file format? If the format is somewhat “open” it shouldn’t be hard to write a little script to bulk-insert the data into a normal SQL database, but again - I have no idea what the file looks like.

---

<div class="post-metadata">

**Author:** ![Joseph\_Mendonca](https://avatars.discourse-cdn.com/v4/letter/j/58f4c7/32.png) [@Joseph\_Mendonca](https://forum.inductiveautomation.com/u/Joseph_Mendonca)\
**Post date:** [September 18, 2010, 7:45pm UTC](https://forum.inductiveautomation.com/t/wonderware-historian-data/2200/3 "2010-09-18T19:45:02Z")

</div>

Queried the data from the Insql using the wonderware query program and was able to, just as a test, to create a csv file with 1 years worth of data. Need to research further but yes, I agree with you that a procedure to bulk load the data form one data base to the other would be ideal.