I'm referencing the Tag History Splitter video from Inductive University. I'm wondering if my goal is achievable without individually updating many existing tags.
I currently have 1000 tags & only one mysql database connection serving as both the real-time & history providers, with 3 years of data.
I'm thinking of implementing the tag history splitter because I want tolimit data in this real-time provider to 3 months, & keep all data older than 3 months in a new, separate mysql database connection. I want Perspective to query the real-time provider for data under 3 months old & query the new history provider for all older data, which seems doable from this video
My question is: is this achievable without individually updating the storage provider on each of my 1000 tags, switching them from the current provider to the new tag history splitter provider? At the end of each daily partition, I'm copying yesterday's table from the real-time database to the proposed history database, hoping this will achieve my goal without editing the storage provider on 1000 tags