Visual Web Developer 2005 Express -- with SQL Server Developer 2005?

[KeithGarrett]

Can someone here confirm or deny that Visual Web Developer 2005 <u>Express</u> Edition doesn't work with SQL Server <u>Developer</u> Edition 2005?

I was about to order SQL Server Developer Edition 2005 on Amazon, to use with Visual Web Developer 2005 Express, when I read a user comment that the two are incompatible with each other. Does anyone know for sure if that is true?

What I'm wanting to do is develop an ASP.NET web application here using a SQL Server database. I use VS2003 and SQL Server Enterprise 2000 at work, but I'd like to learn the 2005 editions for this side project. I don't own any of the developer tools/IDEs personally, so I'm trying to find the most affordable way to do this for my home business.

Thanks for any advice,
Keith

[bruce]

I think they will work with each other without problem.

Basically, the SQL management tool w/ VS.nET is just a basic Frontend tool to connect to any SQL DB. You can even connect to SQL 2000.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[KeithGarrett]

Hi, Bruce. I'm not sure what you mean by the SQL management tool w/ VS.NET. Is this in Visual Studio Web Developer Express 2005? Or is that something in some version of SQL Server 2005?

I have VS web developer express installed, but don't have any version of SQL Server yet.

[Aristotle]

I think what Bruce meant by the SQL management tool in Visual Studio is the Server Explorer feature. It allows you to connect to SQL 2005 and SQL 2005 Express databases. Although, this is a limited tool as with any free versions that Microsoft provides, such that you can't create tables for example.

The SQL Server Developer Edition 2005 will come with a full version of SQL Server Management Studio, which will allow you to also connect to SQL 2005 and SQL 2005 Express, and you'll be able to do everything with your database.

Aristotle

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)