Installing more than one edition

I am a contract software designer, servicing multiple industries and multiple sizes within those industries. I need a way to develop and test on both SQL Server Developer edition, and SQL Server Express. Is it possible to install these two editions side-by-side for the purposes of development?

Do I need to have them installed on separate computers?

Yes. You can install different editions of SQL Server 2005 on the same machine successfully, which is supported by SQL Server 2005 provided that the machine has enouugh resources like disk space and the operating system supports the edition of SQL Server 2005. Please see BOL(Books OnLine) for details.

|||Yes, and the major concern is to be aware that if you use SSMS (from the Developer Edition), you will have some functionality that SQL Express does not support. So be cautious when you are attempting to guide a client that may have only SSMSE.sql

Installing a Database

Hello all...I develop a Database in a Local Instance of a server.
Then, I need to install ALL the New database in a remote server using TCP
connection and, I have no idea how script them and how can I execute this
script remotely. Obviously, I have Administrator permissions on this server
(W2K3).
Any Idea?
Some sample to clarify me the concept?
Thanks
If you're using Enterprise Manager, you can register the remote server with
the local server in EM. Perform a backup of the database with a
right-click, copy the backup file to the remote server (same location if
possible) then restore the database with another right-click. You can also
use Query Analyzer and the Transact-SQL statments (BACKUP and RESTORE) to
perform the backup and restore. Another technique is to use sp_detach_db
and sp_attach_db.
For more information see these topics in the SQL Server Books Online.
Also look at :
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default...b;en-us;314546
HTH
Jerry
"Nando_uy" <Nandouy@.discussions.microsoft.com> wrote in message
news:2142AE07-CEEE-4FC1-AE1F-D33F417F6D4D@.microsoft.com...
> Hello all...I develop a Database in a Local Instance of a server.
> Then, I need to install ALL the New database in a remote server using TCP
> connection and, I have no idea how script them and how can I execute this
> script remotely. Obviously, I have Administrator permissions on this
> server
> (W2K3).
> Any Idea?
> Some sample to clarify me the concept?
> Thanks

Installing a Database

Hello all...I develop a Database in a Local Instance of a server.
Then, I need to install ALL the New database in a remote server using TCP
connection and, I have no idea how script them and how can I execute this
script remotely. Obviously, I have Administrator permissions on this server
(W2K3).
Any Idea?
Some sample to clarify me the concept?
ThanksIf you're using Enterprise Manager, you can register the remote server with
the local server in EM. Perform a backup of the database with a
right-click, copy the backup file to the remote server (same location if
possible) then restore the database with another right-click. You can also
use Query Analyzer and the Transact-SQL statments (BACKUP and RESTORE) to
perform the backup and restore. Another technique is to use sp_detach_db
and sp_attach_db.
For more information see these topics in the SQL Server Books Online.
Also look at :
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/defaul...kb;en-us;314546
HTH
Jerry
"Nando_uy" <Nandouy@.discussions.microsoft.com> wrote in message
news:2142AE07-CEEE-4FC1-AE1F-D33F417F6D4D@.microsoft.com...
> Hello all...I develop a Database in a Local Instance of a server.
> Then, I need to install ALL the New database in a remote server using TCP
> connection and, I have no idea how script them and how can I execute this
> script remotely. Obviously, I have Administrator permissions on this
> server
> (W2K3).
> Any Idea?
> Some sample to clarify me the concept?
> Thankssql

Installing a Database

Hello all...I develop a Database in a Local Instance of a server.
Then, I need to install ALL the New database in a remote server using TCP
connection and, I have no idea how script them and how can I execute this
script remotely. Obviously, I have Administrator permissions on this server
(W2K3).
Any Idea?
Some sample to clarify me the concept?
ThanksIf you're using Enterprise Manager, you can register the remote server with
the local server in EM. Perform a backup of the database with a
right-click, copy the backup file to the remote server (same location if
possible) then restore the database with another right-click. You can also
use Query Analyzer and the Transact-SQL statments (BACKUP and RESTORE) to
perform the backup and restore. Another technique is to use sp_detach_db
and sp_attach_db.
For more information see these topics in the SQL Server Books Online.
Also look at :
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
HTH
Jerry
"Nando_uy" <Nandouy@.discussions.microsoft.com> wrote in message
news:2142AE07-CEEE-4FC1-AE1F-D33F417F6D4D@.microsoft.com...
> Hello all...I develop a Database in a Local Instance of a server.
> Then, I need to install ALL the New database in a remote server using TCP
> connection and, I have no idea how script them and how can I execute this
> script remotely. Obviously, I have Administrator permissions on this
> server
> (W2K3).
> Any Idea?
> Some sample to clarify me the concept?
> Thanks

installation trouble

