The tool is PowerBuilder. PB will ask to migrate the PBLs when you open the 10.5 PBLs in PB 12.5.

Looks like you're asking about PowerBuilder. This forum has it's focus on SQL Anywhere. So you're probably better off in a forum like sybase.public.powerbuilder.net. See PB Newsgroups

Hi Vicky

The PowerBuilder 12.5 migration consists of the standard Powerbuilder migration (always backup your PBLs beforehand) but also 12.5 comes with SQL Anywhere 12 so you may also want to migrate your SA database from Version 11 to Version 12 (although it is not required).

The SQL Anywhere migration is done separately and is also well documented - basically it requires an unload of the Version 11 and a reload into a new V12 database. Version 12 of SA will not directly run a Version 11 database.

We have a large PB classic application with very complex datawindow queries that's been evolved since PB version 5 and are in the process of checking it out with PowerBuilder 12.5 and SQL Anywhere 12. The only problems we have experienced so far is that SQL Anywhere 11 and earlier applied a natural order to some of the query results whereas in Version 12 the order is much more random. So if you weren't paying attention to the order of the results in your datawindows (either the order by in the SQL or the Sort in the datawindow) sometime you may find that things appear in an order different than expected. This is usually simple to correct by applying the sort in the datawindow.

You might note that for some of our complex queries the SA V12 version was as much as 40% faster than V11.