I'm upgrading SQLA from version 7 to version 12 and was entitled to give a small workshop regarding new features of the new version. I know that I can read the documentation and find some of them but, as I don't have any experience with this new version, I'm afraid of skipping some good or small improvement that made a big difference in running it. Could anyone share your opinion about it?
asked 23 Jan '12, 15:43
Not only did Version 12 contribute new features, but Versions 8 through 11 as well. The "Changes and Upgrading" section of the Help only goes back as far as Version 10 but it is well worth browsing for the highlights.
Many of the new features in Version 9 were covered in the book SQL Anywhere Studio 9 Developer's Guide.
And then there's my blog and the blogs by Chris Kleisath, Glenn Paulley, Tom Slee, Eric Farrar and Jason Hinsperger... lots of new features discussed there over the past four years.
The Big New Feature, of course, has been all the performance improvements over the years. You may find the occasional Query From Hell that performs worse than it did in Version 7 but for the most part everything will run much faster.
answered 23 Jan '12, 16:38
What is "best" about version 12 is going to depend on what you need!
Breck Carter wrote "Top 10 Features in SQL Anywhere 12" so perhaps that is a place to start.
Since SA 12 is built on SA 11 then Breck's paper on "Top 10 Cool New Features in SQL Anywhere 11" may also be an interesting read.
Similarly "Top 10 Cool New Features on SQL Anywhere 10" could be of some use to you.