When to use MSDE/Sql Server (when using VB.NET)

[DraguVaso]

Hi,

I'm just wondering when I better should use an Sql Server or when a MSDE.
Whet are the advantages of one to another en the limits etc. And this
espacially when using them as databases for VB.NET-applications.

Any information would be great!

Thanks a lot in advance,

Pieter

 

[Andrea Montanari]

hi Pieter,

Hi,

I'm just wondering when I better should use an Sql Server or when a
MSDE. Whet are the advantages of one to another en the limits etc.
And this espacially when using them as databases for
VB.NET-applications.

Any information would be great!

Thanks a lot in advance,

Pieter

you can start inspecting
http://www.microsoft.com/sql/evaluation/overview/default.asp and
http://www.microsoft.com/sql/msde/productinfo/default.asp ...
you can find there lot of info about differences among editions..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

 

[Miha Markic [MVP C#]]

Hi Dragu,

MSDE je Sql Server sa nekoliko limitacija (concurrent connections, database
size, nema client alata...) i je besplatan ako ga distribuira¹ pored
aplikacije uradene s MS alatom.

Toliko, na brzo

 

[Miha Markic [MVP C#]]

Hi again

(previous post was in wrong language :-S)
MSDE is basically a stripped down Sql Server (database size limit,
concurrent connections limitator, no client tools, etc), however MSDE is
free for distribution when it is distributed with an application build with
MS tools.

This is a very quick explanation

 

[Cor Ligthert]

Pieter,

(Do you speak Slowenian).

Beside the written shortcommings as you saw in the links from Martin,
misses MSDE as well things as intelligent search options. It is really a
very Basic SQL server.

Cor

 

[Robert Bouillon]

Use MSDE when you don't expect there to be more than 10 concurrent
connections, and if you don't need replication services.

--ROBERT

 

[DraguVaso]

Yes I know slowenian:
Holla ndrsz ijnr arem ensen! ;-)

Thanks!

 

[Cor Ligthert]

Yes I know slowenian:

Holla ndrsz ijnr arem ensen! ;-)

LOL

However I really was expecting it, my message was before Miha's reply you
know.

Cor