如何选择轻量版的数据库系统 [英] How to choose light version of database system

问题描述

我开始一个POS（销售点）项目。目标系统将写在C＃.NET 2 WinForms和作为主数据库服务器我们将使用MS-SQL Server。由于我们在一家商店的连锁店有很多POS设备，我喜欢在每个POS设备上有后端本地数据库系统。

I am starting one POS (Point of sale) project. Targeting system is going to be written in C# .NET 2 WinForms and as main database server We are going to use MS-SQL Server. As we have a lot of POS devices in chain for one store I will love to have backend local data base system on each POS device.

情况如下：当主服务器关闭时！ POS应用程序应该继续使用本地数据库脱​​机，直到连接到主服务器再次出现。

Scenario are following: When main server goes down!! POS application should continue working "off-line" with local database, until connection to main server come up again.

现在我处于困境，本地数据库将要最适合我。以下是帮助我指出正确方向的一些注意事项：

Now I am in dilemma which local database is going to be most adoptable for me. Here is some notes for helping me point me in right direction:

1. 轻松我的POS设备通常是古老的，


2. 免费我有很多设备，我不会在主SQL serer旁边支付额外费用


3. 一天不喜欢尝试所有在Mono和Linux操作系统上的端口。

这里是我到目前为止研究的：

Here is what I've researched so far:

1. 简单的XML轻但我害怕性能，我的主表项平均为10K记录


2. SQL-Express 我恐怕我的POS设备的SQLExpress硬件很差，也很难安装在每个设备上并配置


3. 不太知名 Advantage数据库服务器可以免费分发离线ADT系统。


4. DBF带有扩展库，尊重对于良好的旧DBF，但那个时代是在与我的剪辑和DBF


5. MS Access


6. Sqlite大多数现在，如何与MS SQL配对，它们具有相同的数据类型。

1. Simple XML "Light but I am afraid of performance, My main table of items is average of 10K records"
2. SQL-Express "I am afraid that my POS devices is poor with hardware for SQLExpress, and also hard to install on each device and configure"
3. Less known Advantage Database Server have free distribution of offline ADT system.
4. DBF with extended Library,"Respect for good old DBFs but that era is behind Me with clipper and DBFs"
5. MS Access
6. Sqlite "Mostly like for now, but I am afraid how it is going to pair with MS SQL do they have same Data types".

我知道在这个SO是很多主观数据，但至少可以有人推荐一些其他精简数据库系统，或者我最关注的事情之前我选择数据库。

I know that in this SO is a lot of subjective data, but at least can someone recommended some others lite database system, or things that I shod most take attention before I choice database.

推荐答案

SQL Server Compact

它是专为嵌入式设备（即Windows Mobile），但也可以在PC上运行。它是2MB，运行在进程中，单个数据库文件，可以有任何名称你喜欢。

It's designed for embedded devices (i.e. Windows Mobile), but can also run on PCs. It's 2MB, runs in-process, single database file, that can have whatever name you like.

它意味着一个本地高性能数据库。您无法远程连接到它，并且不支持存储过程或用户定义的函数。

Its meant as a local high-performance database. You can't connect to it remotely, and doesn't support stored procedures, or user-defined functions.

但是

选择有什么管理工具，当你长成一个简单，兼容，升级的路径。

Choose what have management tools, with an easy, compatible, upgrade path when you outgrow it.

这篇关于如何选择轻量版的数据库系统的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！