Step 1: To build and deploy the PowerServer project using the command-line tool (instead of within PowerBuilder IDE), install the following software.
-
Windows 11, 10 or 8.1, or Windows Server 2022, 2019, 2016, or 2012 R2
-
PowerBuilder Utilities 2022
The command-line tool (PBAutoBuild220.exe) is included in PowerBuilder Utilities.
-
PowerBuilder Runtime 2022
-
PowerServer Toolkit 2022
The PBAutoBuild220.exe tool can automate the entire build and deploy process outside PowerBuilder (without needing any PowerBuilder license).
Step 2: Prepare the database driver if the MySQL, Oracle, or Informix database connection is required.
If the MySQL, Oracle, or Informix database connection is used and if the corresponding database driver has not been downloaded yet, you will need to manually download the database driver from the NuGet website.
-
For MySQL, download MySql.Data 8.0.25 and the license file, and unzip the files to %USERPROFILE%\.sd\19.0\dbDrives\MySql.Data\8.0.25.
-
For Oracle, download Oracle.ManagedDataAccess.Core 2.19.110 and the license file, and unzip the files to %USERPROFILE%\.sd\19.0\dbDrives\Oracle.ManagedDataAccess.Core\2.19.110.
-
For Informix, download IBM.Data.DB2.Core 2.2.0.100 and the license file, and unzip the files to %USERPROFILE%\.sd\19.0\dbDrives\IBM.Data.DB2.Core\2.2.0.100.
They will be automatically loaded by PBAutoBuild220.exe when creating the database connection.
