SQL Anywhere 5 upgrade (yes, FIVE!)

[Former Member]

Hi.

We currently have legacy Powerbuilder 6 applications which are quite happily running away on SQL Anywhere 5. We have 12 concurrent licences.

Due to server upgrades our DBAs want to update this to SQL Anywhere 17, if possible. I don't really understand the versions and licencing structure now so am looking for some advice. Simple question - what is the cheapest option to replicate what we have? We have 3 databases running under one instance of SQL Anywhere 5 on a virtual server. the databases are used daily but do not have heavy traffic. We could get away with 7 concurrent licences (if they still exist) but would need 12 if it's per seat.

Any advice appreciated.

[chris_keating]

SQL Anywhere 17 Edge Edition, workplace (core) would likely be the closest. This allows unlimited concurrent users. Here is information on SAP Store:

link

There is also a named user (similar to per seat) that comes in 5 and 10 user Edge Editions that would require additional named user licenses to get to the desired 12 users.

[former_SQLA_member1694880]

In move from V5 to V17, licensing is going to be the simplest part.

[Breck_Carter]

Please don't post content that causes display problems with the forum software. I have edited your comment to use an anchor tag instead of a raw uri that doesn't wrap properly. Thank you.

[Breck_Carter]

> licensing is going to be the simplest part

That's so funny! 🙂

[VolkerBarth]

I would be interested in the OP's currently used OS - I have never been successful in running v5.5 on Windows 7 or newer, and using a v9 database engine with v5.5 databases turned out difficult because of charset issues (y'know, v5.5's ODBC driver had a separate translator DLL.).

---

On the other hand, nowadays I have found out that getting one's already bought licenses isn't that easy in the SAP Support Portal, either - although probably still much easier than upgrading the application/clients from v5.5.