from History DB to Oracle DB
Hello,
we are going to migrate some projects from the default History DB (Value Archive) to Oracle by activating the RDB manager.
Is it possible to insert all the recorded values into the new Oracle DB?
Does exist a tool to automatically load all the values?
We use WinCCOA 3.15 P007 (but we already planned to install patch 18 in the next weeks).
Thanks
from History DB to Oracle DB
- leoknipp
- Posts:2928
- Joined: Tue Aug 24, 2010 7:28 pm
Re: from History DB to Oracle DB
There is no tool available to convert data saved in the HDB files to Oracle archives.
You can write your own functionality to convert data, e.g. by executing the following steps (short and not detailed description):
-- Read historical data
-- Save it into text files
-- Create a new project
-- Configure archiving
-- Read the text files
-- Write historical data
Please take into account that depending on the amount of data which needs to be imported this process will take a lot of time.
If also historical alarm information shall be imported the task will get more complex and time consuming.
Probably you can keep the old system in a executable state (without having a PLC connection) and start it on demand if someone needs to access old data.
Best Regards
Leopold Knipp
Senior Support Specialist
You can write your own functionality to convert data, e.g. by executing the following steps (short and not detailed description):
-- Read historical data
-- Save it into text files
-- Create a new project
-- Configure archiving
-- Read the text files
-- Write historical data
Please take into account that depending on the amount of data which needs to be imported this process will take a lot of time.
If also historical alarm information shall be imported the task will get more complex and time consuming.
Probably you can keep the old system in a executable state (without having a PLC connection) and start it on demand if someone needs to access old data.
Best Regards
Leopold Knipp
Senior Support Specialist