Chris Pollach's PowerBuilder Blog: "SQLXTRACT New Release!" @ POWERBUILDER JOURNAL

Chris Pollach's PowerBuilder Blog: "SQLXTRACT New Release!"

I am pleased to announce that Software Tool & Die Inc. has just released a new version of the SQLXtract utility (10.2.1)

By: Chris Pollach

Feb. 19, 2006 11:45 AM

Digg This!

SQLXTRACT - New Release!

I am pleased to announce that Software Tool & Die Inc. has just released a new version of the SQLXtract utility (10.2.1) that reverse engineers Sybase's proprietary SQL format (PBSELECT) into ANSI, PL/SQL or TransAct SQL from the "DataWindow" object. The new version of the SQLXtract utility was mainly revised to allow it to reverse engineer the source code from a Unicode based library vs.. an ANSI format previously.

The output of SQLXTract is a textual .SQL file that can be input directly into products like Quest Central (aka SQLExpert) for further analysis. I have successfully tested the new version of SQLXTract with Sybase's ASE 15 and Microsoft's SQLServer2005 DBMS versions of Quest Central (by Quest Software). SQLXTract will also be able to handle the new Microsoft DB access mechanisms, they are: OLE-DB and ADO.net. Support for the ODBC db driver is still standard, but the native MS db driver support has been dropped because Microsoft no longer supports this feature. For ASE 15, SQLXTract supports ODBC, OLE-DB, ADO.net and Open Client (native) DB driver access mechanisms.

This new version of the SQLXTract utility will also work on Sybase's new "WorkSpace" 1.5.x development tool that incorporates DW.Java (java based DataWindow), DW.Net 2.x (.Net 2.0 version of the DataWindow) plug-in for Visual Studio 2005, Infomaker 10.x (report writer), PowerBuilder 10.x and PocketBuilder 2.x (PDA version of PowerBuilder for Windows Mobile)! The support for all these other environments other than PowerBuilder is new to this version of SQLXTract!

The PocketBuilder version of SQLXTract is a special version and exists to handle the DW.wm (Windows Mobile DataWindow). The separate version will be a PocketBuilder application and is designed to handle unique features of DW.wm such as: SIP (System Input Device), Multiple Orientation, WM Fonts, etc. The support for these specific DW features can only be found in the PDA version. The PDA version of SQLXTract will be able to reverse engineer SQL into ASA DBMS format and soon, MS-SQLServer CE. The PocketBuilder version of SQLXTract is currently in Alpha, but is working well in my testing thus far and will be released separately to CodeXchange in the near future!

The PowerBuilder 9.0.3 (ANSI) version of SQLXTract has been available on CodeXchange for the past year. SQLXtract version 10.2.1 can be downloaded from Sybase's CodeXchange (click here)!

Regards ... Chris

President: STD Inc.

Published Feb. 19, 2006 — Reads 8,660
Copyright © 2008 SYS-CON Media. All Rights Reserved.

About Chris Pollach
Chris Pollach is the president of Software Tool & Die Inc. (a consulting company based in Ottawa, Ontario, Canada) and has been using PB since November 1989 (version 0.8). When not developing in PB, Chris enjoys fishing and martial arts.

PBDJ LATEST STORIES . . .

3rd International Virtualization Conference & Expo: Themes & Topics

By Jeremy Geelan

From Application Virtualization to Xen, a round-up of the virtualization themes & topics being discussed in NYC June 23-24, 2008 by the world-class speaker faculty at the 3rd International Virtualization Conference & Expo being held by SYS-CON Events in The Roosevelt Hotel, in midtown

The PB Future: More on Graphs in PowerBuilder 11.5

By Dave Fish

Last week I posted a screen shot of the new 3D Rendering capabilities being added to some of the 3D graphs in PowerBuilder 11.5. It was met with mixed reviews on the PowerBuilder Futures newsgroup (forums.sybase.com) so I went back to the drawing board to see what I could come up with.

BluePhoenix Expands Modernization Collaboration with Microsoft

By .NETDJ News Desk

BluePhoenix announced that it has expanded its collaboration with Microsoft on legacy modernization projects. The collaboration provides customers moving their applications or databases to .NET-based environments the best in both modernization services and technical support. BluePhoeni

Sybase PowerBuilder Delivers AJAX and .NET Enhancements Enabling Rich Internet Application Development

By PowerBuilder News Desk

Sybase announced that AJAX development capabilities and further Microsoft .NET enhancements have been added to the latest version of Sybase PowerBuilder 11, the premier 4GL rapid application development (RAD) tool. PowerBuilder 11.2 represents another milestone in the PowerBuilder road

PowerBuilder 11.2 Released: Sybase's Flagship IDE

By Chris Pollach

Sybase has released the production version of its flagship .NET development tool - PowerBuilder version 11.2. This latest release of its premier IDE for RAD includes not only standard fixes but also a good list of new features. Here is the 'Coles Notes' version of these new features.

PowerBuilder Takes You To .NET

By John Strano

In June of 2007, Sybase released PowerBuilder 11. PowerBuilder developers can now deploy PowerBuilder components as .NET Assemblies or as .NET Web Services. A PowerBuilder developer can now create these .NET resources so that those who develop .NET solutions can benefit from PowerBuild