Skip to Main Content
AVEVA Product Feedback


In the PI Asset Framework Database SQL Scripts, replace the batch (.bat) scripts with PowerShell (.ps1) scripts

In the PI Asset Framework Database SQL Scripts, there are 3 "GO.BAT" files and 1 "afbackup.bat" file. These should be replaced with PowerShell scripts for several reasons:

  • PowerShell is easier to read and is a more powerful language than the batch language.

  • Batch scripts are best used in Windows, whereas PowerShell is cross-platform. This replacement will support OSIsoft's expansion outside of Windows.

  • Microsoft is pushing for PowerShell and leaving batch files in the dust.

  • The scripts are short and therefore easy to convert to PowerShell scripts.

  • Attach files
      Drop here to upload
    • Guest
      Reply
      |
      Aug 19, 2022
      Related: https://feedback.osisoft.com/forums/555148-pi-server/suggestions/40333219-replace-the-batch-bat-scripts-in-the-piserver