Re: Upgrading 2000 to 2005
- From: "Dan Jones \(MS\)" <dan.jones@xxxxxxxxxxxxx>
- Date: Tue, 11 Apr 2006 12:52:18 -0700
You'll need to put something in your script to check for the existence of
SQL Server 2000 an then run the appropriate command line based on the
results.
--
Cheers,
Dan
Lead Program Manager
SQL Server Manageability Platform Team
"This posting is provided "AS IS" with no warranties, and confers no rights"
"PJU" <PJU@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D9DAE2EE-F176-47E8-88BA-56C7D292FE2B@xxxxxxxxxxxxxxxx
You got it.... and yes it fails if there isnt an instance on the machine.
I had hoped that it would install a new one if one doesnt exist, and
upgrade
if one does.
"Dan Jones (MS)" wrote:
So what you're saying is you want to install SQL Server 2005 with a
specific
instance name (could be default) but you don't know if SQL Server 2000 is
on
the box with the same instance name. If it isn't there you just want to
install, however, if it is there you want to upgrade it - and you want to
do
this with a single command line. Did I get this correct? I'm pretty sure
this isn't something we tested. The expectation is you know beforehand if
you're doing an upgrade or a new install. Did you try the following
"setup.exe ADDLOCAL=SQL_Engine UPGRADE=SQL_Engine INSTANCENAME=<foobar>"?
I'm going to guess that it'll fail for new installs because it will
attempt
to do an upgrade and it won't find an existing instance.
--
Cheers,
Dan
Lead Program Manager
SQL Server Manageability Platform Team
"This posting is provided "AS IS" with no warranties, and confers no
rights"
"PJU" <PJU@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7C82BEB5-CE9D-464E-974D-8A380843A4ED@xxxxxxxxxxxxxxxx
Yes, understand that... but how do i cover the upgrade and new install
on
the
one command line. ?
"Dan Jones (MS)" wrote:
If you want to do a new install you need to add ADDLOCAL=SQL_Engine
--
Cheers,
Dan
Lead Program Manager
SQL Server Manageability Platform Team
"This posting is provided "AS IS" with no warranties, and confers no
rights"
"PJU" <PJU@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F562B268-52D8-46A7-B040-A2D8ABF56D9A@xxxxxxxxxxxxxxxx
I need to upgrade a lot default installs of MSDE to SQL Express, and
install
new default installs.
If i use the commandline switch UPGRADE=SQL_Engine then the upgrade
of
existing default instances works fine. However if its a new install
then
it
says it cant upgrade. and fails. This need to be automated.
Is there another command line switch that can acheive this ????
.
- References:
- Re: Upgrading 2000 to 2005
- From: Dan Jones \(MS\)
- Re: Upgrading 2000 to 2005
- From: Dan Jones \(MS\)
- Re: Upgrading 2000 to 2005
- From: PJU
- Re: Upgrading 2000 to 2005
- Prev by Date: Re: 2k5 unattended install
- Next by Date: Re: 2k5 unattended install
- Previous by thread: Re: Upgrading 2000 to 2005
- Next by thread: Easy way to move multiple databases from one disk to another?
- Index(es):
Relevant Pages
|
