且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

应该使用firebird,SQL Server Compact Edition还是SQL Server数据库?

更新时间:2023-02-06 08:23:59

这不是真正的比较:他们并不是都做同样的事情。

FireBird和SQL Server都是数据库服务器系统:它们接受请求和提供信息,同时充当实际磁盘存储和使用数据库的应用程序之间的接口。 SQLCE不是 - 它直接访问文件。



这样做的区别在于Firebird和SQL Server都可以在多用户环境中使用:SQLCE不是因为只有一个应用程序(甚至线程)可以一次访问数据库 - 它严格来说是单个用户。



Firebird和SQL服务器具有可比性,之前已经完成了 - 谷歌会找到你很多,但这里有一个: http ://database-management-systems.findthebest.com/compare/13-26/Firebird-vs-Microsoft-SQL-Server [ ^ ]
That's not really a comparison: they don't all do the same thing.
FireBird and SQL Server are both Database server systems: they accept requests and supply information while acting as an interface between the actual disk storage and the application using the database. SQLCE isn't - it access the file directly.

The difference this makes is that Firebird and SQL Server are both usable in multiuser environments: SQLCE isn't because only one application (or even thread) can access the database at a time - it is strictly single user.

Firebird and SQL server are comparable and this has been done before - Google will find you quite a few, but here is one: http://database-management-systems.findthebest.com/compare/13-26/Firebird-vs-Microsoft-SQL-Server[^]