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,
DraguVaso wrote:

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/evaluat...ew/default.asp and
http://www.microsoft.com/sql/msde/pr...fo/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#] - RightHand .NET consulting & development
www.rthand.com
SLODUG - Slovene Developer Users Group www.codezone-si.info
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:u1**************@TK2MSFTNGP14.phx.gbl...

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

[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 :-)

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
SLODUG - Slovene Developer Users Group www.codezone-si.info
"DraguVaso" <pi**********@hotmail.com> wrote in message
news:u1**************@TK2MSFTNGP14.phx.gbl...

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

[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" <pi**********@hotmail.com> wrote in message
news:u1**************@TK2MSFTNGP14.phx.gbl...

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

[DraguVaso]

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

Thanks! :-)

"Cor Ligthert" <no************@planet.nl> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

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

[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