|
Home > Archive > Microsoft SQL Server Desktop Engine > April 2005 > Upgrade MSDE to SQL Server 2000 Standard Ed.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Upgrade MSDE to SQL Server 2000 Standard Ed.
|
|
| AlwaysLearning 2005-04-14, 8:24 pm |
| I understand that upgrading MSDE to SQL Server 2000 is supported. Does this
mean when SQL Server 2000 is installed on the same server as MSDE, that the
installation "sees" MSDE, and retains all the MSDE settings, like collation
for instance?
--
AlwaysLearning
| |
| Andrea Montanari 2005-04-15, 7:23 am |
| hi,
AlwaysLearning wrote:
> I understand that upgrading MSDE to SQL Server 2000 is supported.
> Does this mean when SQL Server 2000 is installed on the same server
> as MSDE, that the installation "sees" MSDE, and retains all the MSDE
> settings, like collation for instance?
MSDE and SQL Server installations rely on different installation procedures,
Windows Installer for MSDE and Wise for SQL Server... personally I never
tested this kind of upgrade, even if I heard it's supported... this should
mean that the upgrad process will actually inherit all serverside settings,
like collation.... but.. again, never tested it..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply
| |
| Mike Epprecht \(SQL MVP\) 2005-04-15, 9:24 am |
| Hi
Upgrade is not possible. You need to backups the DB's in MSDE and restore
them into SQL Server 2000, or detach and attach them
SQL Server 2000 setup will make sure that it does not use the same named
instance and port number, but that is about all it cares about MSDE 2000.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
news:3c9la1F6jgj5rU1
@individual.net...
> hi,
> AlwaysLearning wrote:
>
> MSDE and SQL Server installations rely on different installation
> procedures, Windows Installer for MSDE and Wise for SQL Server...
> personally I never tested this kind of upgrade, even if I heard it's
> supported... this should mean that the upgrad process will actually
> inherit all serverside settings, like collation.... but.. again, never
> tested it..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>
|
|
|
|
|