Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

We have a large application written primarily in PowerBuilder which we want to move from SQL Anywhere 16 to SQL ANywhere 17. we are using the ODBC interface.

What problems or issues might we run into?

Are there any helpful sources about migration?

asked 07 Jul '22, 20:20

Glenn%20Barber's gravatar image

Glenn Barber
accept rate: 8%

I'd recommend to have a look at the "What's New" sections of the v17 docs and the according "read me" files. There have been some changes and many bug fixes w.r.t. ODBC according to the read me files.

That being said, I guess it's difficult to tell whether a particular application needs some adaptions or not – and there are certainly new features and many advantages you may want to make use of... possibly after a migration.

(08 Jul '22, 10:20) Volker Barth

Our ERP system is written in an elderly version of PowerBuilder. We had no issues with the upgrade from 16 to 17 when we did it a few years back. I was cautious enough to make sure all the clients got the v17 ODBC drivers, though in testing we didn't have any issues with the v16 drivers. We also took the opportunity to do a DBUNLOAD and a re-load into a freshly minted V17 database.

permanent link

answered 08 Jul '22, 08:00

Bud%20Durland%20MRP's gravatar image

Bud Durland MRP
accept rate: 25%

...yes, do what Bud did and you will be successful.

Here's a "Just In Case" suggestion: Save a complete installed copy of SQL Anywhere 16. Old copies of dbisql, and of the ODBC driver, have proven to be handy in the past for dealing with minor glitches.

As a developer, I regularly switch between the V17 and 16 dbisql GUIs... V17 to compare plans and V16 because of the productivity [cough] differences :)

(09 Jul '22, 14:36) Breck Carter

Productivity differences???

(15 Jul '22, 17:18) Glenn Barber
Replies hidden

I guess Breck refers to the lost message pane in V17's DBISQL, see here.

(16 Jul '22, 05:34) Volker Barth

> the lost message pane

The pain is still fresh ( pun intended :)

It's hard to believe 6 years have passed.

(16 Jul '22, 06:58) Breck Carter
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 07 Jul '22, 20:20

question was seen: 934 times

last updated: 16 Jul '22, 06:58