Welcome!

Agile Computing Authors: Yeshim Deniz, Pat Romanski, Liz McMillan, Ed Featherston, Elizabeth White

Related Topics: Microsoft Cloud, PowerBuilder

Microsoft Cloud: Article

PowerBuilder Takes You To .NET

Preparing PowerBuilder applications for .NET Windows Forms deployment

After designating which PBLs you want to have the tool examine, you'll be able to print, save, and browse the Migration Assistant's analysis report. (Figure B)

You can now begin formalizing your Migration Plan.

The Migration Assistant is a great boon to the developer in that its discovery success rate is close to 100%, but you'll want to add a thorough quality assurance cycle to the tail end of that plan.
Once you believe you and your team are ready for the migration process, open the application in PowerBuilder 11. The Migrate Application response window will open. Verify your library list, choose your message notification level, select whether you want PowerBuilder to automatically convert DBCS string manipulation functions appropriately for unicode usage...this is the point of no return and your last chance to back up your PBLs...then click OK. (Figure 3)

Unsupported Features in Windows Forms Projects
In its 11.x time frame, PowerBuilder is a .NET deployment solution. That is, the developer isn't strictly working with .NET in the PowerBuilder IDE. (.NET in the PowerBuilder IDE is slated for version 12). As such, any application can use PowerBuilder features that are appropriate to Win32 deployments, but aren't supported yet or not appropriate for .NET deployments. (Figure C)

There are, however, those unsupported features that Sybase doesn't plan to support for .NET deployment such as non-visual classes for profiling and tracing. PowerBuilder developers will have to identify where in their applications they may be using unsupported features and then decide how they want to refactor the application to work around each feature. The next part of this article will cover identifying unsupported features in your application, yet I highly recommend at some point that you review Chapter 11 of "Deploying Applications and Components to .NET" in the documentation to become familiar with this reference for "Unsupported Features in Windows Forms Projects".

http://infocenter.sybase.com/help/topic/com.sybase.dc00586_1100/html/dplynet/CJAJHFGB.htm

Deploying Your WinForm Application
OK. It's time to deal with the nuts and bolts of features not supported for WinForm-deployed applications, so it's time to do our initial deploy! Since the thrust of this article is preparing your PowerBuilder application for WinForm deployment rather than the details of how to actually deploy it as WinForm, I'll refer you to the detailed external resources on just how to do that.
In the core document "Deploying Applications and Components to .NET," Chapter 9 "Deploying PowerBuilder Applications as .NET Windows Forms" takes you through the use of the .NET Windows Forms Application wizard.

http://infocenter.sybase.com/help/topic/com.sybase.dc00586_1100/html/dplynet/BABEEDAC.htm

There are also detailed recordings of deploying/publishing your WinForm application using .NET Smart Client techniques. Look for demonstrations of PowerBuilder 11's "Intelligent Updater" at www.sybase.com/products/development/powerbuilder/videos and at www.sybase.com/products/development/powerbuilder/webcasts.

The .NET Deployment Output Log
Once you've deployed your target as a WinForm, you'll want to examine the tabbed output logs in the PowerBuilder IDE. Exporting can save these logs and I highly recommend you do so.
Pay attention to the Default, Warnings, and Errors logs first. They arguably will have the most critical issues needing your attention. A text file named DeployLog.txt is generated with each .NET deployment in PowerBuilder 11. Besides aiding you with deployment errors it may be beneficial in helping you resolve any remaining configuration issues.

Now it's time to examine the Unsupported Features output log.

The Unsupported Features output log is populated the first time you deploy to WinForm and each subsequent time you choose to do a full rebuild. Of course, if after a deployment you add any features to your application that are unsupported, even an incremental rebuild should yield a populated output log. There's a lot of useful information in that output log, but I'm sure you'll agree that it'll take some effort to read through it in its raw form and continue to use it as a reference document as you formulate your Refactoring Plan. That's why the .NET Features Analyzer was recently introduced.

The .NET Features Analyzer IDE Add-in
The .NET Features Analyzer is available on Sybase's codeXchange Web site at https://powerbuilder.codexchange.sybase.com....

This tool was created in the 4GL tradition to provide you with a productive IDE for browsing the Unsupported Features output log.

The tool is an add-in to the PowerBuilder IDE. Once installed, open it from the File>New menu item in the IDE and select it from the Tool tabpage of the New response window. Use the tool to open a saved output log or tell it to import the log that may be open in the PowerBuilder IDE. .NET Features Analyzer lets you browse unsupported features by class and PBL. In its IDE, you may also examine the raw output log as well as any exceptions that are thrown. All of this may be printed and you may save the raw output from here as well. (Figure 4)

Formulate Your Refactoring Plan
So once you've identified the features in your application that aren't supported in a WinForm deployment, it's time to divide and conquer. Decide what workaround you'll use for each unsupported feature, how much time it'll take, what resources to assign, and estimate a time frame. In other words, you won't want to skimp in managing this as a formal project.

