SQL Express或MDB - 请提出意见 [英] SQL Express or MDB - opinions please

问题描述

好的，我一直很慢 - 而且自己慢慢地教自己VB.net


目前我已经通过代码创建了一个MDB文件，并向MDB添加了字段

文件代码。

我喜欢这个解决方案因为，（我假设）如果我创建一个EXE并且我加载了一个MDB文件，我可以

看看是否有某些字段，如果没有添加它们。

有点像一个嵌入EXE的更新，所以你不总是有

创建一个Install Shield。


所以......让我们说我的目标是拥有一个我希望别人安装的应用程序.b $ b b安装在某个地方。 br />
为什么选择SQL Express而不是简单的MDB文件？ （我从来没有尝试过SQL

Express）


1.正如我所假设的...... SQL express是第二次安装，用户将

必须安装我的

应用程序安装的顶部吗？


2. MDB文件更易于使用，因为到目前为止每个人都有

一直在使用

MDB文件，以便更容易获得所需的帮助？


3.人们告诉我MDB文件将慢慢地处理出来并且SQL

Express将取而代之。

这是真的吗？


所以如果你要从头开始编写应用程序。你还可以用SQL Express去购买
吗？


我在这上面来回摇头。并且想知道在我开始之前我将如何创建我的数据库

尝试编写应用程序。


谢谢，


Miro

Ok I have been slowely - and ever so slowely teaching myself VB.net

Currently I have created an MDB file by code, and added fields to the MDB
file by code.
I like this solution because, ( im assuming ) if I create an EXE and I load
an MDB file, I can
see if certain fields are there, and if not add them.
Kinda like an Update that is imbeded into the EXE, so you dont always have
to create an Install shield.

So... Lets say my goal is to have an application that I would like people to
install somewhere.
Why choose SQL Express over a simple MDB file? ( i have never tried SQL
Express )

1. As I am assuming...SQL express is a second install that a user would
have to install ontop of my
application install ?

2. MDB files would be easier to work with because everyone till now has
been working with
MDB files so any help required is easier to get to ?

3. People have told me MDB files will slowely be processed out and SQL
Express will take its place.
Is this true ?

So if you were to write an application from scratch. Would you still go
with SQL Express ?

I am knocking my head back and forth on this. And would like to know how i
will create my db''s before i start
trying to code an app.

Thank You,

Miro

推荐答案

Miro，


在新闻组中，一般和adonet都经常被问到。


在这里看到一个帖子，它会让你直接主菜更多，如果你

想要。

http://groups.google.com/group/micro...1eca691cf65511

我希望你能通过这次讨论得到一个想法。


Cor

" Miro" < MI ****** @ golden.net> schreef在bericht

新闻：eh ************** @ TK2MSFTNGP05.phx.gbl ...

Miro,

In the newsgroup general and adonet is this often asked.

See here one thread of those, it gives you direct the entree to more if you
want.

http://groups.google.com/group/micro...1eca691cf65511

I hope you get an idea by this discussion.

Cor
"Miro" <mi******@golden.net> schreef in bericht
news:eh**************@TK2MSFTNGP05.phx.gbl...

好的，我一直在慢慢地 - 并且慢慢地教自己VB.net

目前我已经通过代码创建了一个MDB文件，并通过代码将字段添加到MDB
文件中。
我喜欢这个解决方案因为，（我假设）如果我创建一个EXE并且我加载了一个MDB文件，我可以看看是否存在某些字段，如果没有添加它们。
有点像更新被嵌入到EXE中，所以你不必总是创建一个安装盾。

所以...让我们说我的目标是拥有一个我想要的应用程序
安装到某个地方。
为什么选择SQL Express而不是简单的MDB文件？ （我从未尝试过SQL
Express）

1.正如我所假设的...... SQL Express是第二次安装，用户必须安装在我的<应用程序安装？

2. MDB文件更易于使用，因为到目前为止每个人都在使用
MDB文件，所以任何需要的帮助都更容易获得到了什么？

3.人们告诉我MDB文件将被慢慢处理掉，SQL
Express将取代它。
这是真的吗？
所以如果你要从头开始编写应用程序。你还会继续使用SQL Express吗？

我正在敲打我的脑袋。并且想知道在我开始尝试编写应用程序之前我将如何创建我的数据库。

谢谢你，

Miro

Ok I have been slowely - and ever so slowely teaching myself VB.net

Currently I have created an MDB file by code, and added fields to the MDB
file by code.
I like this solution because, ( im assuming ) if I create an EXE and I
load an MDB file, I can
see if certain fields are there, and if not add them.
Kinda like an Update that is imbeded into the EXE, so you dont always have
to create an Install shield.

So... Lets say my goal is to have an application that I would like people
to install somewhere.
Why choose SQL Express over a simple MDB file? ( i have never tried SQL
Express )

1. As I am assuming...SQL express is a second install that a user would
have to install ontop of my
application install ?

