2005 Express with VS 2003?

I am in the happy position of starting a new project from scratch. I have
only VS 2003, do not want to dabble in VS 2005 Beta yet, but am keen to plan
for using SQL Server Express 2005, which would be delivered to the (small)
customer.
Can I use 2005 Express with VS 2003 (and still maintain old code against SQL
Server 2000)?
If not, what does anyone advise - stick to SQL 2000? - and if so, will the
code changes for Express 2005 be minimal?
Many thanks
James StewartIf this is a new project from scratch then what better time to start with
VS2005? In any case most things that you do for MSDE will still work in
Express but if you were to go with Express to start you can not use any new
2005 features if you need backwards compatibility.
Andrew J. Kelly SQL MVP
"jas" <jas@.discussions.microsoft.com> wrote in message
news:A95C5622-B38F-4D35-BBDB-8A1CEE0D907C@.microsoft.com...
>I am in the happy position of starting a new project from scratch. I have
> only VS 2003, do not want to dabble in VS 2005 Beta yet, but am keen to
> plan
> for using SQL Server Express 2005, which would be delivered to the (small)
> customer.
> Can I use 2005 Express with VS 2003 (and still maintain old code against
> SQL
> Server 2000)?
> If not, what does anyone advise - stick to SQL 2000? - and if so, will the
> code changes for Express 2005 be minimal?
> Many thanks
> James Stewart
>|||Well, I'd love to, but now is not quite the time for risking Beta s/w nor fo
r
installing 2005 alongside VS 2003 on my laptop: too much too soon too close
together too busy...
So will it be ok to install Express 2005 with VS 2003 (AND SQL Server 2000)
on the same machine, so that I can try out Express 2000,
- or -
Should I just continue (with known stability) with VS 2003 + SQL Server 2000
knowing that the conversions to a) Express 2005 and then b) VS 2005 should
not be painful?
Of course, if I knew when (as an MSDN subscriber) full release versions of
VS 2005 and Express 2005 were coming out, I might take the plunge...
Thanks
James S.
"Andrew J. Kelly" wrote:

> If this is a new project from scratch then what better time to start with
> VS2005? In any case most things that you do for MSDE will still work in
> Express but if you were to go with Express to start you can not use any ne
w
> 2005 features if you need backwards compatibility.
> --
> Andrew J. Kelly SQL MVP
>
> "jas" <jas@.discussions.microsoft.com> wrote in message
> news:A95C5622-B38F-4D35-BBDB-8A1CEE0D907C@.microsoft.com...
>
>|||> Of course, if I knew when (as an MSDN subscriber) full release versions of
> VS 2005 and Express 2005 were coming out, I might take the plunge...
From Paul Flessner's keynote at TechEd 2005:
<Excerpt
href="http://www.microsoft.com/presspass/press/2005/jun05/TechEd2005Day2PR.m
spx">
As part of the keynote address, Paul Flessner, senior vice president of
Server Applications at Microsoft, showed the company's continued momentum in
preparation for the launch of SQL ServerT 2005, Visual Studio 2005 and
BizTalk Server 2006, and announced that these products will be formally
launched during the w of Nov. 7.
</Excerpt>
Note that installing beta software on you primary development box is at your
own risk. If you want to go for the 2005 beta stuff, you should consider an
isolated environment.
Hope this helps.
Dan Guzman
SQL Server MVP
"jas" <jas@.discussions.microsoft.com> wrote in message
news:BB286E29-3EA6-492E-85B8-DC9175C07D04@.microsoft.com...
> Well, I'd love to, but now is not quite the time for risking Beta s/w nor
> for
> installing 2005 alongside VS 2003 on my laptop: too much too soon too
> close
> together too busy...
> So will it be ok to install Express 2005 with VS 2003 (AND SQL Server
> 2000)
> on the same machine, so that I can try out Express 2000,
> - or -
> Should I just continue (with known stability) with VS 2003 + SQL Server
> 2000
> knowing that the conversions to a) Express 2005 and then b) VS 2005 should
> not be painful?
> Of course, if I knew when (as an MSDN subscriber) full release versions of
> VS 2005 and Express 2005 were coming out, I might take the plunge...
> Thanks
> James S.
> "Andrew J. Kelly" wrote:
>|||As Dan mentioned the date for the launch is Nov 7th. SQL Server Express is
still Beta since it is SQL2005. If you don't want to risk side by side then
don't do it. You can load it in a virtual PC so it won't harm anything
else.
Andrew J. Kelly SQL MVP
"jas" <jas@.discussions.microsoft.com> wrote in message
news:BB286E29-3EA6-492E-85B8-DC9175C07D04@.microsoft.com...
> Well, I'd love to, but now is not quite the time for risking Beta s/w nor
> for
> installing 2005 alongside VS 2003 on my laptop: too much too soon too
> close
> together too busy...
> So will it be ok to install Express 2005 with VS 2003 (AND SQL Server
> 2000)
> on the same machine, so that I can try out Express 2000,
> - or -
> Should I just continue (with known stability) with VS 2003 + SQL Server
> 2000
> knowing that the conversions to a) Express 2005 and then b) VS 2005 should
> not be painful?
> Of course, if I knew when (as an MSDN subscriber) full release versions of
> VS 2005 and Express 2005 were coming out, I might take the plunge...
> Thanks
> James S.
> "Andrew J. Kelly" wrote:
>