As I come from a SQL Server background I am not sure what the Sybase equivalent for a Service pack is.
I know Sybase have a list of EBF's but are these the equivalent of Hotfixes in SQL Server? More specifically are EBF's cumulative or do they only fix one issue at a time? I also noticed that EBFs are "moderately" tested.
What is the usual thing to do if I am wanting to move to SQL Anywhere 11 from SQL Anywhere 10 and want to ensure that I have the latest "version". Do I install the latest EBF or is there some Fully tested "service pack" out there that I should install on a clean system?
SQL Anywhere installations are usually identified by version and build; e.g., 188.8.131.526 where 11.0.1 is the version and 2276 is the build.
EBFs are cumulative within a version number, and each one provides you with a new build for that version. For example, EBFs for version 11.0.0 are cumulative within 11.0.0, and EBFs for 11.0.1 are cumulative within 11.0.1 but separate from the EBFs for 11.0.0.
There are three kinds of deliverables when it comes to building your installation:
So, to move from 10 to 11, you probably need the 11.0.1 initial setup plus a recent EBF for 11.0.1... or you can use the long road (11.0.0 setup, 11.0.1 upgrade, recent EBF).
I have had good experience with EBFs as far as quality is concerned. After a new version has been around for a while, it is probably a good idea to apply an EBF to get all the initial fixes. After that, EBFs should probably only be installed if they fix a known problem that is affecting you. I.e., I'm still using 184.108.40.2066 which is fairly old, but not as old as the original 11.0.1 build... rock solid, IMO.
SQL Anywhere doesn't have the equivalent of SQL Server service packs, which seem to be more frequent than SQL Anywhere versions but much less frequent than EBFs. FWIW I had to back out an MSS SP not long ago, where "back out" meant uninstall, reinstall and restore database. I am saying that to simply point out that stuff happens with all software products, and you have to be especially careful with DBMS software... testing is a critical part of upgrading.
EBFs are cumulative, so it is sufficient to install the latest. Fully tested are releases which result in a new version number like 11.0.1.
answered 06 Jul '10, 08:37