1. Daryl Foster
  2. PowerBuilder
  3. Tuesday, 25 September 2018

Hi everyone,

After almost 20 years we've decided to migrate all our applications from ASE to MS SQL Server.  We've been able to use SQL Server Migration Assistant to migrate the database and I'm looking at updating my Powerbuilder code to work with SQL Server.  It looks like my main job is going to be converting all the *= syntax I've used over the years. But I'm wondering if anyone who has migrated their Powerbuilder applications from ASE to MS SQL Server in the past has any tips, tricks or advice for me?

We are currently using Appeon PB 2017 R2 and ASE 16.  We are migrating to SQL Server 2017

Thanks.

Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

Hi Daryl;

   If your DWO's have a PBSELECT type of SQL in them (aka saved in "Graphics mode") - then the run-time SQL will follow the newer outer join syntax automatically by adding OJSyntax=ANSI_Escape to your DBParm field of the App's Transaction Object.

   However, if you saved your DWO's using the SQL setting in "Syntax Mode" - then the SQL in those objects will be treated "as is" at run-time (basically WYSIWYG). The same for in-line SQL. The only way to fix these DML statements is to manually wade through them and hand code the changes.

  This utility (SqlXtract) could identify all your DWO's that work in Syntax vs Graphic mode. It can also reconstitute the working DML and export it to text files (if that helps) to help with the conversion using external SQL tools.

Regards ... Chris

Comment
Thanks Chris
  1. Daryl Foster
  2. Thursday, 27 September 2018
There are no comments made yet.
  1. Tuesday, 25 September 2018
  2. PowerBuilder
  3. # 1
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.