Create an SQL registration script

To create an SQL registration script, invoke the RegPlugIn utility, specifying the required details and the /OutputFile or /AppendFile parameter. The resulting script can be loaded into the SQL database using SQL Server Management Studio or executed from a command line using the sqlcmd utility, enabling you to install plug-ins on machines where the PI AF SDK is not installed.

Note: For plug-in developers: The SQL script needs to be generated every time you compile a new version of the plug-in.

The AF SDK .NET 3.5 is no longer shipped beginning with the release of PI AF 2018 SP3 Patch 2. It is recommended that customers migrate to the AF SDK .NET 4 and update their plugins accordingly.

Example

For example, to create a script that registers a NET 3.5-only Plug-In targeting any CPU, issue the following command:

RegPlugIn /O:MyPlugIn.sql PlugIns\MyPlugIn.dll

To generate an SQL registration script named MyPlugIn.sql that registers two implementations of MyPlugIn, a .NET 3.5-only Plug-In targeting x86 and x64, issue the following commands:

RegPlugIn /O:MyPlugIn.sql PlugIns\x86\MyPlugIn.dll
RegPlugIn64 /A:MyPlugIn.sql PlugIns\x64\MyPlugIn.dll

To generate an SQL registration script from a previously-created XML registration file, specify the XML file name on the command line. For example:

RegPlugIn /O:MyPlugIn.sql MyPlugIn.xml