AnsweredAssumed Answered

Importing PI Audit Data into SQL Server

Question asked by flost Champion on Apr 18, 2017
Latest reply on Apr 24, 2017 by flost

Hello Everybody,

 

does anybody have experiance with importing the PI Audit Data into SQL Server? I have exported the data (for the last five years) from the dat files into XML Files. My first attempt was to import them into Excel so that I will be able to import them easyly into SQL Server. But they are much too big for Excel (and most of them even for several text editors).

 

So I need to import the xml files directly into MX SQL Server. But I´m not so experianced with MS SQL Server so I would be happy if someone has done this before so that I can participate from the experiance.

 

Or maybe there is another way to get the data into SQL server wthout first exporting XML files.

 

Loocking forward to hearing form you!

 

Florian

Outcomes