选择一个完美的数据库 [英] Selecting a Perfect Database

问题描述

您好，专家，

我一直在研究差异.一段时间以来的数据库.我的软件是在VB.Net中开发的，后端为MS-Access.在这种情况下，我的模块很少，工作很少，甚至客户也很少.因此，我从来没有选择过原子性，而Oracle MS-Sql所提供和提供的其他功能则没有.我选择了适合我的MS-Access，因为我可以使用MS Jet Ole Db dll免费分发它.对吧?

但是现在，由于模块增加了，因此软件的工作也得到了增强.因此，我必须考虑使用某些Sql Server，Sql Lite或oracle.因此，我正在提高技术水平.

您能建议我什么是对我可用的最佳数据库选择吗?如果我喜欢散发它，那就不用紧张了.我应该采用什么.

我知道已经以访问格式创建了一些数据集或查询，例如在查询中使用iif，而很少有人这样做.我还需要更改它们.

基本上有两个问题:

1.什么对我来说最合适的数据库(我喜欢在流程中具有原子性和sql命令)Free将具有优先级?而且我不希望有人看到我的数据库结构，因为它的设计巧妙而又没有在这个行业中找到?

2.我不会完全迁移软件，我只会将新型数据库提供给那些拥有大型数据库或从我那里购买更多模块的人?我应该分开两个数据库的代码吗?

请尽快给我建议.

致以最诚挚的问候

Jay Khatri

Hi Experts,

I''ve been working on diff. kind of databases from some time. My software is developed in VB.Net with backend as MS-Access. This was the scenario when I had few modules and very little job and even little client. So I never opted for Atomicity and other facilities that Oracle MS-Sql give and access don''t. I selected MS-Access suitable for me as I can distribute it free with MS Jet Ole Db dll. Right ?

But Now since modules are getting increased, working on the software is being enhanced. So I have to think for some Sql Server, Sql Lite or may be oracle. So I am on the stage to enhance the tech.

Can you suggest me what will be the best option of Databases available for me ? If I like to distribute it tension free. What I should adopt.

I know several datasets or queries have been created in access format like using iif in query and few like that. I have also need to change them.

There are basically two questions:

1. What will the best suitable database for me (I like to have atomicity and sql command in a flow) Free will have a priority ? and I dont like someone to see my database structure as it is designed cleverly and not being found in this industry yet?

2. I will not migrate the software entirely, I will give new kind of database only to those who have big database or purchasing more modules from me ? Should I separate the code for both the databases ?

Please suggest me asap.

Thanks & Best Regards

Jay Khatri

推荐答案

SQL Server Express可以为您工作，但必须将其安装在计算机或服务器上，以供人们使用.另一个micrsoft选项是SQL Compact Edition.它很像Access，因为它是一个文件，但是给它和它使用的命令提供了更多的SQL Server感觉.这两个都是免费的. CE的问题是您不能具有存储过程，但是大多数其他所有内容都与SQL Server相同.

Express和CE都可以处理多达4G的数据，而最新的SQL Express 2008 R2可以免费处理10G的所有数据.

SQL Server Express would work for you, but that has to be installed on the machine or a server for people to use. Another micrsoft option would be SQL Compact Edition. It is alot like Access because it is a single file, but gives more of a SQL Server feel for it and the commands it uses. Both of these are free. CE has the issue that you cannot have stored procedures but most everything else is the same as SQL Server.

Both Express and CE can handle up to 4G of data and the newest SQL Express 2008 R2 can handle 10G all for free.

非常感谢您，我完全同意您的建议.

你还能回答我的第二个问题吗?

致以最诚挚的问候

Jay Khatri

Thank you very much steve, I am fully agree with ur suggestion.

Can you answer my second question also.

Thanks & Best Regards

Jay Khatri

，如果sql server Express版本是免费的，那为什么还要坚持使用.我应该完全离开访问权限吗?

致以最诚挚的问候

杰伊·哈特里(Jay Khatri)

and if sql server express edition is free then why to stick with access. Should I leave access entirely.

Thanks & Best Regards

Jay Khatri

这篇关于选择一个完美的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！