ok i am working on Win2k pro.
i want to be able to develop reports and then move them to the production
server.
I can't use MSDE, or Std Edition on my machine-- so I finally settled on
Developers' edition of SQL OLTP.
The CD that I have only had a Std Edition of RS; and I couldn't get RS Std
to use SQL Developers' edition for the RS databases.
So I had to download the trial.
And now the http://127.0.0./reportServer site is failing; but it looks like
the http://127.0.0.1/reportManager site is working as expected.. with about
80% of the functionality that I remembered.
I am a local admin.
I guess that I am a lil bit confused.. When I installed; it wanted to make 2
sites http://127.0.0.1/reports and http://127.0.0.1/reportServer
I was just confused; the report manager site-- shouldn't that be called
ReportManager? It defaulted to 'Reports' and i changed it-
People will actually naviagate to the ReportServer site in order to view
reports' Or does everyone-- from me to an end user; have to go to
http://127.0.0.1/ReportManager site now?
-aaronReportServer is the home for Web Service. You should just get a simple page
if you go there.. if your getting an error, details would be appreciated.
/Reports or /ReportManager whatever you called it is the UI for the Web
Service.
thats what your users should use.
<aaron_kempf@.hotmail.com> wrote in message
news:OCnZeBW3EHA.2600@.TK2MSFTNGP09.phx.gbl...
> ok i am working on Win2k pro.
> i want to be able to develop reports and then move them to the production
> server.
> I can't use MSDE, or Std Edition on my machine-- so I finally settled on
> Developers' edition of SQL OLTP.
> The CD that I have only had a Std Edition of RS; and I couldn't get RS Std
> to use SQL Developers' edition for the RS databases.
> So I had to download the trial.
> And now the http://127.0.0./reportServer site is failing; but it looks
> like
> the http://127.0.0.1/reportManager site is working as expected.. with
> about
> 80% of the functionality that I remembered.
> I am a local admin.
> I guess that I am a lil bit confused.. When I installed; it wanted to make
> 2
> sites http://127.0.0.1/reports and http://127.0.0.1/reportServer
> I was just confused; the report manager site-- shouldn't that be called
> ReportManager? It defaulted to 'Reports' and i changed it-
> People will actually naviagate to the ReportServer site in order to view
> reports' Or does everyone-- from me to an end user; have to go to
> http://127.0.0.1/ReportManager site now?
> -aaron
>
>|||thank you.
I am getting a directory listing when i browse the ReportServer site; do i
need to at least drop that perms?
I'm a local admin
"CJ Taylor" <jjackson@.jackson5.com> wrote in message
news:e7ySAIW3EHA.1400@.TK2MSFTNGP11.phx.gbl...
> ReportServer is the home for Web Service. You should just get a simple
page
> if you go there.. if your getting an error, details would be appreciated.
> /Reports or /ReportManager whatever you called it is the UI for the Web
> Service.
> thats what your users should use.
> <aaron_kempf@.hotmail.com> wrote in message
> news:OCnZeBW3EHA.2600@.TK2MSFTNGP09.phx.gbl...
> > ok i am working on Win2k pro.
> >
> > i want to be able to develop reports and then move them to the
production
> > server.
> >
> > I can't use MSDE, or Std Edition on my machine-- so I finally settled on
> > Developers' edition of SQL OLTP.
> >
> > The CD that I have only had a Std Edition of RS; and I couldn't get RS
Std
> > to use SQL Developers' edition for the RS databases.
> >
> > So I had to download the trial.
> >
> > And now the http://127.0.0./reportServer site is failing; but it looks
> > like
> > the http://127.0.0.1/reportManager site is working as expected.. with
> > about
> > 80% of the functionality that I remembered.
> >
> > I am a local admin.
> >
> > I guess that I am a lil bit confused.. When I installed; it wanted to
make
> > 2
> > sites http://127.0.0.1/reports and http://127.0.0.1/reportServer
> >
> > I was just confused; the report manager site-- shouldn't that be called
> > ReportManager? It defaulted to 'Reports' and i changed it-
> >
> > People will actually naviagate to the ReportServer site in order to view
> > reports' Or does everyone-- from me to an end user; have to go to
> > http://127.0.0.1/ReportManager site now?
> >
> > -aaron
> >
> >
> >
>|||If you check the URL of an actual report inside ReportManager, you'll see
that it's actually calling a ReportServer URL, so you shouldn't change
permissions on ReportServer. Whatever permissions you set via ReportManager
will be reflected in the ReportServer. ReportManager is simply a friendly
interface to the same thing, with some admin tools on top if it for
administrators.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
<aaron_kempf@.hotmail.com> wrote in message
news:%238D%23zTW3EHA.2572@.tk2msftngp13.phx.gbl...
> thank you.
> I am getting a directory listing when i browse the ReportServer site; do i
> need to at least drop that perms?
> I'm a local admin
>
>
> "CJ Taylor" <jjackson@.jackson5.com> wrote in message
> news:e7ySAIW3EHA.1400@.TK2MSFTNGP11.phx.gbl...
>> ReportServer is the home for Web Service. You should just get a simple
> page
>> if you go there.. if your getting an error, details would be
>> appreciated.
>> /Reports or /ReportManager whatever you called it is the UI for the Web
>> Service.
>> thats what your users should use.
>> <aaron_kempf@.hotmail.com> wrote in message
>> news:OCnZeBW3EHA.2600@.TK2MSFTNGP09.phx.gbl...
>> > ok i am working on Win2k pro.
>> >
>> > i want to be able to develop reports and then move them to the
> production
>> > server.
>> >
>> > I can't use MSDE, or Std Edition on my machine-- so I finally settled
>> > on
>> > Developers' edition of SQL OLTP.
>> >
>> > The CD that I have only had a Std Edition of RS; and I couldn't get RS
> Std
>> > to use SQL Developers' edition for the RS databases.
>> >
>> > So I had to download the trial.
>> >
>> > And now the http://127.0.0./reportServer site is failing; but it looks
>> > like
>> > the http://127.0.0.1/reportManager site is working as expected.. with
>> > about
>> > 80% of the functionality that I remembered.
>> >
>> > I am a local admin.
>> >
>> > I guess that I am a lil bit confused.. When I installed; it wanted to
> make
>> > 2
>> > sites http://127.0.0.1/reports and http://127.0.0.1/reportServer
>> >
>> > I was just confused; the report manager site-- shouldn't that be called
>> > ReportManager? It defaulted to 'Reports' and i changed it-
>> >
>> > People will actually naviagate to the ReportServer site in order to
>> > view
>> > reports' Or does everyone-- from me to an end user; have to go to
>> > http://127.0.0.1/ReportManager site now?
>> >
>> > -aaron
>> >
>> >
>> >
>>
>