Sql Server 2005 & Visual Studio.Net

16 Apr 2007 3:54 PM

Uday

Pardon me, if this is not the right group to post.....

We are planning to buy Sql Server 2005 for our new project. Recently, I
realized that it comes with Visual Studio.Net also.

So my questions is, if we are planning to build web application in .Net
could we use this or do we need to buy a different Visual Studio.Net all
together.

thanks,
_Uday

16 Apr 2007 4:24 PM

John Bell

Hi Uday

Show quoteHide quote

"Uday" wrote:

> Pardon me, if this is not the right group to post.....
>
> We are planning to buy Sql Server 2005 for our new project. Recently, I
> realized that it comes with Visual Studio.Net also.
>
> So my questions is, if we are planning to build web application in .Net
> could we use this or do we need to buy a different Visual Studio.Net all
> together.
>
> thanks,
> _Uday
>

Visual Studio will come with the SQL Express version, if this version
satisfies all of your requirements then you could use it!

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

John

16 Apr 2007 4:32 PM

Uday

Thanks John.

At this point I don't have all the info about web-application we are going
to build.

All I know is, its going to be in ASP.Net and with SQL Server 2005 for
database.

This is what I understand from your comment:

If I the Visual studio.Net that comes with Sql Server Express is enough to
build a ASP.Net web application, then its highly likely that the Studio.Net
that comes with a Standard version of Sql Server would be good as well.

thanks again John,
_Uday

16 Apr 2007 4:56 PM

John Bell

Hi

Show quoteHide quote

"Uday" wrote:

> Thanks John.
>
> At this point I don't have all the info about web-application we are going
> to build.
>
> All I know is, its going to be in ASP.Net and with SQL Server 2005 for
> database.
>
> This is what I understand from your comment:
>
> If I the Visual studio.Net that comes with Sql Server Express is enough to
> build a ASP.Net web application, then its highly likely that the Studio.Net
> that comes with a Standard version of Sql Server would be good as well.
>
> thanks again John,
> _Uday

I did assume that you are using Visual Studio 2005 and not the earlier
version which may have include MSDE which is SQL 2000 and does not have all
the features of SQL Express.

Visual Studio does not come with SQL Server Standard as Tibor has explained.
If you want SQL Server Standard then you would need to purchase it separately.

John

16 Apr 2007 4:35 PM

Tibor Karaszi

> We are planning to buy Sql Server 2005 for our new project. Recently, I
> realized that it comes with Visual Studio.Net also.

That was news to me. Can you point me to a site describing this?

The VS ide is included with SQL Server, but that is only so you can create SSIS, RS and AS types of
projects. You can't create, say, C# apps with the VS that comes with SQL Server.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

Show quoteHide quote

"Uday" <U***@discussions.microsoft.com> wrote in message
news:821A191F-8C54-4359-82A7-F2B365D13E1B@microsoft.com...
> Pardon me, if this is not the right group to post.....
>
> We are planning to buy Sql Server 2005 for our new project. Recently, I
> realized that it comes with Visual Studio.Net also.
>
> So my questions is, if we are planning to build web application in .Net
> could we use this or do we need to buy a different Visual Studio.Net all
> together.
>
> thanks,
> _Uday
>

16 Apr 2007 4:50 PM

Uday

Thanks a lot Tibor.

I don't know what is possible with the VS that we get with SS2K5. That is
why I am asking this question. All I know is that a version of VS comes with
SS2K5.

You are probably right, why would Msoft give away VS that does C#,
ASP.Net... code along with SS2K5.

thanks for the info,
_Uday

Show quoteHide quote

"Tibor Karaszi" wrote:

> > We are planning to buy Sql Server 2005 for our new project. Recently, I
> > realized that it comes with Visual Studio.Net also.
>
> That was news to me. Can you point me to a site describing this?
>
> The VS ide is included with SQL Server, but that is only so you can create SSIS, RS and AS types of
> projects. You can't create, say, C# apps with the VS that comes with SQL Server.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
> "Uday" <U***@discussions.microsoft.com> wrote in message
> news:821A191F-8C54-4359-82A7-F2B365D13E1B@microsoft.com...
> > Pardon me, if this is not the right group to post.....
> >
> > We are planning to buy Sql Server 2005 for our new project. Recently, I
> > realized that it comes with Visual Studio.Net also.
> >
> > So my questions is, if we are planning to build web application in .Net
> > could we use this or do we need to buy a different Visual Studio.Net all
> > together.
> >
> > thanks,
> > _Uday
> >
>
>

