How to transfer historical data from RaimaDB+ValueArchive to 3.19/SQLITE+NGA
Search
How to transfer historical data from RaimaDB+ValueArchive to 3.19/SQLITE+NGA
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 ?
What are the guidelines to transfer historical data ?
Is there a script already developed ?
- hpuchegger
- Posts: 38
- Joined: Fri Oct 08, 2021 10:38 am
Re: How to transfer historical data from RaimaDB+ValueArchive to 3.19/SQLITE+NGA
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
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
Re: How to transfer historical data from RaimaDB+ValueArchive to 3.19/SQLITE+NGA
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
For future it is planned to integrate such a solution in WinCC OA.
Best Regards
Leopold Knipp
Senior Support Specialist
Re: How to transfer historical data from RaimaDB+ValueArchive to 3.19/SQLITE+NGA
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 ?
is it possible to develop a Control Script to extract historical data from HDB and reinject into InfluxDB ?
Re: How to transfer historical data from RaimaDB+ValueArchive to 3.19/SQLITE+NGA
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
-- 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
Re: How to transfer historical data from RaimaDB+ValueArchive to 3.19/SQLITE+NGA
Hi Leopold,
How will it work with archive segments ?
BR
Aurélien
How will it work with archive segments ?
BR
Aurélien
Re: How to transfer historical data from RaimaDB+ValueArchive to 3.19/SQLITE+NGA
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
Can you please describe in detail what your question is related to.
Best Regards
Leopold Knipp
Senior Support Specialist
Re: How to transfer historical data from RaimaDB+ValueArchive to 3.19/SQLITE+NGA
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?
Re: How to transfer historical data from RaimaDB+ValueArchive to 3.19/SQLITE+NGA
Have you managed to migrate the data? I have a project where I need to migrate old data
Re: How to transfer historical data from RaimaDB+ValueArchive to 3.19/SQLITE+NGA
No, I haven’t.
Wait 3.20 or maybe 3.19 with a patch.
Wait 3.20 or maybe 3.19 with a patch.