从 SQL Server 迁移到 firebird：优点和缺点
我考虑迁移有 4 个原因：
1）SQLSERVER 安装是一场噩梦，特别是对于 1 用户软件（即使通常我有 3-20 个用户，有时我将我的软件出售给单个用户：安装时遇到麻烦真是难以置信数据库，安装应用程序时意味着复制 exe...）。 （请注意，我的最大安装数量是 100 个用户，但没有上限）。软件安装需要 10 秒，SQLServer 安装需要 1 小时。 Firebird的安装要容易得多。
2) SQLSERVER 仅在 Windows 服务器上运行
3) 我的客户拥有所有 Express 版本
4) 我没有使用任何高级功能，我现在开始使用 filestream，但主要原因是 Express 版本有 4/10GB 数据库大小因此
，这些都是迁移到 Firebird 的优点。
有哪些缺点？
我也可以计划支持这两个平台，但我担心这会适得其反。
I am considering the migration for 4 reasons:
1) SQLSERVER installation is a nightmare, expecially for 1-user software (Even if typically I have 3-20 users, sometimes I sell my software to single users: it is incredible to have troubles installing the DB, while installing the applicatino means copying an exe...). (note my max installation is 100 users, but there is no an upper limit). Software installs in 10 seconds, SQLServer in 1 hour. Firebird installation is much easier.
2) SQLSERVER runs on windows server only
3) My customers have all the express edition
4) i am not using any advanced feature, I am now starting using filestream, but the main reason for this is that Express edition has 4/10GB db size limit
So these are all Pros of moving to Firebird.
Which are the cons?
I can also plan to support both platforms, but this will backfire I fear.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
MSSQL 服务器针对大型数据库和复杂查询进行了更快、更好的优化，特别是在管理得当的情况下，而 Firebird 允许您在没有任何管理的情况下运行，然后忘记它。尽管这种惩罚影响了很少比例的使用它的人，但在完成迁移之前，我建议您首先迁移数据，然后测试两个系统上最复杂查询的速度。如果速度令您满意，那么您就可以开始了。
MSSQL server is faster and better optimized for large databases and complex queries, especially if administered properly, while Firebird alows you to run without any administration and just forget about it. Although this penalty affects very small percentage of people using it, before complete migration I suggest you to first just migrate data and then test speed of most complex query on both systems. If speed satisfies you then you are good to go.
除了需要彻底测试所有现有代码的兼容性问题之外，我没有看到任何其他要求。
I don't see any besides need to thoroughly test all of your existing code for compatability issues.
Firebird 非常适合服务器安装或单用户安装。
它有一个适合单用户场景的嵌入式版本，您无需安装任何东西。
它对服务器和嵌入式数据库使用相同的数据库文件，因此您可以轻松地从单用户转到多用户，反之亦然。
Firebird is wonderful for server installations or single user installations.
It has an embedded version that is suitable for single user scenarios and you do not have to install anything.
It uses the same database file for both server and embedded database so you can easy go from single user to multi user and vice versa.
我今天在我的免费软件中嵌入了 Firebird 2.5。太棒了，从来没有出现过连接问题。我使用多个进程同时执行插入和读取长操作，并且一切都按预期正确进行。我正在等待火鸟3.0。当您不想信任其他商业数据库软件时，我推荐 Firebird。
I have embedded Firebird 2.5 today in my freeware Software. It's great, and there had never been connection problems. I used multiple processes to do both insert and read long operations simultaneously and it all gone correct as was expected. I am waiting for Firebird 3.0. I recommend Firebird when you don't want to trust on other commercial database software.
如果只有一个用户，您可以使用 Sqlite，它比 Firebird 更容易管理。
If there is only one user you can use Sqlite which is even easier to manage than Firebird.