Can Sybase Sql Anywhere be deployed as VistaDB (or MSAccess)?
Context: My current project is using VistaDB because it really follows the main scenario: a user logs into the application, selects a DB (a file on a hard drive or a network drive), does his job, and then logs out. DB (single file) can be copied (email, USB key, CD ...) and transferred to colleagues or to headquarters. And best of all, the DB is free!
The bad part is that the DB requires frequent maintenance to prevent file bloat because the files get really big and slow, but worst of all is data corruption. My clients are mostly located in third world countries where power shortages happen several times a day, they can't make 10 backups a day, and I can't get them to buy UPS (I recommended it nonetheless).
These clients don't seem to realize that they lost their DB because they didn't follow my advice ... to some extent I agree with them. I had to choose a failover db to start with ..
Question: Can Sql Anywhere do the trick? I mean a suitable use case and robust enough to prevent data corruption from unexpected computer shutdowns?
If you've reviewed Sybase Savvy, can you please tell us which license I will need to buy, and what license each of my customers will have to buy? I have already emailed the Sybase sales team but have not received a response yet (48 hours ago).
Additional information: Please don't get me wrong, I really like VistaDB that in this case it no longer meets my requirements, which have recently started to preserve my reputation and support my clients.
Thank you very much in advance to share your knowledge of Sybase Sql Anywhere.
source to share
I hid the prices. Feel free to contact Sybase for more information
To distribute our software, you have two options:
- Buy through a regional distributor or
- Become a direct Sybase iAnywhere partner , annual costs - ////, -
For a BSA program, you get a lot of value, for example:
- Entering the Sybase Partner Labeling Machine.
- Free software for testing and development
- Free software updates
- Free partner phone support.
- Reselling Sybase iAnywhere Software Rights as Official Patner
BSA Option - OEM Once you are a BSA member, you have the option to distribute licenses under an OEM license. For example, OEM SQL Anywhere has a minimum pre-purchased Seats / Server license of 100 seats / server license cost ////, - (//, - per seat / server). This is a one-time fee for the OEM SQL Anywhere version. This version can only be used when using a BSA partner.
We supply one OEMCD which entitles the BSA partner to embed and distribute software
Attached enduser price list for licenses and support. As you can see, the minimum comapny license is a 5 user base package. If you distribute through an OEM license, you can distribute 1 seat / server if it is a standalone application.
If you are a BSA Sybase iAnywhere Reseller Partner, you get a discount on regular pricing
- 30% in the list of licenses
- 25% with support when the Partner makes the first line or
- 10% in the first year alone, when Sybase provides first support.
Let me insist that VistaDB has many qualities and I am just investigating to see if other products can offer more robust / robustness given the context in which my application is deployed.
Edit
VistaDB's support team was very honest and admitted that the db was corrupted. They provided me with guidance on how to prevent this and almost completely rebuilt the database I submitted (only one row was lost out of all the ones that seemed to be gone: I-am-relieved). I just wish I had to update this thread to make them fair (they spent 60+ hours to fix the DB).
source to share
Full disclosure: I'm working on Sybase in SQL Anywhere development.
Usage Scenario: Yes, SQL Anywhere will do exactly what you want. Your application can automatically start the server in the database you want when you try to connect, and the server will shutdown when disconnected. Database files can be copied between supported platforms, although there are usually two files to copy (a database file and a transaction log file). You can set up your database without a transaction log file so that you only have one file to copy, but both performance and recoverability will suffer.
Recoverable: SQL Anywhere is designed for fault tolerance and recovery from things like power outages. We take data corruption seriously and have test machines that run continuously and automatically cycle at random intervals to test recoverability.
I'm afraid I don't know much about licensing, but if you don't hear from the sale, please let me know and I'll see what I can do.
source to share