2. MDB files would be easier to work with because everyone till now has
been working with
MDB files so any help required is easier to get to ?

3. People have told me MDB files will slowely be processed out and SQL
Express will take its place.
Is this true ?

So if you were to write an application from scratch. Would you still go
with SQL Express ?

I am knocking my head back and forth on this. And would like to know how
i will create my db''s before i start
trying to code an app.

Thank You,

Miro

谢谢Cor，


这就是我需要的。


对于每个想到同样事情的人来说都是一本很好的读物。


我个人现在会尝试安装SQL Server，看看会发生什么。

在这里，或者学习有多难:)


再次感谢你。


Miro


" Cor Ligthert [MVP]" <无************ @ planet.nl>在消息中写道

news：uy ************** @ TK2MSFTNGP04.phx.gbl ...

Thank you Cor,

That is what I needed.

A good read for everyone who is thinking the same thing.

I personally will try now to install SQL Server and see what happens from
here, or how hard it is to learn :)

Thank you again.

Miro

"Cor Ligthert [MVP]" <no************@planet.nl> wrote in message
news:uy**************@TK2MSFTNGP04.phx.gbl...

Miro，
在新闻组中，一般都会通常询问adonet。

请看这里的一个主题，如果你想要的话，它会让你直接进入主菜。

http://groups.google.com/group/micro...1eca691cf65511

我希望你能通过这次讨论得到一个想法。

Cor

" Miro" < MI ****** @ golden.net> schreef in bericht
新闻：eh ************** @ TK2MSFTNGP05.phx.gbl ...

Miro,

In the newsgroup general and adonet is this often asked.

See here one thread of those, it gives you direct the entree to more if
you want.

http://groups.google.com/group/micro...1eca691cf65511

I hope you get an idea by this discussion.

Cor
"Miro" <mi******@golden.net> schreef in bericht
news:eh**************@TK2MSFTNGP05.phx.gbl...

好的我一直很慢 - 而且一直如此慢慢地教自己VB.net

目前我已经通过代码创建了一个MDB文件，并通过代码在MDB
文件中添加了字段。
我喜欢这个解决方案因为，（即时通讯）假设）如果我创建了一个EXE并且我加载了一个MDB文件，我可以看看是否存在某些字段，如果没有添加它们。
有点像一个嵌入到的更新EXE，所以你不必总是创建一个安装盾。

所以...让我们说我的目标是有一个应用程序，我希望人们
安装在某个地方。
为什么选择SQL Express而不是简单的MDB文件？ （我从未尝试过SQL
Express）

1.正如我所假设的...... SQL Express是第二次安装，用户必须安装在我的<应用程序安装？

2. MDB文件更易于使用，因为到目前为止每个人都在使用
MDB文件，所以任何需要的帮助都更容易获得到了什么？

3.人们告诉我MDB文件将被慢慢处理掉，SQL
Express将取代它。
这是真的吗？
所以如果你要从头开始编写应用程序。你还会继续使用SQL Express吗？

我正在敲打我的脑袋。并且想知道在我开始尝试编写应用程序之前我将如何创建我的数据库。

谢谢你，

Miro

Ok I have been slowely - and ever so slowely teaching myself VB.net

Currently I have created an MDB file by code, and added fields to the MDB
file by code.
I like this solution because, ( im assuming ) if I create an EXE and I
load an MDB file, I can
see if certain fields are there, and if not add them.
Kinda like an Update that is imbeded into the EXE, so you dont always
have to create an Install shield.

So... Lets say my goal is to have an application that I would like people
to install somewhere.
Why choose SQL Express over a simple MDB file? ( i have never tried SQL
Express )

1. As I am assuming...SQL express is a second install that a user would
have to install ontop of my
application install ?

2. MDB files would be easier to work with because everyone till now has
been working with
MDB files so any help required is easier to get to ?

3. People have told me MDB files will slowely be processed out and SQL
Express will take its place.
Is this true ?

So if you were to write an application from scratch. Would you still go
with SQL Express ?

I am knocking my head back and forth on this. And would like to know how
i will create my db''s before i start
trying to code an app.

Thank You,

Miro

> 1.正如我所假设的...... SQL express是第二次安装，用户将

> 1. As I am assuming...SQL express is a second install that a user would

安装在我的
应用程序安装的ontop上？


很多人现在有一个sql express或MSDE实例运行

甚至不知道它

2. MDB文件会更容易使用，因为到目前为止每个人都在使用
MDB文件，所以任何需要的帮助都更容易获得？


如果你确定所有人都安装了Jet oledb（从2.6版开始，这不是

标准的MDAC）

好吧安装办公室也可以工作:-)

3.人们告诉我MDB文件将被慢慢处理掉，SQL
Express将取而代之。
这是真的吗？


在我看来是的，你也可以去火鸟数据库引擎，它有很好的.Net API是完全免费的（没有任何限制，并且

