We are currently in talks of the best way to revamp our system (will require a phonecall to tech support as it’s a bit too complex/lengthy to describe here). This system was currently in place when I started working here, and we migrated from FPMI/FSQL since then, so a lot of our methodologies were already established before I got here.
I am currently reading through the documentation in-depth to see if there’s any neat features/improvements that can be made when we’re in the process of revamping. One of the things that I came across was the SQLTags historian option.
Currently, to store history on items, we create a new transaction group, and drag the tags we want to store history for into it from the OPC browser and we’re good to go. I read through the SQLTags historian/transaction group documentation a few times, and I see how they both work, but I can’t figure out in which situation it would be best to use one over the other. What are the advantages/disadvantages of each?