Some Caveats
A couple of caveats while you refactor your PowerBuilder application for WinForm deployment: 1) the functionality of the debugger for .NET deployment targets is different from Win32 deployments using pcode; 2) You may want to consider migrating to PowerBuilder 11.1 rather than version 11 to take advantage of the incremental compilation that was added. Otherwise your entire application will have to be compiled before you can see the runtime impact of the modification of a single line of code or even a minimal layout change in one of the visual painters. While the runtime speed is comparable to Win32 deployments, full build-and-deploy times for a library list of PBLs amounting to 150MB can take as much as a half-hour.

Additional Resources
Additional resources are available to aid you in this process. Besides the white papers and tech tips available from the support section of the Sybase Web site, there are technical articles in the PowerBuilder Developer Journal, the ISUG Journal, as well as the International Developer Magazine. The most notable supplemental resources in my opinion are the PowerBuilder newsgroups.

www.sybase.com/detail_list?id=11507&multi=true&SR=Y&show=1248

Sybase Newsgroups
The Sybase newsgroups are where your peers and a group of skilled volunteers (TeamSybase and Team iAnywhere) answer questions posted on a range of Sybase products and solutions. I can't think of a better place to get an answer to a question by a person who discovered the solution to the problem you're experiencing today...six months ago.

www.sybase.com/support/community-forums

The Most Productive .NET Developer
PowerBuilder isn't the first development tool to take you to .NET, but it's among the first. Sybase wanted to ensure that PowerBuilder users could take their applications and their components to .NET long before they had to. PowerBuilder ensures that you don't have to rewrite all of your applications completely from the ground up to take them to .NET...unlike some of its competitors have.

PowerBuilder 11's WinForm deployment capabilities take the PowerBuilder presentation layer application of your two-tier or n-tier solution to .NET today and preserves your standing as the most productive business application developer on the block.

More Stories By John Strano

John Strano is a Sybase Technology Evangelist and is a charter member of TeamSybase. He has been using PowerBuilder since 1991 and has authored articles for multiple industry periodicals. John has been a Sybase Certified Instructor and has presented Sybase tools on an international basis since 1997. Over the last 17 years John has developed a variety of PowerBuilder applications from single-user scaling up to enterprise-class, web-based projects.

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.


