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.