# Migrating from Wonderware Historian to Ignition Historian **URL:** \ **Category:** Ignition\ **Tags:** ignition79\ **Created:** [January 17, 2019, 5:23pm UTC](https://forum.inductiveautomation.com/t/migrating-from-wonderware-historian-to-ignition-historian/21947 "2019-01-17T17:23:43Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![zacslade](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacslade/32/3587_2.png) [@zacslade](https://forum.inductiveautomation.com/u/zacslade)\ **Post date:** [January 17, 2019, 5:23pm UTC](https://forum.inductiveautomation.com/t/migrating-from-wonderware-historian-to-ignition-historian/21947/1 "2019-01-17T17:23:43Z")
Hi all, I have several years of data in a Wonderware historical database, and I want to migrate the data to ignition. I see the following topics have addressed this before: > [@Importing tags form Wonderware](http://forum.inductiveautomation.com/t/importing-tags-form-wonderware/1893/6): > > IF you are slightly familar with Visual Basic, you can use the VBA in Excel to process the data from the Wonderware DBSave export .CSV into an Ignition import .CSV. I have used VBA in Excel to actually write code that has lots of repetitions. It will take a list of tagnames in an Excel column, process them against a template of what should be done with the tag in another column, and output the resulting code in another column. This pupply will process thousands of tagnames and write bug free … > [@Igniton and Insql](http://forum.inductiveautomation.com/t/igniton-and-insql/3688): > > Anyone ever try to integrate Ignition with InSql / Wonderware? I have a customer who’s SCADA system is Wonderware with Insql / Historian and they are exploring the possibilties of creating a interface on the administrative side to view shift reports, mill reports and other milling data. > [@Migration from iHistorian/Proficy Historian](http://forum.inductiveautomation.com/t/migration-from-ihistorian-proficy-historian/5168): > > Has anybody migrated from iHistorian/Proficy Historian to the SQLTags Historian? > [@Importing tag history from previous system into Ignition](http://forum.inductiveautomation.com/t/importing-tag-history-from-previous-system-into-ignition/4313/4): > > Yeah I am worried about doing the import thru ignition. I have done some with a few thousand rows and it takes quite a while(20-30 minutes) using the csv parsing script. I guess my first question if we use the import option thru scripting, what kind of performance hit would we take by writing this data into the tag history tables while the system is live? would we run into any deadlocks or anything? Colby, we dont really have that option in this situation, since a 3rd party was hosting the dat… They all either say that it should be straight-forward to script the conversion, or that they did it manually by putting two spreadsheet exports side-by-side and pasting data over. The person who did it manually said it took a couple of weeks of repetitive work for 15 years of data. I have more than 15 years of data, and I don't have weeks to put toward this. I want to do this with a script, but I don't want to re-invent the wheel. Has anyone written a script for this yet? If so, can I use your script? Thanks! ---
**Author:** ![brandon1](https://avatars.discourse-cdn.com/v4/letter/b/ea666f/32.png) [@brandon1](https://forum.inductiveautomation.com/u/brandon1)\ **Post date:** [January 17, 2019, 5:38pm UTC](https://forum.inductiveautomation.com/t/migrating-from-wonderware-historian-to-ignition-historian/21947/2 "2019-01-17T17:38:10Z")
Reach out to your Inductive Automation representative. They may have some solutions that you can use as a starting point. ---
**Author:** ![Michael\_Keller](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@Michael\_Keller](https://forum.inductiveautomation.com/u/Michael_Keller)\ **Post date:** [February 7, 2023, 2:30am UTC](https://forum.inductiveautomation.com/t/migrating-from-wonderware-historian-to-ignition-historian/21947/3 "2023-02-07T02:30:52Z")
Did you ever have any success with this? ---
**Author:** ![zacslade](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacslade/32/3587_2.png) [@zacslade](https://forum.inductiveautomation.com/u/zacslade)\ **Post date:** [February 7, 2023, 3:53am UTC](https://forum.inductiveautomation.com/t/migrating-from-wonderware-historian-to-ignition-historian/21947/4 "2023-02-07T03:53:59Z")
In the end, my boss didn't accept the proposal to migrate our system to Ignition, so I didn't get to test this, but I did come to a conclusion about the best way to do it. Having spoken at length with Ignition support, if I remember right, we agreed that they or an integrator would work with us to develop a script to migrate the data to an ignition database. The script looks slightly different for different versions of Ignition, so we wouldn't be able to copy/paste someone else's script and use it. We would have set up an Ignition historian to run in parallel with Wonderware, and have a script running in the background to copy past data from Wonderware to Ignition until it was all copied over. Once all the data was copied, we could decommission the Wonderware historian. ---
**Author:** ![Michael\_Keller](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@Michael\_Keller](https://forum.inductiveautomation.com/u/Michael_Keller)\ **Post date:** [February 7, 2023, 10:11am UTC](https://forum.inductiveautomation.com/t/migrating-from-wonderware-historian-to-ignition-historian/21947/5 "2023-02-07T10:11:05Z")
Ok thank you for the response! ---
**Author:** ![brandon1](https://avatars.discourse-cdn.com/v4/letter/b/ea666f/32.png) [@brandon1](https://forum.inductiveautomation.com/u/brandon1)\ **Post date:** [February 7, 2023, 2:36pm UTC](https://forum.inductiveautomation.com/t/migrating-from-wonderware-historian-to-ignition-historian/21947/6 "2023-02-07T14:36:49Z")
Keep in mind IA has released a tool on the exchange that can import a CSV file into the historian. Since you can export data out of the Wonderware Historian using a SQL query this is a viable solution. I have tried it myself and it works very well. It is also surprisingly fast! > **[Ignition Exchange](https://inductiveautomation.com/exchange/2345/overview)** > > Discover, share, and download community made Ignition resources in collaboration with your organization or the Ignition community.