MERGE HISTORIC FILES @GEO SCADA

[BGedco2022]

Hello,

Can we merge or copy of historic files of the last 2 years from backup into the current database of GEOSCADA?

If yes, How?

Appreciate any hint

Thanks in advance

[AdamWoodland]

Given the hrd files are just chunks of 32-byte records in theory you could just copy two files together into one and that could work. I've never tried it, it is probably not supported, just throwing it out there given your other post about extract historic from backups. It would also be very fast to run, which might be relevant if you have a million or so points to merge,

The proper way to do this would be use to use LoadDataValue, LoadDataValues and LoadDataFile on the CHistoryBase table. This allows you to insert data into the historic. You'll have to read the current historic data, work out what is extra, then insert that back using the relevant method (probably using LoadDataValues)