Welcome!

Agile Computing Authors: Yeshim Deniz, Pat Romanski, Elizabeth White, ManageEngine IT Matters, Liz McMillan

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
SYS-CON Events announced today that TechTarget has been named “Media Sponsor” of SYS-CON's 21st International Cloud Expo, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. TechTarget storage websites are the best online information resource for news, tips and expert advice for the storage, backup and disaster recovery markets.
SYS-CON Events announced today that CA Technologies has been named "Platinum Sponsor" of SYS-CON's 21st International Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. CA Technologies helps customers succeed in a future where every business - from apparel to energy - is being rewritten by software. From planning to development to management to security, CA creates software that fuels transformation for companies in the applic...
SYS-CON Events announced today that Telecom Reseller has been named “Media Sponsor” of SYS-CON's 21st International Cloud Expo, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Telecom Reseller reports on Unified Communications, UCaaS, BPaaS for enterprise and SMBs. They report extensively on both customer premises based solutions such as IP-PBX as well as cloud based and hosted platforms.
The current age of digital transformation means that IT organizations must adapt their toolset to cover all digital experiences, beyond just the end users’. Today’s businesses can no longer focus solely on the digital interactions they manage with employees or customers; they must now contend with non-traditional factors. Whether it's the power of brand to make or break a company, the need to monitor across all locations 24/7, or the ability to proactively resolve issues, companies must adapt to...
SYS-CON Events announced today that TMC has been named “Media Sponsor” of SYS-CON's 21st International Cloud Expo and Big Data at Cloud Expo, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Global buyers rely on TMC’s content-driven marketplaces to make purchase decisions and navigate markets. Learn how we can help you reach your marketing goals.
Amazon started as an online bookseller 20 years ago. Since then, it has evolved into a technology juggernaut that has disrupted multiple markets and industries and touches many aspects of our lives. It is a relentless technology and business model innovator driving disruption throughout numerous ecosystems. Amazon’s AWS revenues alone are approaching $16B a year making it one of the largest IT companies in the world. With dominant offerings in Cloud, IoT, eCommerce, Big Data, AI, Digital Assista...
We build IoT infrastructure products - when you have to integrate different devices, different systems and cloud you have to build an application to do that but we eliminate the need to build an application. Our products can integrate any device, any system, any cloud regardless of protocol," explained Peter Jung, Chief Product Officer at Pulzze Systems, in this SYS-CON.tv interview at @ThingsExpo, held November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA
SYS-CON Events announced today that IBM has been named “Diamond Sponsor” of SYS-CON's 21st Cloud Expo, which will take place on October 31 through November 2nd 2017 at the Santa Clara Convention Center in Santa Clara, California.
SYS-CON Events announced today that Conference Guru has been named “Media Sponsor” of SYS-CON's 21st International Cloud Expo, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. A valuable conference experience generates new contacts, sales leads, potential strategic partners and potential investors; helps gather competitive intelligence and even provides inspiration for new products and services. Conference Guru works with conference organi...
Multiple data types are pouring into IoT deployments. Data is coming in small packages as well as enormous files and data streams of many sizes. Widespread use of mobile devices adds to the total. In this power panel at @ThingsExpo, moderated by Conference Chair Roger Strukhoff, panelists looked at the tools and environments that are being put to use in IoT deployments, as well as the team skills a modern enterprise IT shop needs to keep things running, get a handle on all this data, and deliver...
SYS-CON Events announced today that Enzu will exhibit at SYS-CON's 21st Int\ernational Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Enzu’s mission is to be the leading provider of enterprise cloud solutions worldwide. Enzu enables online businesses to use its IT infrastructure to their competitive advantage. By offering a suite of proven hosting and management services, Enzu wants companies to focus on the core of their ...
In his session at @ThingsExpo, Eric Lachapelle, CEO of the Professional Evaluation and Certification Board (PECB), provided an overview of various initiatives to certify the security of connected devices and future trends in ensuring public trust of IoT. Eric Lachapelle is the Chief Executive Officer of the Professional Evaluation and Certification Board (PECB), an international certification body. His role is to help companies and individuals to achieve professional, accredited and worldwide re...
IoT solutions exploit operational data generated by Internet-connected smart “things” for the purpose of gaining operational insight and producing “better outcomes” (for example, create new business models, eliminate unscheduled maintenance, etc.). The explosive proliferation of IoT solutions will result in an exponential growth in the volume of IoT data, precipitating significant Information Governance issues: who owns the IoT data, what are the rights/duties of IoT solutions adopters towards t...
With the introduction of IoT and Smart Living in every aspect of our lives, one question has become relevant: What are the security implications? To answer this, first we have to look and explore the security models of the technologies that IoT is founded upon. In his session at @ThingsExpo, Nevi Kaja, a Research Engineer at Ford Motor Company, discussed some of the security challenges of the IoT infrastructure and related how these aspects impact Smart Living. The material was delivered interac...
The current age of digital transformation means that IT organizations must adapt their toolset to cover all digital experiences, beyond just the end users’. Today’s businesses can no longer focus solely on the digital interactions they manage with employees or customers; they must now contend with non-traditional factors. Whether it's the power of brand to make or break a company, the need to monitor across all locations 24/7, or the ability to proactively resolve issues, companies must adapt to...
With major technology companies and startups seriously embracing Cloud strategies, now is the perfect time to attend 21st Cloud Expo October 31 - November 2, 2017, at the Santa Clara Convention Center, CA, and June 12-14, 2018, at the Javits Center in New York City, NY, and learn what is going on, contribute to the discussions, and ensure that your enterprise is on the right path to Digital Transformation.
No hype cycles or predictions of zillions of things here. IoT is big. You get it. You know your business and have great ideas for a business transformation strategy. What comes next? Time to make it happen. In his session at @ThingsExpo, Jay Mason, Associate Partner at M&S Consulting, presented a step-by-step plan to develop your technology implementation strategy. He discussed the evaluation of communication standards and IoT messaging protocols, data analytics considerations, edge-to-cloud tec...
When growing capacity and power in the data center, the architectural trade-offs between server scale-up vs. scale-out continue to be debated. Both approaches are valid: scale-out adds multiple, smaller servers running in a distributed computing model, while scale-up adds fewer, more powerful servers that are capable of running larger workloads. It’s worth noting that there are additional, unique advantages that scale-up architectures offer. One big advantage is large memory and compute capacity...
New competitors, disruptive technologies, and growing expectations are pushing every business to both adopt and deliver new digital services. This ‘Digital Transformation’ demands rapid delivery and continuous iteration of new competitive services via multiple channels, which in turn demands new service delivery techniques – including DevOps. In this power panel at @DevOpsSummit 20th Cloud Expo, moderated by DevOps Conference Co-Chair Andi Mann, panelists examined how DevOps helps to meet the de...
"When we talk about cloud without compromise what we're talking about is that when people think about 'I need the flexibility of the cloud' - it's the ability to create applications and run them in a cloud environment that's far more flexible,” explained Matthew Finnie, CTO of Interoute, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.