Sybase Sql Anywhere 能否像 VistaDB（或 MSAccess）一样部署？
上下文： 我当前的项目使用 VistaDB，因为它确实适合主要场景：用户登录应用程序，选择数据库（HDD 或网络驱动器上的文件），完成工作，然后注销。 DB（单个文件）可以复制（电子邮件、USB 加密狗、CD ...）并传输给同事或总部。而且，最重要的是，数据库是免版税的！
不好的部分是数据库需要频繁维护，以防止文件膨胀，因为文件变得非常大且缓慢，但更糟糕的是数据损坏。我的客户大多位于第三世界国家，那里每天都会发生几次电力短缺，他们不可能每天备份 10 个数据，我也不能强迫他们购买 UPS（尽管如此，我还是推荐了）。
这些客户似乎不明白他们失去了数据库，因为他们没有遵循我的建议...在某种程度上我同意他们的观点..我应该选择一个容错数据库来开始..
问题： Sql Anywhere 可以解决这个问题吗？我的意思是适合使用场景并具有足够的抗故障能力，以防止计算机意外关闭时数据损坏？
如果您是 Sybase 专家，正在阅读本文，您能告诉我我需要购买哪种许可证以及我的每个客户需要购买哪种许可证吗？我已经给 Sybase 的销售部门发了电子邮件，但还没有收到任何回复（48 小时前）。
其他信息： 请不要误会我的意思，我真的很喜欢 VistaDB，只是在这种情况下它不再符合我的要求，而我的要求最近变成了为了维护我的声誉并留住我的客户。
非常感谢提前分享您的 Sybase Sql Anywhere 知识。
The context :
My current project uses VistaDB as it really fits the main scenario: the user log into the application, selects the DB (file on HDD or Network drive), does his job, then logs off. The DB (a single file) can be copied (email, usb dongle, cd ...) and transfered to colleagues or to the headquarters. And, best of all, the DB is royalty free !
The bad part is that the DB needs frequent maintenance, to prevent file bloat, because the files become really large and slow, but the worse part is data corruption. My clients are mostly located in 3rd world countries where power shortages occur several times per day, they can't be making 10 data backups a day and I can't force them to buy UPS's (I recommended it nonetheless).
These clients don't seem to understand that they lost their DB because they weren't following my advices... to some extent I agree with them.. I should have chosen a fault tolerant db to start with..
The question :
Would Sql Anywhere do the trick? I mean fit the usage scenario and be fault resistant enough as to prevent data corruption on unexpected computer shutdowns?
If you are a Sybase Savvy reading this, could you tell what kind of license I would need to purchase and what kind of license would each of my customers need to purchase? I have already emailed Sybase's sales department but haven't received any reply yet (48h ago).
Additional information :
Please don't get me wrong, I really like VistaDB it's just that in this case it doesn't fit my requirements anymore which have recently became to preserve my reputation and to keep my customers.
Many thanks in advance for sharing your knowledge of Sybase Sql Anywhere.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
全面披露：我在 Sybase 从事 SQL Anywhere 工程工作。
使用场景： 是的，SQL Anywhere 会完全满足您的需求。当您尝试连接时，您的应用程序可以自动启动所需数据库上的服务器，并且当您断开连接时该服务器将关闭。可以在支持的平台之间复制数据库文件，但通常需要复制两个文件（数据库文件和事务日志文件）。您可以在没有事务日志文件的情况下设置数据库，这样您只需复制一个文件，但性能和可恢复性都会受到影响。
可恢复性：SQL Anywhere 设计为具有容错能力并可从电源故障等情况中恢复。我们非常重视数据损坏，并拥有连续运行的测试机器，并以随机时间间隔自动重新启动电源以测试可恢复性。
恐怕我对许可不太了解，但如果您没有收到销售的回复，请告诉我，我会看看我能做些什么。
Full disclosure: I work for Sybase in SQL Anywhere engineering.
Usage scenario: Yes, SQL Anywhere will do exactly what you want. Your application can auto-start a server on the database you want when you attempt to connect, and the server will shut down when you disconnect. Database files can be copied between supported platforms, though there are usually two files to copy (database file and transaction log file). You can set your database up without a transaction log file so that you only have one file to copy, but both performance and recoverability will suffer.
Recoverability: SQL Anywhere is designed to be fault tolerant and recover from things like power failures. We take data corruption very seriously and have test machines that run continually and are automatically power-cycled at random time intervals to test recoverability.
I'm afraid I don't know much about licensing but if you don't hear back from sales, let me know and I'll see what I can do.
我隐藏了价格。请随时联系 Sybase 了解更多信息
要分发我们的软件，您有两种选择：
对于 BSA 计划，您可以获得很多价值，例如：
BSA - OEM 选项
成为 BSA 成员后，您可以选择根据 OEM 许可证分发许可证。
例如，OEM SQL Anywhere 预购席位/服务器许可证的最低数量为 100 个席位/服务器许可证成本 ////,-- （ //,-- 每个席位/服务器）。这是 OEM SQL Anywhere 版本的一次性费用。该版本只能在BSA合作伙伴的申请下使用。
我们提供一张 OEMCD，授权 BSA 合作伙伴嵌入和分发软件。
附件是许可证和支持的最终用户价目表。
正如您所看到的，每个公司的最低许可证是 5 个用户的基础包。如果您通过 OEM 许可证进行分发（如果这是独立应用程序），则可以分发 1 个席位/服务器。
常规定价的折扣；
让我坚持认为 VistaDB 有很多品质，我只是在调查其他产品是否可以提供更多品质考虑到部署我的应用程序的环境的稳健性/可靠性。
编辑
VistaDB 支持团队非常诚实，承认数据库已损坏。他们为我提供了如何防止这种情况的指导，并且几乎完全恢复了我提交的数据库（在所有似乎已经消失的数据库中，只有 1 行丢失了：我松了一口气）。我只是觉得我必须更新这个线程才能公正地对待他们（他们花了60小时+来修复数据库）。
I have hidden the prices. Feel free to contact Sybase for more information
To distribute our software you have two options:
For the BSA Programm you recieve a lot of value, for example:
BSA - OEM option
After you are a BSA member you have the option to distribute licenses under an OEM license.
For example OEM SQL Anywhere minimum amount of pre-purchased Seats/Server license of 100 seats/server license cost ////,-- ( //,-- per seat/Server ) . This is a one time fee for a OEM SQL Anywhere version. This version can only be used under the application of the BSA partner.
We ship one OEMCD which entitles the BSA partner to embed and distribute the software
Attached is the enduser pricelist for the licences and support.
As you can see the minimum license per comapny is a 5-user base package. If you distributute via the OEM license you can distribute 1 seat/server if this is a standalone application.
If you are a BSA - reseller partner of Sybase iAnywhere you get a discount on the regular pricing of
Let me insist that VistaDB has a lot of qualities and I am just investigating to see if other products can offer more robustness/reliability given the environments in which my application is being deployed.
Edit
The VistaDB support team has been very honest and has admited the db was corrupted. They have provided me with guidance on how to prevent this and have almost completely restored a database i had submited (only 1 row was lost out of all those that seemed to have disappeared : I-am-relieved). I just felt like I had to update this thread to do them justice (them have spent 60hours+ to fix the DB).