更新时间:2023-02-06 22:48:10
我当然愿意(并且愿意).SQL Compact (SQLCE) 在某些情况下具有明显的优势.现在它绝不意味着要替代 SQL Server.它不能扩展,不能运行数千个并发连接,也不能用于报告服务等.
I certainly would (and do). SQL Compact (SQLCE) has a distinct advantage in some scenarios. Now it's in no way meant to be a replacement for SQL Server. It doesn't scale, it isn't made to run thousands of concurrent connections, it's not designed for reporting services, etc, etc.
但它有一个微小的足迹.安装只是复制 DLL 的问题.备份它是一个简单的文件副本.如果您使用 table direct 或 BCP,它的存储和检索速度可能会很快.哦,它是免费的.如果您只需要一个应用程序的本地数据存储,那么部署和配置 SQL Server 会很麻烦.SQLCE 很简单.此外,它可以在与完整 SQL Server 相同的沙箱中作为复制订阅者运行(大多数其他小型数据库不能).
But it has a tiny footprint. Installing is a matter of just copying over DLLs. Backing it up is a simple file copy. And it can be wicked fast for storage and retrieval if you're using table direct or BCP. Oh, and it's free. If you just need a local data store for an app, SQL Server is a pain to deploy and configure. SQLCE is simple. Plus it can play in the same sandbox as a full SQL Server as a replication subscriber (which most other small DBs can't).
忘记回答您的具体问题:
Forgot to answer your specific questions: