A SQL Ranger friend of mine in the UK gave me the heads up to this yesterday. (Thanks, Ben!!) Apparently, back in December 2008, Sybase ported some of our samples to SQL Anywhere. Needless to say, I’ve got mixed feelings about Sybase porting AdventureWorks to their platform. Sort of like a cherry-cheese Danish: it’s a pastry and pastries are supposed to taste good, right? But cherries and cheese? Ick. (I’m on a severely calorically restricted diet; sorry for the digression.)
As SQL Server 2008 and SQL Anywhere 11 are two very different database solutions, the ‘AdventureWorks2008’ database will appear slightly different, and offer a few functional differences. These incongruities are the result of different feature sets, which are intrinsic to each database’s design. AdventureWorks2008 Sample Database for SQL Anywhere Download: Mobile Enterprise, Database Management iAnywhere - Sybase Inc
We license AdventureWorks under the Ms-PL, so anybody’s welcome to do whatever they want with our code. It’s out there for learning purposes. Sybase seems to have learned that SQL Anywhere 11 doesn’t do a lot of the really cool things that SQL Server 2008 does! They only ported the OLTP database – I wonder why they ignored DW and LT??
The Sybase port of AdventureWorks2008 drops the following features:
Anyway, I don’t have a SQL Anywhere installation to try it out on, but that list from their own website reads (to me) like a list of reasons to use SQL Server 2008 instead. It looks like they ported our .NET samples for AdventureWorks2008, too, so I have to wonder if they’re equally limited as the AdventureWorks2008 port?
I do hope that SQL Anywhere customers do get some benefit out of using the port of our sample OLTP database (or switch to SQL Server 2008 where they can get the full functionality of AdventureWorks2008). I’d also like to invite Oracle and DB2 to port AdventureWorks2008 to their platforms so that the world can see how much of our feature set they don’t support, either. Heh.
PingBack from http://windows7news.com.au/2009/01/23/sybase-loves-adventureworks2008/
Dear Mr. Reed,
I'm not used to reading your blog, and that won't change, I guess.
I just want to link to a comment to this post from one of iAnywhere's program managers.
One of those advantages I see with SQL Anywhere seems to be related to the tone the responsible managers choose – clearly noticable when comparing his and your post.
Guess that's the difference, Volker, between a personal blog and a corporate blog written by marketing and legal. *shrug*
As the person who wrote that blog response, Ouch!
Once again, just to state and correct the facts, I wrote it without the "help" of either legal or marketing. Though my blog is hosted on sybase.com (as yours is hosted by microsoft), I am responsible for the content of it. I would not be blogging otherwise.
However, I am Canadian, so maybe that explains the difference in tone...
That's right, I forgot that all Ugly Americans™ (to abuse Steve Jones' term) like me are rude and mostly too opinionated for their own good or anyone elses.
I call 'em like I see 'em. Sorry. Overly polite, carefully worded, sweet nothings that read like marketing copy... Well, blame it on Texas, if that helps. After all I lived there for 17 years before I moved to the rainy PNW where the Irish climate agrees with my disposition a bit more.