Welcome!

Agile Computing Authors: Kevin Jackson, Xenia von Wedel, Elizabeth White, Dana Gardner, Pat Romanski

Related Topics: Microsoft Cloud, PowerBuilder

Microsoft Cloud: Article

PowerBuilder Takes You To .NET

Preparing PowerBuilder applications for .NET Windows Forms deployment

Remember Win16? Whatever happened to it? Where did it go? It hung around for a while in the Win95/Win98 days alongside Win32 but then it went away. Well, wherever Win16 went, Win32 is going there too. Eventually, .NET will be the "native" Windows desktop technology and WinForm or its descendant will be the primary de facto API.

PowerBuilder is arguably the most productive (read fastest and easiest) .NET development tool on the market today. It doesn't require .NET experience on the part of the developer and the conditional compilation feature allows PowerBuilder applications to be maintained as a single code line for Win32 as well as for .NET deployments.

WinForm Benefits
Well, let's say that your company or your client's hasn't established a requirement, a standard, to move to deploying .NET applications quite yet. "Why should I explore deploying to .NET WinForm? I'm not required to deploy to .NET yet and I'll just end up with another client/server application...right?" The main benefits of deploying PowerBuilder applications as .NET WinForm are twofold: .NET interoperability and .NET Smart Client publishing.

.NET Interoperability
There are some fairly nice things in the .NET Framework. Think about the PowerBuilder projects in the past from which you've made external function calls, to which you added ActiveX/OCX, in which you implemented OLE. Think of the .NET Framework as a big fat external resource of which you'd like to take advantage. You may have a partner, a vendor, a .NET development group in your own company who's developed .NET resources with which you'd like to integrate your PowerBuilder applications. Once you deploy your PowerBuilder applications to WinForm (or WebForm), you can.

www.sybase.com/products/development/powerbuilder/videos

Smart Client Publishing
A major headache in supporting applications in production has historically been deployment. Browser-based applications became popular because of the prospect of the immediate and automatic update of application business logic and user interface for every single user. But even with the rising popularity of Rich Internet Applications (RIAs), anything in the browser has some intractable compromise lurking somewhere. Oh, and by the way, classic Web application projects still tend to be more expensive than their 4GL-developed counterparts.

What if you could take advantage of the best of both worlds? What if you could deploy your application and its updates using the ubiquity of the Web, but have the users end up with an uncompromised, rich-interfaced, fully functional application on their desktops with no browser-based compromises?

Applications operating on the workstation exploit client-side resources, reduce server load, don't consume as much bandwidth, and overall have better performance.

Once you deploy/compile your PowerBuilder application as .NET WinForm, your application and its updates can be "published" to the users' workstations just by filling in some property sheets, in a code-free manner by clicking a button...for one or 1,000 users.

www.sybase.com/products/development/powerbuilder/videos

http://video.sybase.com/webcasts/PB11SC3-020108.wmv

Game Plan
The approach to prepare your PowerBuilder application for WinForm deployment is twofold:

  1. Migrate forward to PowerBuilder 11.
  2. Modify your application to work around PowerBuilder features that may not be supported for .NET WinForm deployment.
While these two points are the salient ones, I'll also go into a couple of notable ancillary subtopics as well.

Before you start any part of this process, please...back up your PBLs! I can't tell you how often some poor soul posts a request on the PowerBuilder newsgroup saying he's lost his source or that his libraries have become corrupted somehow and is there a way to decompile his executables into source code. Please, folks, only perform the operations I'll discuss now with libraries that are backed up or are a working copy of your PBLs. And, remember, a backup is only as good as its restore. Verify that you can successfully restore your valuable collateral.