甚至有嵌入版本） http://firebird.sourceforge.net / 然而

它不是友好的从MSSQL开始


所以如果你要从头开始编写应用程序。你还会和SQL Express一起去吗？


这取决于我的项目。


为什么我会选择Access（我更喜欢2000 db）以上sql express

1.小（我应该说更小）足迹

2.可以支持所有Windows版本赢得9.x

3.安全然后我的意思除了

之外没有其他人可以获得安全的可能性你可以访问数据库

，同时仍然可以使用数据上的索引等等（

这是通过工作组信息文件完成的，使用这种技术你可以添加用户角色并加密数据库。


我认为最好的数据库就在这一刻是MS SQL

2005（SQL Express）只是遗憾的是他们忘记了系统的一个

管理员应该被限制访问来自某个数据库中某个数据库的数据库


希望给你一些想法


reg ards


Michel Posseth [MCP]


" Miro" < MI ****** @ golden.net> schreef在bericht

新闻：呃************** @ TK2MSFTNGP05.phx.gbl ...好的我一直很慢 - 而且自己慢慢地教自己VB .net

目前我已经通过代码创建了一个MDB文件，并通过代码将字段添加到MDB
文件中。
我喜欢这个解决方案因为，（我假设）如果我创建一个EXE，然后我加载一个MDB文件，我可以看看是否存在某些字段，如果没有添加它们。
有点像一个嵌入EXE的更新，所以你并不总是有
来创建一个安装盾。

所以...让我们说我的目标是有一个我希望人们安装的应用程序安装在某个地方。
为什么选择SQL Express而不是简单的MDB文件？ （我从未尝试过SQL
Express）

1.正如我所假设的...... SQL Express是第二次安装，用户必须安装在我的<应用程序安装？

2. MDB文件更易于使用，因为到目前为止每个人都在使用
MDB文件，所以任何需要的帮助都更容易获得到了什么？

3.人们告诉我MDB文件将被慢慢处理掉，SQL
Express将取代它。
这是真的吗？
所以如果你要从头开始编写应用程序。你还会继续使用SQL Express吗？

我正在敲打我的脑袋。并且想知道在我开始尝试编写应用程序之前我将如何创建我的数据库。

谢谢你，

Miro

have to install ontop of my
application install ?
well a lot of people nowadays have a sql express or MSDE instance running
without even knowing it
2. MDB files would be easier to work with because everyone till now has
been working with
MDB files so any help required is easier to get to ?
if you know for sure all people have Jet oledb installed ( this is not
standard annymore in MDAC since version 2.6 )
okay having office installed will also work :-)
3. People have told me MDB files will slowely be processed out and SQL
Express will take its place.
Is this true ?
In my opinion yes , you could also go for the firebird DB engine wich has
a verry nice .Net API is completely free ( without anny restrictions , and
has even an embedded version ) http://firebird.sourceforge.net/ however
it is not as "friendly" to start with as MSSQL

So if you were to write an application from scratch. Would you still go
with SQL Express ?
This depends on the project for me .

Why would i choose Access ( i prefer the 2000 db ) above sql express
1. small ( i should say smaller ) footprint
2.deployable to all Windows versions inclusive win 9.x
3. security and then i mean the possibility to secure so no one else except
you can access the database
while still having the posibility to use indexes etc etc on the data (
this is done with a workgroup information file , using this technique you
can add user roles and encrypt the database )

by the way i believe the best database there is at this moment is MS SQL
2005 ( SQL Express ) it is only a shame that they forgot that even a
administrator of a system should be restricted access from a db from a
programmers point of view in some situations

Hope to have given you some ideas

regards

Michel Posseth [MCP]

"Miro" <mi******@golden.net> schreef in bericht
news:eh**************@TK2MSFTNGP05.phx.gbl... Ok I have been slowely - and ever so slowely teaching myself VB.net

Currently I have created an MDB file by code, and added fields to the MDB
file by code.
I like this solution because, ( im assuming ) if I create an EXE and I
load an MDB file, I can
see if certain fields are there, and if not add them.
Kinda like an Update that is imbeded into the EXE, so you dont always have
to create an Install shield.

So... Lets say my goal is to have an application that I would like people
to install somewhere.
Why choose SQL Express over a simple MDB file? ( i have never tried SQL
Express )

1. As I am assuming...SQL express is a second install that a user would
have to install ontop of my
application install ?

2. MDB files would be easier to work with because everyone till now has
been working with
MDB files so any help required is easier to get to ?

3. People have told me MDB files will slowely be processed out and SQL
Express will take its place.
Is this true ?

So if you were to write an application from scratch. Would you still go
with SQL Express ?

I am knocking my head back and forth on this. And would like to know how
i will create my db''s before i start
trying to code an app.

Thank You,

Miro

这篇关于SQL Express或MDB - 请提出意见的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！