@ThingsExpo Stories
It is of utmost importance for the future success of WebRTC to ensure that interoperability is operational between web browsers and any WebRTC-compliant client. To be guaranteed as operational and effective, interoperability must be tested extensively by establishing WebRTC data and media connections between different web browsers running on different devices and operating systems. In his session at WebRTC Summit at @ThingsExpo, Dr. Alex Gouaillard, CEO and Founder of CoSMo Software, presented ...
Most people haven’t heard the word, “gamification,” even though they probably, and perhaps unwittingly, participate in it every day. Gamification is “the process of adding games or game-like elements to something (as a task) so as to encourage participation.” Further, gamification is about bringing game mechanics – rules, constructs, processes, and methods – into the real world in an effort to engage people. In his session at @ThingsExpo, Robert Endo, owner and engagement manager of Intrepid D...
Recently, WebRTC has a lot of eyes from market. The use cases of WebRTC are expanding - video chat, online education, online health care etc. Not only for human-to-human communication, but also IoT use cases such as machine to human use cases can be seen recently. One of the typical use-case is remote camera monitoring. With WebRTC, people can have interoperability and flexibility for deploying monitoring service. However, the benefit of WebRTC for IoT is not only its convenience and interopera...
Michael Maximilien, better known as max or Dr. Max, is a computer scientist with IBM. At IBM Research Triangle Park, he was a principal engineer for the worldwide industry point-of-sale standard: JavaPOS. At IBM Research, some highlights include pioneering research on semantic Web services, mashups, and cloud computing, and platform-as-a-service. He joined the IBM Cloud Labs in 2014 and works closely with Pivotal Inc., to help make the Cloud Found the best PaaS.
Everything run by electricity will eventually be connected to the Internet. Get ahead of the Internet of Things revolution. In his session at @ThingsExpo, Akvelon expert and IoT industry leader Sergey Grebnov provided an educational dive into the world of managing your home, workplace and all the devices they contain with the power of machine-based AI and intelligent Bot services for a completely streamlined experience.
Cloud-enabled transformation has evolved from cost saving measure to business innovation strategy -- one that combines the cloud with cognitive capabilities to drive market disruption. Learn how you can achieve the insight and agility you need to gain a competitive advantage. Industry-acclaimed CTO and cloud expert, Shankar Kalyana presents. Only the most exceptional IBMers are appointed with the rare distinction of IBM Fellow, the highest technical honor in the company. Shankar has also receive...
Business professionals no longer wonder if they'll migrate to the cloud; it's now a matter of when. The cloud environment has proved to be a major force in transitioning to an agile business model that enables quick decisions and fast implementation that solidify customer relationships. And when the cloud is combined with the power of cognitive computing, it drives innovation and transformation that achieves astounding competitive advantage.
Personalization has long been the holy grail of marketing. Simply stated, communicate the most relevant offer to the right person and you will increase sales. To achieve this, you must understand the individual. Consequently, digital marketers developed many ways to gather and leverage customer information to deliver targeted experiences. In his session at @ThingsExpo, Lou Casal, Founder and Principal Consultant at Practicala, discussed how the Internet of Things (IoT) has accelerated our abilit...
In his session at Cloud Expo, Alan Winters, U.S. Head of Business Development at MobiDev, presented a success story of an entrepreneur who has both suffered through and benefited from offshore development across multiple businesses: The smart choice, or how to select the right offshore development partner Warning signs, or how to minimize chances of making the wrong choice Collaboration, or how to establish the most effective work processes Budget control, or how to maximize project result...
To get the most out of their data, successful companies are not focusing on queries and data lakes, they are actively integrating analytics into their operations with a data-first application development approach. Real-time adjustments to improve revenues, reduce costs, or mitigate risk rely on applications that minimize latency on a variety of data sources. In his session at @BigDataExpo, Jack Norris, Senior Vice President, Data and Applications at MapR Technologies, reviewed best practices to ...
Data is the fuel that drives the machine learning algorithmic engines and ultimately provides the business value. In his session at Cloud Expo, Ed Featherston, a director and senior enterprise architect at Collaborative Consulting, discussed the key considerations around quality, volume, timeliness, and pedigree that must be dealt with in order to properly fuel that engine.
In his keynote at 19th Cloud Expo, Sheng Liang, co-founder and CEO of Rancher Labs, discussed the technological advances and new business opportunities created by the rapid adoption of containers. With the success of Amazon Web Services (AWS) and various open source technologies used to build private clouds, cloud computing has become an essential component of IT strategy. However, users continue to face challenges in implementing clouds, as older technologies evolve and newer ones like Docker c...
"Akvelon is a software development company and we also provide consultancy services to folks who are looking to scale or accelerate their engineering roadmaps," explained Jeremiah Mothersell, Marketing Manager at Akvelon, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
Two weeks ago (November 3-5), I attended the Cloud Expo Silicon Valley as a speaker, where I presented on the security and privacy due diligence requirements for cloud solutions. Cloud security is a topical issue for every CIO, CISO, and technology buyer. Decision-makers are always looking for insights on how to mitigate the security risks of implementing and using cloud solutions. Based on the presentation topics covered at the conference, as well as the general discussions heard between sessio...
To Really Work for Enterprises, MultiCloud Adoption Requires Far Better and Inclusive Cloud Monitoring and Cost Management … But How? Overwhelmingly, even as enterprises have adopted cloud computing and are expanding to multi-cloud computing, IT leaders remain concerned about how to monitor, manage and control costs across hybrid and multi-cloud deployments. It’s clear that traditional IT monitoring and management approaches, designed after all for on-premises data centers, are falling short in ...
Organizations planning enterprise data center consolidation and modernization projects are faced with a challenging, costly reality. Requirements to deploy modern, cloud-native applications simultaneously with traditional client/server applications are almost impossible to achieve with hardware-centric enterprise infrastructure. Compute and network infrastructure are fast moving down a software-defined path, but storage has been a laggard. Until now.
DXWorldEXPO LLC announced today that the upcoming DXWorldEXPO | CloudEXPO New York event will feature 10 companies from Poland to participate at the "Poland Digital Transformation Pavilion" on November 12-13, 2018.
Digital Transformation is much more than a buzzword. The radical shift to digital mechanisms for almost every process is evident across all industries and verticals. This is often especially true in financial services, where the legacy environment is many times unable to keep up with the rapidly shifting demands of the consumer. The constant pressure to provide complete, omnichannel delivery of customer-facing solutions to meet both regulatory and customer demands is putting enormous pressure on...
The best way to leverage your CloudEXPO | DXWorldEXPO presence as a sponsor and exhibitor is to plan your news announcements around our events. The press covering CloudEXPO | DXWorldEXPO will have access to these releases and will amplify your news announcements. More than two dozen Cloud companies either set deals at our shows or have announced their mergers and acquisitions at CloudEXPO. Product announcements during our show provide your company with the most reach through our targeted audienc...
In an era of historic innovation fueled by unprecedented access to data and technology, the low cost and risk of entering new markets has leveled the playing field for business. Today, any ambitious innovator can easily introduce a new application or product that can reinvent business models and transform the client experience. In their Day 2 Keynote at 19th Cloud Expo, Mercer Rowe, IBM Vice President of Strategic Alliances, and Raejeanne Skillern, Intel Vice President of Data Center Group and ...