Is MS SQL 2005 in Visual Studio 2005 Professional Edition???

I am going to ask for discounts on Visual Studio 2005 while buying whole new computer. But I am being decision less on which version should I buy, and that version must also contain MS SQL 2005. plz help, thanks.

 

Hi,

All that stuff you can get for free. Microsoft is offering Visual Studio Express for free. You can get all of that, including MS SQL 2005 for free.

 

I don't want to have express edition. I want pro.

is ms sql 2005 bundled with vs.net pro?

 

I think there are different editions of the pro version, maybe look into the one for database professionals.

Whats up with using the free one ?

 

diff editions??? like?

 

like enterprise, and team suite and database professional, I use the free express editions and MS's site isnt very clear.

 

no its not.

lol why would it be?

 

SQL Server 2005 Express is bundled with Visual Studio 2005 Pro, but then again Express is a free download anyway.

While its not bundled as such, higher levels of Visual Studio come with MSDN subscriptions (Hense the cost of the software in the first place), Professional comes with the Professional MSDN sub, which contains the Developer edition of SQL Server 2005.

Personally though I've not found anything that SQL Server 2005 Express cant do, although I do have the standard SQL Server 2005 tools such as SQL Server Management Studio which makes life easier, although all my SQL is deployed to SQL Server 2005 Enterprise which is what all my production servers run.

http://msdn2.microsoft.com/en-us/vstudio/aa718657.aspx (Microsoft comparison chart of the different Visual Studio MSDN subscriptions)

Note all the software in the MSDN subscription is licenced for development use only, IE you cant use it for anything other than development and testing (Apart from Visual Studio itself of course).

Hope this helps

Jen

 

It cant export XML, Jenni...and a whole lot of other stuff. I think its got a 8 connection limit too......

 

Have to say I only use Express as a playground rather than a fully fledged development platform, but then again I have pretty much anything I want available to me (One of the benefits of working for a Gold Partner).

A rough guide to the different editions is here

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

While SQL Express isnt right for everyone and has several limitations I do know several people who just dismiss it out of hand.

Jen