We are developing applications with SQL Anywhere 11.0.1 and PowerBuilder 11.5.1. Now we have a big issue with our database (see my previous question about inconsistent results). I have tested the same query with the newest SQL Anywhere Version 16 and can not reproduce the issue. So we plan to upgrade the database to version 16 from version 11.
Have anybody experience with upgrading the database from 11 to 16?
Are there any known compatibility issues between SQL Anywhere 16 and PowerBuilder 11.5.1?
Would you recommend to rebuild (unload/load) or to upgrade to SQL Anywhere 16?
What if we don't upgrade/rebuild the database, so that the database is backwards compatible? Do we have to expect problems if we just run the v11 database under the SQL Anyhwere 16 server?
I can't answer the PB to V16 issue yet but I can say there was at least one issue that snagged us going from SA 11 to SA 12 - and this would affect any developer - not just Powerbuilder.
In SA11 and earlier versions database retrievals had a natural order to them - meaning the rows came back in the order of keys or sequence entered (cant remember which) when there was not a specific detailed order by or datawindow sort designated. In v12 and I assume V16 there is guaranteed no sequence at all and they return in very random fashion.
Is is therefore possible that some of your programs or reports that looked ordered in V11 will suddenly look very disordered. The cure to this is to inspect every Query to insure you specify the required order - either in the SQL (which can tie the system up a bit) or in the data windows. It took us quite a while to go thru many hundreds of data windows to clean this up.
answered 23 Jul '13, 09:27