Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Migration of Datawindow if database scheme changed

  1. How-to
0
Votes
Undo
  1. Andree Rohde
    Andree Rohde
  2. PowerBuilder
  3. Thursday, 2 March 2023 15:17 PM UTC

Hi,

are there any possibilites to migrate datawindows automatically to a new database scheme, if the length of some fields have changed?

Actually i have to edit each datawindow and change the length of the database manually....

We use the ASE Database 16.5 and PB Versopn 2019 R3

 

thanks for a helpful tip

 

kr

Andree Rohde

  1. DataWindow
  2. PowerBuilder (Appeon)
LOCAL IP MAC ADDRESS
Power Builder Error Code 999
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 2 March 2023 16:27 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Andree ;

  Yes, if the DB Schema changes column sizes, then it's currently a manual DWO source code editing effort to refactor these changes in your associated DWO(s). A long time ago in the PowerSoft days, there was a DW Synchronization utility that would do that for you. Unfortunately, that utility seems to have disappeared after the PB v6.5 time frame as Sybase took over PB.  :-(

Regards ... Chris

Comment
Load more comments
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 3 March 2023 12:52 PM UTC
Hi Miguel;

Yes, they were brought back as an open source option but that was still long time ago. I'm not sure what ever happened to them though.

Regards ... Chris
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 3 March 2023 17:15 PM UTC
All ... PS: The VisualExpert Tool is also awesome for this job as you can tell it to start from a specific DB Table and then get a cross reference to all the DWO's and / or In-Line SQL that is dependent on that Schema definition. Then from that report, VE can take you right to the "to be fixed" object in the PB IDE. HTH ;-)
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 3 March 2023 21:36 PM UTC
Yes, I know about the VisualExport tool, but it's not cheap and basically they took "free code" to turn in into expensive products. Of course they're free to do so and yes, they did attribute a lot of stuff to the once "free code".
  1. Helpful
There are no comments made yet.
Responses (2)
Andreas Mykonios
Andreas Mykonios Accepted Answer Pending Moderation
  1. Friday, 3 March 2023 09:24 AM UTC
  2. PowerBuilder
  3. # 1

Hi.

I think what Chris remembers is Advanced Powerbuilder Utilities.

A screenshot from PB 5:

I don't remember if that tool was open sourced. I have to search my backup media...

Andreas.

Comment
Arnd Schmidt
  1. Arnd Schmidt
  2. Friday, 3 March 2023 11:03 AM UTC
You can find this one ... just a click away.... on CodeExchange, LOL

https://community.appeon.com/index.php/codeexchange/powerbuilder/190-advanced-powerbuilder-utilities-freeware
  1. Helpful 1
Andreas Mykonios
  1. Andreas Mykonios
  2. Friday, 3 March 2023 11:12 AM UTC
Very nice...

By the way DataWindow Extended Attribute Synchronizer seems not to be what Andree is looking for. This tool "Updates attributes of existing DataWindow objects from the PowerBuilder extended attribute tables" as it is stated.

Andreas.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.