Hi - I am a complete newbie here, so patience always appreciated... I need to develop a web-based product with a db that allows db sync versus replication. So there will be a cloud-based (whole) db with many partial db nodes that may or may not be online all the time, but need to be (two-way) sync'ed when connected. SQL AnyWhere seems to own this space.
My question is around front-end frameworks and tools. Is there an existing product comparable to say, the Sitefinity CMS (or similar) as a starting point, that exists on top of SQL AnyWhere, or are most UI/front-ends built from square 1?
Thanks in advance.
asked 11 Aug '15, 15:04
Welcome to SQL Anywhere!
As far as I can tell Sitefinity publicly supports SQLEXPRESS and Microsoft SQL Server (because the migration from one to the other is discussed here).
If that kind of migration is "easy" (nothing is ever really easy, but never mind) then there shouldn't be any reason why Sitefinity could not use SQL Anywhere. FWIW SQL Anywhere offers a high degree of Transact SQL compatibility... I'm not recommending the use of Transact SQL syntax, just offering this point as evidence of how SQL Anywhere is a perfectly good substitute for SQL Server (and much more flexible and powerful at the SQL syntax level).
Yes, SQL Anywhere owns the relational database synchronization market with MobiLink, which comes in-the-box (and is included in the Developer Edition).
So, even though you might be an Early Adopter (the First Adopter?) for Sitefinity-on-SQL-Anywhere, there's no reason you shouldn't try a proof-of-concept. If you have any questions, ask them here... we might not have a clue about Sitefinity but "not having a clue" is not an impediment :)
answered 12 Aug '15, 07:39