By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,165 Members | 1,089 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,165 IT Pros & Developers. It's quick & easy.

MS SQL Server 2005 Express Edition

P: n/a
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

Dec 12 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
<kr************@yahoo.comwrote in message
news:11**********************@j72g2000cwa.googlegr oups.com...
>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

Dec 12 '06 #2

P: n/a
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?)

kr************@yahoo.com wrote:
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
Dec 12 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.