16 Apr 2007 5:03 PM

Tibor Karaszi

> I don't know what is possible with the VS that we get with SS2K5.

What comes with SQL Server 2005 is only the VS *developer environment*, called "SQL Server Business
Intelligence Development Studio". This only allow you to create SSIS, RS and AS project types.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

Show quoteHide quote

"Uday" <U***@discussions.microsoft.com> wrote in message
news:A43C2E86-76C4-4FFA-9A77-A8E5A784E811@microsoft.com...
> Thanks a lot Tibor.
>
> I don't know what is possible with the VS that we get with SS2K5. That is
> why I am asking this question. All I know is that a version of VS comes with
> SS2K5.
>
> You are probably right, why would Msoft give away VS that does C#,
> ASP.Net... code along with SS2K5.
>
> thanks for the info,
> _Uday
>
>
>
> "Tibor Karaszi" wrote:
>
>> > We are planning to buy Sql Server 2005 for our new project. Recently, I
>> > realized that it comes with Visual Studio.Net also.
>>
>> That was news to me. Can you point me to a site describing this?
>>
>> The VS ide is included with SQL Server, but that is only so you can create SSIS, RS and AS types
>> of
>> projects. You can't create, say, C# apps with the VS that comes with SQL Server.
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>>
>> "Uday" <U***@discussions.microsoft.com> wrote in message
>> news:821A191F-8C54-4359-82A7-F2B365D13E1B@microsoft.com...
>> > Pardon me, if this is not the right group to post.....
>> >
>> > We are planning to buy Sql Server 2005 for our new project. Recently, I
>> > realized that it comes with Visual Studio.Net also.
>> >
>> > So my questions is, if we are planning to build web application in .Net
>> > could we use this or do we need to buy a different Visual Studio.Net all
>> > together.
>> >
>> > thanks,
>> > _Uday
>> >
>>
>>

16 Apr 2007 5:30 PM

Uday

Thanks to you both Tibor and John.

It all makes more sense to me now.

_Uday

Show quoteHide quote

"Tibor Karaszi" wrote:

> > I don't know what is possible with the VS that we get with SS2K5.
>
> What comes with SQL Server 2005 is only the VS *developer environment*, called "SQL Server Business
> Intelligence Development Studio". This only allow you to create SSIS, RS and AS project types.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
> "Uday" <U***@discussions.microsoft.com> wrote in message
> news:A43C2E86-76C4-4FFA-9A77-A8E5A784E811@microsoft.com...
> > Thanks a lot Tibor.
> >
> > I don't know what is possible with the VS that we get with SS2K5. That is
> > why I am asking this question. All I know is that a version of VS comes with
> > SS2K5.
> >
> > You are probably right, why would Msoft give away VS that does C#,
> > ASP.Net... code along with SS2K5.
> >
> > thanks for the info,
> > _Uday
> >
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> > We are planning to buy Sql Server 2005 for our new project. Recently, I
> >> > realized that it comes with Visual Studio.Net also.
> >>
> >> That was news to me. Can you point me to a site describing this?
> >>
> >> The VS ide is included with SQL Server, but that is only so you can create SSIS, RS and AS types
> >> of
> >> projects. You can't create, say, C# apps with the VS that comes with SQL Server.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://sqlblog.com/blogs/tibor_karaszi
> >>
> >>
> >> "Uday" <U***@discussions.microsoft.com> wrote in message
> >> news:821A191F-8C54-4359-82A7-F2B365D13E1B@microsoft.com...
> >> > Pardon me, if this is not the right group to post.....
> >> >
> >> > We are planning to buy Sql Server 2005 for our new project. Recently, I
> >> > realized that it comes with Visual Studio.Net also.
> >> >
> >> > So my questions is, if we are planning to build web application in .Net
> >> > could we use this or do we need to buy a different Visual Studio.Net all
> >> > together.
> >> >
> >> > thanks,
> >> > _Uday
> >> >
> >>
> >>
>
>

16 Apr 2007 5:32 PM

Uday

Thanks to you both Tibor and John.

It all makes more sense to me now.

_Uday

Thread options