I have a situation where I need to import 5 years of data into the Ignition historian tables (.csv file format/SQL Server). What is the easiest way to accomplish this? Is the only viable option the system.tag.storeTagHistory method?
system.tag.storeTagHistory is the recommended way, yes. Batch your inserts, and check periodically that things are working as intended. Snapshot your historical DB before starting, if you’ve got existing data.
While it’s theoretically possible to ingest the table yourself, it’s a non-trivial task to get it all into the correct tables with the correct references.
1 Like
Okay great, thanks for the recommendations!