SQL Extract Utility - 2025R1 Released!

 ** Hot News **

Updated SQL Extract Utility! 

for Appeon PowerBuilder 2025

    Software Tool & Die Inc. (STD Inc) have just released an updated version of the SQL Extract utility version 2025.1.0.45 that can reverse engineer Appeon PowerBuilder's proprietary SQL format known as a PBSELECT format into either ANSI, PL/SQL or T-SQL format from within any DataWindow (TM) object. The updated version of the SQL Extract utility was designed to allow it to forward & reverse engineer the DataWindow source code from any Unicode based PowerBuilder library. This means that DataWindow source from PowerBuilder version 10 through PB 2025 can be parsed & the SQL run-time generated from a PBSELECT format just like when your DataWindows are actually running under control of your PowerBuilder based production applications! The utility will also identify DataWindows that are not using a PBSELECT format that may be already causing performance, migration or cross-DBMS issues and may require a review.

 
    The output of SQL Extract is a textual based .SQL file that can be input directly into SQL syntax analysis  products like: SQL Parser; SQL Doctor; Aqua Data Studio; DB Optimizer; etc (to name a few products) for further SQL analysis, formatting, & tuning. STD has successfully tested the new version of SQL Extract with SAP's latest SQL Anywhere & ASE 16 as well as SQL Server 2022, PostGreSQL 17  DBMS systems. SQL Extract can also handle other DB access mechanisms, such as: OLE-DB, ADO.net, MSOLEDBSQL, etc. Support for the ODBC db driver is still standard, but PB's native db drivers are fully supported as per the Appeon PB 2025 product feature set. Older DBMS client DB Drivers are also supported - for example the Open Client (SYC) native DB driver access mechanism for ASE.

    The updated of the SQL Extract utility will also work with Appeon's InfoMaker 2025, PowerClient & PowerServer 2025 development projects as well, as those products also utilize the same DataWindow technology. The new features of SQLXTract v2025 are as follows:

• Migrated the App code from PB2017R1 build 1681 to PB 2025 build 3683.
• Enhanced the SQL extraction logic to support "on the fly" DataWindow source conversion syntax
• Tested SQL Extract with SA 17 and the new "PB Demo DB V2025" database
• Added new Project for 64bit deployment
• Tested SQL Extract on W10 version 22H2 build 19045.2788
• Tested SQL Extract on W11 version 24H2 build 26100.4349

 

    The SQL Extract utility application is open source and thus royalty free to use. You can download the SQL Extract application source code from its current location on the SourceForge website.

Enjoy!

Regards ... Chris