PI SQL Commander is a very important tool for developing and testing PI SQL queries.
As it's not a standalone download, the following download kits contain the application:
- PI SQL Client
- PI OLEDB Enterprise
- Note: This installation kit also includes PI OLEDB Provider
- Note: PI OLEDB Enterprise 2016 R2 and earlier require the installation of Visual Studio Shell for PI SQL Commander. This dependency was dropped in PI OLEDB Enterprise 2017.
- PI ODBC Driver
Note: The standalone PI OLEDB Provider installation kit does not include PI SQL Commander
- It instead includes the PI OLEDB Provider MMC Snap-in, which we will not cover in this course
- We therefore recommend that PI OLEDB Provider customers install PI OLEDB Enterprise; this installation kit includes both OLEDB providers (Provider and Enterprise) as well as PI SQL Commander.