Wednesday, March 28, 2012

MSDE 2000 which version to use?

Hi,
I'm planning to develop a VB.NET application using MSDE but came across
these sites... so I'm sort of confused which version of MSDE 2000 to use.
http://www.microsoft.com/downloads/d...displaylang=en
http://www.microsoft.com/downloads/d...displaylang=en
After checking the above two sites, please try to answer the following
questions:
1. What's the difference between these two MSDE 2000?
2. Which one to use for development? (VB.NET)
3. Which one to re-distribute with my custom application?
I was thinking that I have to use the 70MB MSDE file. BUT after comparing
the dates, I'm a bit confused. The 70MB file is older.
Thank you for you time.
Sukhdev.
hi Sukhdev,
"Sukhdev" <Sukhdev@.discussions.microsoft.com> ha scritto nel messaggio
news:73B0850D-01E3-41C3-83D5-CF1ED3DAE36B@.microsoft.com
> Hi,
> I'm planning to develop a VB.NET application using MSDE but came
> across these sites... so I'm sort of confused which version of MSDE
> 2000 to use.
>
http://www.microsoft.com/downloads/d...displaylang=en
>
http://www.microsoft.com/downloads/d...displaylang=en
> After checking the above two sites, please try to answer the following
> questions:
> 1. What's the difference between these two MSDE 2000?
the final result, after installation, is actually the same... both install
MSDE at the 3a service pack level..
but there's both a technical and an EULA difference..
MSDE Web Release A can only install fresh instances of MSDE 2000, while the
other package can both install new fresh instances and upgrad existing
instance at the service pack 3a level
as regard the EULA, the second package must be licensed by an appropriate
license of Visual Studio, Fox Pro, MSDN, SQL Server and so on, while MSDE
release A is really free for download, and you only have to register for
redistribution rights if you want to at
http://www.microsoft.com/sql/msde/ho...tregister.asp, but not for
use...

> 2. Which one to use for development? (VB.NET)
I strongly suggest to buy the Developer edition of SQL Server (about $50),
which includes all the server tools like Enterprise Manager, Query Analyzer,
Profiler and all the wizards like Index Tuning to troubleshoot development
issues...

> 3. Which one to re-distribute with my custom application?
chose the one you prefer... redistribution, in this case, is not a
problem...(as long as you are entitled for both)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

No comments:

Post a Comment