Installing Express on box that already has Developer Edition

I'm not at all certain I need to install SQL Server 2005 Express Edition on
my box, but I thought I'd post this anyway.
I currently have SQL Server 2005 Developer Edition installed on my box and
am using it to develop a commercial website I hope to deploy within the next
six months. Meanwhile, I have at least one upcoming Windows Forms project
requiring a SQL Server database which will need to be deployed with the
project. Naturally, I will be including the .mdf file in the setup files for
the project.
My questions are as follows:
1) Will I need to include a copy of the SQL Server 2005 EE on my setup disk
or can I get by with just distributing the .mdf file?
2) If the answer to question 1 is yes on including a copy of SSEE; do I need
to install SQL Server 2005 EE on my computer in order to include it with the
setup disk? I would want to be able to install my application and the
database as a single operation rather than forcing the end user to install
SQL Server first and then install the application.
3) If the answer to question 2 is yes, what problems, if any, will I
encounter trying to install SQL Server 2005 EE on a machine that already has
the Developer Edition installed?
Thanks for any and all help!
Allen"SQL Server Express can be redistributed (subject to agreement)". so, you
can bundle it with your application.
if you know for sure that your clients already have sqlexpress installed,
you can just include the *.mdf. this will make your deployment package much
smaller.
no, you do not need to install sqlexpress on your box in order to
redistribute it. typically, if you're an ISV and develop your app using a
valid visual studio, you should be good to redistribute.
there should be no prob installing sqlexpress on a box with dev edt.
--
-oj
"AlBruAn" <AlBruAn@.discussions.microsoft.com> wrote in message
news:99156D83-2DA5-4EFA-AC48-275271F3CAE3@.microsoft.com...
> I'm not at all certain I need to install SQL Server 2005 Express Edition
> on
> my box, but I thought I'd post this anyway.
> I currently have SQL Server 2005 Developer Edition installed on my box and
> am using it to develop a commercial website I hope to deploy within the
> next
> six months. Meanwhile, I have at least one upcoming Windows Forms project
> requiring a SQL Server database which will need to be deployed with the
> project. Naturally, I will be including the .mdf file in the setup files
> for
> the project.
> My questions are as follows:
> 1) Will I need to include a copy of the SQL Server 2005 EE on my setup
> disk
> or can I get by with just distributing the .mdf file?
> 2) If the answer to question 1 is yes on including a copy of SSEE; do I
> need
> to install SQL Server 2005 EE on my computer in order to include it with
> the
> setup disk? I would want to be able to install my application and the
> database as a single operation rather than forcing the end user to install
> SQL Server first and then install the application.
> 3) If the answer to question 2 is yes, what problems, if any, will I
> encounter trying to install SQL Server 2005 EE on a machine that already
> has
> the Developer Edition installed?
> Thanks for any and all help!
> Allen|||Addition to the other reply.
You can install Sql Server2005 Express on the computer with SQL Server 2005
Developer Edition/Standard editon, or other editions. I have both (Developer
and Express Adv) installed on one of my boxex).
If your application uses SQL Server2005 Express's user instanace feature
(only available to Express edition, not other editions), then you want to
try it out on your development computer before shipping your app to client.
In this case, you need to have SQL Server 2005 Express available on your
computer.
"AlBruAn" <AlBruAn@.discussions.microsoft.com> wrote in message
news:99156D83-2DA5-4EFA-AC48-275271F3CAE3@.microsoft.com...
> I'm not at all certain I need to install SQL Server 2005 Express Edition
> on
> my box, but I thought I'd post this anyway.
> I currently have SQL Server 2005 Developer Edition installed on my box and
> am using it to develop a commercial website I hope to deploy within the
> next
> six months. Meanwhile, I have at least one upcoming Windows Forms project
> requiring a SQL Server database which will need to be deployed with the
> project. Naturally, I will be including the .mdf file in the setup files
> for
> the project.
> My questions are as follows:
> 1) Will I need to include a copy of the SQL Server 2005 EE on my setup
> disk
> or can I get by with just distributing the .mdf file?
> 2) If the answer to question 1 is yes on including a copy of SSEE; do I
> need
> to install SQL Server 2005 EE on my computer in order to include it with
> the
> setup disk? I would want to be able to install my application and the
> database as a single operation rather than forcing the end user to install
> SQL Server first and then install the application.
> 3) If the answer to question 2 is yes, what problems, if any, will I
> encounter trying to install SQL Server 2005 EE on a machine that already
> has
> the Developer Edition installed?
> Thanks for any and all help!
> Allen