How to transfer historical data from RaimaDB+ValueArchive to 3.19/SQLITE+NGA

[amichon]

I need to migrate a project developed with RaimaDB+ValueArchive to 3.19 with SQLITE+NGA

What are the guidelines to transfer historical data ?
Is there a script already developed ?

[hpuchegger]

Dear amichon,

when converting from RAIMA to SQLite (NGA), it is important to observe the following steps:

-- First you need to do the conversion from HDB to NGA (RAIMA):
https://www.winccoa.com/documentation/W ... nvers.html

-- Only then can you adopt the steps from the specified documentation:
https://www.winccoa.com/documentation/W ... ?hl=sqlite

Br, Herbert

[leoknipp]

Currently there is no standard solution available to transfer existing historical data from HDB archives to an NGA database.
For future it is planned to integrate such a solution in WinCC OA.

Best Regards
Leopold Knipp
Senior Support Specialist

[amichon]

what are the guidelines to reintegrate the data in InfluxDB ?

is it possible to develop a Control Script to extract historical data from HDB and reinject into InfluxDB ?

[leoknipp]

If you want to transfer data from the HDB archive to another database you can use the following approach. This task may take very long time depending on the amount of data you want to transfer.

-- Start the project with the HDB archives
-- Write/Start a script to export data to your own files, e.g. tab seperated text files including the DPE name, value, timestamp, status
-- Stop the project
-- Start the project with the NGA database
-- Write/Start a script to import data by reading the files and writing data using dpSetTimed()

Best Regards
Leopold Knipp
Senior Support Specialist

[amichon]

Hi Leopold,

How will it work with archive segments ?

BR

Aurélien

[leoknipp]

I do not understand your question.
Can you please describe in detail what your question is related to.

Best Regards
Leopold Knipp
Senior Support Specialist

[amichon]

how are data segments going to be made if I use dpSetTimed to import data? for example if I set the rotation of a segment for each day and I do a dpSetTimed a day ago, is the data going to be in the current day's segment or is that going to create a segment for the day before?

[kilianvp]

Have you managed to migrate the data? I have a project where I need to migrate old data

[amichon]

No, I haven’t.

Wait 3.20 or maybe 3.19 with a patch.