# Hach WIMS and Vision 8.1 **URL:** \ **Category:** Ignition\ **Tags:** vision, ignition81\ **Created:** [August 14, 2024, 1:36pm UTC](https://forum.inductiveautomation.com/t/hach-wims-and-vision-8-1/94644 "2024-08-14T13:36:32Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Brad\_Niemi1](https://avatars.discourse-cdn.com/v4/letter/b/ecd19e/32.png) [@Brad\_Niemi1](https://forum.inductiveautomation.com/u/Brad_Niemi1)\ **Post date:** [August 14, 2024, 1:36pm UTC](https://forum.inductiveautomation.com/t/hach-wims-and-vision-8-1/94644/1 "2024-08-14T13:36:32Z")
We have a Vision app that our customer wants to use Hach WIMS (SQL Database with a .NET wrapper). We are currently using the Sample\_SQLite\_Database, but need to access it. ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [August 14, 2024, 2:05pm UTC](https://forum.inductiveautomation.com/t/hach-wims-and-vision-8-1/94644/2 "2024-08-14T14:05:06Z")
Does this "Hach WIMS" software support connecting to SQLite databases? ---
**Author:** ![Brad\_Niemi1](https://avatars.discourse-cdn.com/v4/letter/b/ecd19e/32.png) [@Brad\_Niemi1](https://forum.inductiveautomation.com/u/Brad_Niemi1)\ **Post date:** [August 14, 2024, 2:18pm UTC](https://forum.inductiveautomation.com/t/hach-wims-and-vision-8-1/94644/3 "2024-08-14T14:18:39Z")
No, it does connect with MicrosoftSQL, but that brings up more questions, like, how to set up the new DB. Will I lose access to the data stored on the SampleSQLite? Do I need to change the trending tags? ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/e/5e648cf02f3aa9b13771fc6101701cfce50426bd.png) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/6/16e6e3a62498fee6e2a0a4c950744ce02681511c.png) ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [August 14, 2024, 2:38pm UTC](https://forum.inductiveautomation.com/t/hach-wims-and-vision-8-1/94644/4 "2024-08-14T14:38:20Z")
With some amount of effort you should be able to migrate/import your data to a MS SQL Server instance. Support can probably help you out with the details. ---
**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:** [August 14, 2024, 2:53pm UTC](https://forum.inductiveautomation.com/t/hach-wims-and-vision-8-1/94644/5 "2024-08-14T14:53:29Z")
Are you needing to just pull data out of their database? You'll probably need some custom queries to pull the data stored in their DB. If you're wanting to use their database for storing your data also, it should be possible and I would just create a new DB inside their instance to keep it separate from their system. If this is Ignition Edge, you're out of luck. You'll need standard edition to do any of this. ---
**Author:** ![Brad\_Niemi1](https://avatars.discourse-cdn.com/v4/letter/b/ecd19e/32.png) [@Brad\_Niemi1](https://forum.inductiveautomation.com/u/Brad_Niemi1)\ **Post date:** [August 14, 2024, 3:06pm UTC](https://forum.inductiveautomation.com/t/hach-wims-and-vision-8-1/94644/6 "2024-08-14T15:06:24Z")
I might have got off track. What I need is really just how to set up the MicrosoftSQL DB , the Hach WIMS will do the rest. ---
**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:** [August 14, 2024, 3:10pm UTC](https://forum.inductiveautomation.com/t/hach-wims-and-vision-8-1/94644/7 "2024-08-14T15:10:00Z")
Your going to need the IP/DNS host name, username, password, and database name used by that system to set it up. On that server, you'll need to use the SQL Server configuration to verify that TCP/IP is enabled for access, but most of that information is in this video (adjust as necessary as your instance name may be different): > **[Connecting to Microsoft SQL Server Express Video at Inductive University](https://www.inductiveuniversity.com/videos/connecting-to-microsoft-sql-server-express/8.1)** > > Learn about what configuration settings and connection methods to use when connecting to a Microsoft SQL (MSSQL) Server Express database. ---
**Author:** ![Brad\_Niemi1](https://avatars.discourse-cdn.com/v4/letter/b/ecd19e/32.png) [@Brad\_Niemi1](https://forum.inductiveautomation.com/u/Brad_Niemi1)\ **Post date:** [August 14, 2024, 4:06pm UTC](https://forum.inductiveautomation.com/t/hach-wims-and-vision-8-1/94644/8 "2024-08-14T16:06:29Z")
thanks, got it