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? Thanks, Warren. asked 06 Jul '10, 02:54 warren Breck Carter |
SQL Anywhere installations are usually identified by version and build; e.g., 11.0.1.2276 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 11.0.1.2276 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. answered 06 Jul '10, 09:43 Breck Carter 1
Just to add: The "only documentation" each EBF comes with is its readme file. I would generally recommend to look into that (usually even before downloading the EBF) to see if new functionality of interest is introduced or if one might be affected with any fixes. (Though the latter is sometimes hard to tell because the bug fix descriptions are not - and possibly can't be - that detailed.) Comment Text Removed
Great Answer! Thanks very much for the detailed response... That clears up a few things. I'm going to install the latest EBF to bring it to build 11.0.1.2452 Further to Volker's point about the "read me" file... if an EBF does introduce a behavior change or new feature, that is where it will be documented. |
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 Martin |
That's one of the questions that could get an "all-time-classic" tag, methinks. Thanks for raising it on the appropriate platform!