# Igniton and Insql **URL:** \ **Category:** Ignition\ **Created:** [December 2, 2011, 4:52am UTC](https://forum.inductiveautomation.com/t/igniton-and-insql/3688 "2011-12-02T04:52:26Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Micky.Franks](https://avatars.discourse-cdn.com/v4/letter/m/c57346/32.png) [@Micky.Franks](https://forum.inductiveautomation.com/u/Micky.Franks)\ **Post date:** [December 2, 2011, 4:52am UTC](https://forum.inductiveautomation.com/t/igniton-and-insql/3688/1 "2011-12-02T04:52:26Z")
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. ---
**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Post date:** [December 7, 2011, 1:05am UTC](https://forum.inductiveautomation.com/t/igniton-and-insql/3688/2 "2011-12-07T01:05:29Z")
Strangely enough, a concrete example of someone doing this doesn’t come to mind. However, there very well may be someone out there, and hopefully they’ll offer their experience. Beyond that, InSQL is hosted through SQL Server, so in theory it should be possible to connect through JDBC. I know I’ve seen the WW Historian Query tool which allows you to write SQL queries against their “schema”, so I would imagine it’s possible to connect and do this yourself. However, I don’t have much more to go on than that. I can ask the sales people and some of our ex-wonderware customers tomorrow if they know of any cases of this. Regards, ---
**Author:** ![Dravik](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\ **Post date:** [December 7, 2011, 3:40pm UTC](https://forum.inductiveautomation.com/t/igniton-and-insql/3688/3 "2011-12-07T15:40:30Z")
We’ve done it, Nothing more than pulling data for other purposes really. As Colby says, You can interface right to the database end w/out much trouble. ---
**Author:** ![Micky.Franks](https://avatars.discourse-cdn.com/v4/letter/m/c57346/32.png) [@Micky.Franks](https://forum.inductiveautomation.com/u/Micky.Franks)\ **Post date:** [December 7, 2011, 4:37pm UTC](https://forum.inductiveautomation.com/t/igniton-and-insql/3688/4 "2011-12-07T16:37:03Z")
Any difference in setting up the JDBC driver as compared to regular SQL? A lot of our installs have been Wonderware and this particular client has spent close to $50,000 this year in licenses for 10 clients / 1 developer / Historian. There is talks of allowing managers to view apps to see production reports and the like but with no access to alter running conditions. My thoughts were if everything is already logging to InSQL why not just use that data and instead of spending $$$ on licenses spend it on development time. ---
**Author:** ![Dravik](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\ **Post date:** [December 7, 2011, 7:01pm UTC](https://forum.inductiveautomation.com/t/igniton-and-insql/3688/5 "2011-12-07T19:01:45Z")
I didn’t have to do anything special no, The structure that insql uses is a little odd, but nothing you can’t deal with. ---
**Author:** ![zackscriven](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zackscriven/32/7213_2.png) [@zackscriven](https://forum.inductiveautomation.com/u/zackscriven)\ **Post date:** [July 26, 2013, 12:12am UTC](https://forum.inductiveautomation.com/t/igniton-and-insql/3688/6 "2013-07-26T00:12:11Z")
Hey Everybody. How hard would it be to migrate old InSQL data into a new MySQL database for Ignition? I would be ditching the old structure. Would it possible to manually backlog data for each corresponding Ignition Tag using MySQL management tools? Is it even possible to convert Microsoft SQL to MySQL? ---
**Author:** ![anna](https://avatars.discourse-cdn.com/v4/letter/a/779978/32.png) [@anna](https://forum.inductiveautomation.com/u/anna)\ **Post date:** [July 30, 2013, 5:00pm UTC](https://forum.inductiveautomation.com/t/igniton-and-insql/3688/7 "2013-07-30T17:00:06Z")
Just to let you know, we are working on a Historian migration tool. It is now being tested and we will post it as soon as it is ready. ---
**Author:** ![gnguyen](https://avatars.discourse-cdn.com/v4/letter/g/41988e/32.png) [@gnguyen](https://forum.inductiveautomation.com/u/gnguyen)\ **Post date:** [August 1, 2013, 1:27pm UTC](https://forum.inductiveautomation.com/t/igniton-and-insql/3688/8 "2013-08-01T13:27:02Z")
Ho, nice feature. Any deadline for this migration tool ? ---
**Author:** ![anna](https://avatars.discourse-cdn.com/v4/letter/a/779978/32.png) [@anna](https://forum.inductiveautomation.com/u/anna)\ **Post date:** [August 1, 2013, 3:46pm UTC](https://forum.inductiveautomation.com/t/igniton-and-insql/3688/9 "2013-08-01T15:46:20Z")
No ETA, sorry. All I can say for now is that it is being tested… we will post it as soon as we are ready to. ---
**Author:** ![JMicky](https://avatars.discourse-cdn.com/v4/letter/j/dfb087/32.png) [@JMicky](https://forum.inductiveautomation.com/u/JMicky)\ **Post date:** [October 12, 2018, 6:28pm UTC](https://forum.inductiveautomation.com/t/igniton-and-insql/3688/10 "2018-10-12T18:28:01Z")
> [@anna](#): > > Historian migration tool I could really use an InSQL migration tool on a current project. Any word if it's still in the works? Thank you, John ---
**Author:** ![alexmarcy](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alexmarcy/32/4653_2.png) [@alexmarcy](https://forum.inductiveautomation.com/u/alexmarcy)\ **Post date:** [October 14, 2018, 3:38pm UTC](https://forum.inductiveautomation.com/t/igniton-and-insql/3688/11 "2018-10-14T15:38:34Z")
Do you have access to the InSQL Query interface to get to the data in SQL Management studio? If so this process is pretty straightforward to do just in SQL.