| By Chris Pollach | Article Rating: |
|
| February 19, 2006 11:45 AM EST | Reads: |
12,885 |
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)!
Published February 19, 2006 Reads 12,885
Copyright © 2006 SYS-CON Media, Inc. — All Rights Reserved.
Syndicated stories and blog feeds, all rights reserved by the author.
More Stories By Chris Pollach
Chris Pollach is a Senior Consultant with over 25 years experience in Systems and Software Analysis, Development, Maintenance and Technical Support, mainly in the areas of GUI Design, MS-Windows Programming, Java / .NET Programming, Wireless, Application / Web Server Design & Programming, Object Oriented Development Tools and Methodologies, Data Base, Data Communications and Network application development. He has participated in numerous technical, planning and management roles, as well as consulted and educated in these fields for a diverse clientele. He is also the owner of “Software Tool & Die Inc.” a company dedicated to provide custom software and education solutions on Object Oriented business systems.
As an educator, Chris is certified to teach PowerBuilder (first in Canada), MS-SQLServer, Sybase’s Enterprise Application Studio and EAServer integrated application/web development environment. He is former Certified SilverStream developer (CSSD) and current Certified PowerBuilder Developer – Associate / Professional (CPD-P) as well as a Certified Sybase Tools Instructor (CSI).
Chris has written numerous articles in various popular personal computer magazines, newsletters and is the author of the PowerGuide and PowerExpert products. Currently, Chris has developed a Foundation Class library for PocketBuilder development on PDA devices using the PocketPC Operating System (similar to Microsoft’s .NET strategy). He has also developed a similar Framework for Sybase's PowerBulder and EAServer that integrates JSP or ASP web development that supports Section 508 and CLF web standards.
Chris recently became a 2nd Degree Black in the TaeKwonDo martial art and has developed a Martial Art multimedia study guide using the Component-One “Doc2Help” and Sybase PowerBuilder products. Since the fall of 2004 he became a TaeKwonDo instructor for the City of Ottawa’s Goulbourn program. He has also been certified with the World TaeKwonDo Federation (February 2005 - 1st Dan and October 2008 - 2nd Dan).
Chris was awarded the Sybase “Innovation and Achievement” award for 2005 as voted for by the International Sybase User Group (ISUG). This award was presented for innovations to the PocketBuilder mobile development product, contributions to the PowerBuilder News groups and support of the Ottawa Sybase User Group.
To round his management and leadership skills, Chris is the former president of the Kiwanis Club of Goulbourn and still volunteers his time with the service clubs in his area. He is also the coordinator of the Ottawa Sybase User group and a certified NAUI scuba instructor. For the last three years, Chris has been voted onto the ISUG Board of Directors and holds the position of "Director - North American User Groups".
![]() |
SYS-CON Belgium News Desk 02/19/06 03:07:12 PM EST | |||
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. |
||||
- User Group Malaise?
- What's New in HTML5
- SAP Buys US Mobile Platform House Syclo
- Best Way to Grow Enterprise Mobility In-House
- What's New in HTML5 - Week of April 1, 2012
- How to Test Drive Enterprise Mobility
- Mobile Marketing News Weekly – Week of March 26, 2012
- Enterprise Mobility Asia News Weekly – Week of March 25, 2012
- The PowerBuilder DataWindow as an Image Thumbnail Display Control
- Mobile Commerce News Weekly – Week of March 19, 2012
- Tablets Have Come of Age
- Mobile Health News Weekly – Week of April 8, 2012
- User Group Malaise?
- What's New in HTML5
- SAP Buys US Mobile Platform House Syclo
- Going Mobile in 2012
- Appeon Mobile: First-Ever Mobility Solution for the PowerBuilder Community
- Take PB to the Web, Mobile & More!
- M2M News Weekly – Week of February 27, 2012
- Best Way to Grow Enterprise Mobility In-House
- What's New in HTML5 - Week of April 1, 2012
- How to Test Drive Enterprise Mobility
- Mobile Marketing News Weekly – Week of March 26, 2012
- Mobility News Weekly – Week of February 20, 2012
- Where Are RIA Technologies Headed in 2008?
- PowerBuilder History - How Did It Evolve?
- The Top 250 Players in the Cloud Computing Ecosystem
- DDDW Tips and Tricks
- Dynamically Creating DataWindow Objects
- OLE - Extending the Capabilities of PowerBuilder
- Working with SOA & Web Services in PowerBuilder
- DataWindow.NET How To: Data Entry Form
- Custom Common Dialogs Using SetWindowsHookEx
- Sybase ASE 12.5 Performance and Tuning
- Office 2003 Toolbar: A New Look For Your Old PowerBuilder App
- Book Excerpt: Sybase Adaptive Server Anywhere






















