We are looking to migrate about a year’s worth of trended tag data from mySQL to a new MS SQL Server database and then from here on out have all new data for these tags be trended in the new database. Since Ignition has clearly added some very specific table names to the mySQL database to deal with historical data behind the scenes, do I need to copy these over exactly into the MS Sql database for everything to show up properly when I start changing the historical repository location?
The end goal would be to be able to have new data (After I repoint the historical repository to the new SQL Server) and old data (Data stored when the historical repository was on mySQL) for the same tag be visible in our trends seamlessly altogether as if it was always in the same database.
Do I have to copy everything manually, or is there a simpler way to do this migration and achieve the above desired result? Thank you for the help!