How to migrate pb 10.5 to pb 12.5

[Former Member]

How to migrate pb 10.5 to pb 12.5.. Is there any tool for that..

[chris_keating]

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

[reimer_pods]

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

[glenn_barber]

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.

[Breck_Carter]

Version 12 of SA will not directly run a Version 11 database.

A version 12 server will run databases created by Version 10 and 11 software.

The database file must be recreated only when migrating from Version 9 or earlier to Version 10 or later.

[Former Member]

Where does it even say that she is using SA11?

[Former Member]

I think Glenn Barber meant "Version 9 database" since that was the version included with PowerBuilder 10.5.

[glenn_barber]

I misspoke here, I am assuming she was using the V9 that came with the earlier version.

[glenn_barber]

Correct...