MS SQL Server 2005 Express Edition

[kress1963nov22]

I recently purchased a good MS book ("Build a Web Site Now") by Jim
Buyens. It has the Express Edition of MS-Visual Web Developer 2005 on
CD and also MS SQL Server 2005 Express Edition on the CD. A couple of
questions for this newbie: Can MS SQL Server 2005 Express Edition be
used in place of the older MSDE product for backend database work? I
also have Visual Studio .NET (VB) 2003 (Standard Edition). How
compatible are all these products and how should I approach using them?
I do strickly database work (nothing fancy). Can I use MS SQL Server
2005 Express Edition with Visual Studio .NET (VB) 2003? Can I start an
ASP.net project in the Express Edition of MS-Visual Web Developer 2005
and do any editing work on those pages later in my Visual Studio .NET
(VB) 2003? Thanks! Dav

 

[Shane Story]

SQL Express is great.

Just read up on the limitations. MSDE had limitations. SQL Express has
different ones. If they meet your needs, then go for it.

SQL Express does have GUI tools for managing. This is a real plus.

Neither is SQL Server, but they are free so what would you expect.

HTH,

Shane

 

[aaron.kempf]

I would expect offical SQL 2005 support in VS 2003 in the imminent
service pack for VS 2003.

this will add support for Vista; and I assume that SQL 2005 is a safe
bet.. since MSDE won't ever run on Vista.

You really might want to consider building things in SQL 2000 and then
deploying them in Staging and Produciton in SQL 2005... It's really
really not that hard; especially since SQL 2005 Express comes with the
SSMS tools.. like you were talking about

I mean; if the shoe fits-- wear it

-Aaron

PS - seriously the version of SQL Express you've got?? I would throw it
away; but first wait a couple of days for the SQL 2005 SP2 Express.

I like their new model.
I just wish that they would build a reasonable frontend for data entry
and reporting (like hmmm.. Access Data Projects maybe?)