如何將PI Server 上的資料全部備份到SQL Server或是其他資料庫
You can try to install PI OLEDB Provider on target SQL server and create a Linked Server on the target SQL server with Provider type of "PI OLE DB Provider", so that you can dump PI server data from the linked server to the target SQL server via SQL mode.
and Is this the way to back up real-time data?
What if I want to back up or download the data of the previous ten years to sql server?
If you just wanted to export historical data from PI server (eg, export to text files), you can follow the way in KB 3065OSI8:
If the output target is SQL server, PI OLEDB Provider is more preferred, you may have to refer to picomp or picomp2 table in PI OLEDB Provider User Guide for more information:
Retrieving data ...