Transfer historical data to DB

[oley]

Hi,

I am currently using one instance with a standard dat archive.
I want to use a PostgreSQL archive.
Is it possible to transfer historical data to the database from the dat archive?

[Mikhail]

Hi,

Is it possible to transfer historical data to the database from the dat archive?

There is no direct converter. If you decided to develop it, I could help.
Using the existing tools, you can export data to CSV, and then import it back from CSV to Rapid SCADA. When importing, data is sent to the Server service which writes it to the active archives.

[Mikhail]

I suggest to use DAT and PostgreSQL archives in parallel. In that case, you have 2 copies of data, fast performance when read DAT format, flexibility when read using SQL.

[oley]

Hi,

is there a specification of the dat file format?
How to export complete historian data to csv?
Writing an importer to existing DB with ef.core will not be a problem.

[Mikhail]

Hi,
> is there a specification of the dat file format?
Yes. Please search in Additional documentation

> How to export complete historian data to csv?
Use the utilities.

[Author]

Posts