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

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
Thu Mar 10 09:28:53 CST 2005

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/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
Thu Mar 10 09:32:27 CST 2005

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" <pietercoucke@hotmail.com> wrote in message
news:u1X0phXJFHA.3752@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
Thu Mar 10 09:35:04 CST 2005

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" <pietercoucke@hotmail.com> wrote in message
news:u1X0phXJFHA.3752@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
Thu Mar 10 09:44:05 CST 2005

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
Thu Mar 10 11:57:38 CST 2005

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" <pietercoucke@hotmail.com> wrote in message
news:u1X0phXJFHA.3752@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
Tue Mar 15 07:37:40 CST 2005

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

Thanks! :-)

"Cor Ligthert" <notmyfirstname@planet.nl> wrote in message
news:%236551fYJFHA.3340@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
Tue Mar 15 08:22:02 CST 2005

> 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