The Recipe
So here's a more detailed recipe for preparing and deploying a PowerBuilder application for WinForm:

  • Backup, backup, BACKUP!
  • Check in all classes from source control.
  • Backup, backup, BACKUP! (Sense a pattern?)
  • Install the required external resources.
    - http://infocenter.sybase.com/help/topic/com.sybase.dc37771_1100/pdf/pbeinst.pdf
  • Install PowerBuilder 11.x
  • Use the Migration Assistant tool (more later)
  • Formulate your Migration Plan
  • Address migration issues that are discovered
  • Backup, backup, BACKUP!
  • Migrate your application
  • Perform a Win32 compilation
  • Perform Quality Assurance
  • Backup, backup, BACKUP!
  • Create a WinForm deployment Target and Project
    - www.sybase.com/products/development/powerbuilder/videos
  • Perform an initial WinForm deployment
  • Save the Unsupported Features output log
  • Use the .NET Features Analyzer IDE Add-in tool (more later)
  • Formulate your Refactoring Plan
  • Refactor/modify your application to work around features unsupported for WinForm
  • Perform a "final" WinForm deployment
  • Back it up, folks
  • Perform Quality Assurance
  • Take advantage of .NET interoperability
  • Take Advantage of .NET smart client deployment/publishing

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
Internet of @ThingsExpo, taking place November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with the 19th International Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world and ThingsExpo Silicon Valley Call for Papers is now open.
Machine Learning helps make complex systems more efficient. By applying advanced Machine Learning techniques such as Cognitive Fingerprinting, wind project operators can utilize these tools to learn from collected data, detect regular patterns, and optimize their own operations. In his session at 18th Cloud Expo, Stuart Gillen, Director of Business Development at SparkCognition, discussed how research has demonstrated the value of Machine Learning in delivering next generation analytics to imp...
SYS-CON Events announced today that ReadyTalk, a leading provider of online conferencing and webinar services, has been named Vendor Presentation Sponsor at the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. ReadyTalk delivers audio and web conferencing services that inspire collaboration and enable the Future of Work for today’s increasingly digital and mobile workforce. By combining intuitive, innovative tec...
Amazon has gradually rolled out parts of its IoT offerings, but these are just the tip of the iceberg. In addition to optimizing their backend AWS offerings, Amazon is laying the ground work to be a major force in IoT - especially in the connected home and office. In his session at @ThingsExpo, Chris Kocher, founder and managing director of Grey Heron, explained how Amazon is extending its reach to become a major force in IoT by building on its dominant cloud IoT platform, its Dash Button strat...
Connected devices and the industrial internet are growing exponentially every year with Cisco expecting 50 billion devices to be in operation by 2020. In this period of growth, location-based insights are becoming invaluable to many businesses as they adopt new connected technologies. Knowing when and where these devices connect from is critical for a number of scenarios in supply chain management, disaster management, emergency response, M2M, location marketing and more. In his session at @Th...
The cloud market growth today is largely in public clouds. While there is a lot of spend in IT departments in virtualization, these aren’t yet translating into a true “cloud” experience within the enterprise. What is stopping the growth of the “private cloud” market? In his general session at 18th Cloud Expo, Nara Rajagopalan, CEO of Accelerite, explored the challenges in deploying, managing, and getting adoption for a private cloud within an enterprise. What are the key differences between wh...
It is one thing to build single industrial IoT applications, but what will it take to build the Smart Cities and truly society changing applications of the future? The technology won’t be the problem, it will be the number of parties that need to work together and be aligned in their motivation to succeed. In his Day 2 Keynote at @ThingsExpo, Henrik Kenani Dahlgren, Portfolio Marketing Manager at Ericsson, discussed how to plan to cooperate, partner, and form lasting all-star teams to change t...
In his keynote at 18th Cloud Expo, Andrew Keys, Co-Founder of ConsenSys Enterprise, provided an overview of the evolution of the Internet and the Database and the future of their combination – the Blockchain. Andrew Keys is Co-Founder of ConsenSys Enterprise. He comes to ConsenSys Enterprise with capital markets, technology and entrepreneurial experience. Previously, he worked for UBS investment bank in equities analysis. Later, he was responsible for the creation and distribution of life sett...
19th Cloud Expo, taking place November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA, will feature technical sessions from a rock star conference faculty and the leading industry players in the world. Cloud computing is now being embraced by a majority of enterprises of all sizes. Yesterday's debate about public vs. private has transformed into the reality of hybrid cloud: a recent survey shows that 74% of enterprises have a hybrid cloud strategy. Meanwhile, 94% of enterpri...
SYS-CON Events announced today that Bsquare has been named “Silver Sponsor” of SYS-CON's @ThingsExpo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. For more than two decades, Bsquare has helped its customers extract business value from a broad array of physical assets by making them intelligent, connecting them, and using the data they generate to optimize business processes.
There are several IoTs: the Industrial Internet, Consumer Wearables, Wearables and Healthcare, Supply Chains, and the movement toward Smart Grids, Cities, Regions, and Nations. There are competing communications standards every step of the way, a bewildering array of sensors and devices, and an entire world of competing data analytics platforms. To some this appears to be chaos. In this power panel at @ThingsExpo, moderated by Conference Chair Roger Strukhoff, Bradley Holt, Developer Advocate a...
Internet of @ThingsExpo, taking place November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with 19th Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The Internet of Things (IoT) is the most profound change in personal and enterprise IT since the creation of the Worldwide Web more than 20 years ago. All major researchers estimate there will be tens of billions devices - comp...
There is little doubt that Big Data solutions will have an increasing role in the Enterprise IT mainstream over time. Big Data at Cloud Expo - to be held November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA - has announced its Call for Papers is open. Cloud computing is being adopted in one form or another by 94% of enterprises today. Tens of billions of new devices are being connected to The Internet of Things. And Big Data is driving this bus. An exponential increase is...
A strange thing is happening along the way to the Internet of Things, namely far too many devices to work with and manage. It has become clear that we'll need much higher efficiency user experiences that can allow us to more easily and scalably work with the thousands of devices that will soon be in each of our lives. Enter the conversational interface revolution, combining bots we can literally talk with, gesture to, and even direct with our thoughts, with embedded artificial intelligence, wh...
Cloud computing is being adopted in one form or another by 94% of enterprises today. Tens of billions of new devices are being connected to The Internet of Things. And Big Data is driving this bus. An exponential increase is expected in the amount of information being processed, managed, analyzed, and acted upon by enterprise IT. This amazing is not part of some distant future - it is happening today. One report shows a 650% increase in enterprise data by 2020. Other estimates are even higher....
Cognitive Computing is becoming the foundation for a new generation of solutions that have the potential to transform business. Unlike traditional approaches to building solutions, a cognitive computing approach allows the data to help determine the way applications are designed. This contrasts with conventional software development that begins with defining logic based on the current way a business operates. In her session at 18th Cloud Expo, Judith S. Hurwitz, President and CEO of Hurwitz & ...
In his general session at 18th Cloud Expo, Lee Atchison, Principal Cloud Architect and Advocate at New Relic, discussed cloud as a ‘better data center’ and how it adds new capacity (faster) and improves application availability (redundancy). The cloud is a ‘Dynamic Tool for Dynamic Apps’ and resource allocation is an integral part of your application architecture, so use only the resources you need and allocate /de-allocate resources on the fly.
The 19th International Cloud Expo has announced that its Call for Papers is open. Cloud Expo, to be held November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA, brings together Cloud Computing, Big Data, Internet of Things, DevOps, Digital Transformation, Microservices and WebRTC to one location. With cloud computing driving a higher percentage of enterprise IT budgets every year, it becomes increasingly important to plant your flag in this fast-expanding business opportuni...
industrial company for a multi-year contract initially valued at over $4.0 million. In addition to DataV software, Bsquare will also provide comprehensive systems integration, support and maintenance services. DataV leverages advanced data analytics, predictive reasoning, data-driven diagnostics, and automated orchestration of remediation actions in order to improve asset uptime while reducing service and warranty costs.
Vidyo, Inc., has joined the Alliance for Open Media. The Alliance for Open Media is a non-profit organization working to define and develop media technologies that address the need for an open standard for video compression and delivery over the web. As a member of the Alliance, Vidyo will collaborate with industry leaders in pursuit of an open and royalty-free AOMedia Video codec, AV1. Vidyo’s contributions to the organization will bring to bear its long history of expertise in codec technolo...