upgrading MSDE 2000 to SQL Server 2005 Express

I am upgrading MSDE 2000 to SQL Server 2005 Express

Command to install MSDE:

"C:\MSDERelA\setup.exe" SAPWD="sa" INSTANCENAME="MSDE_NEW"
DISABLENETWORKPROTOCOLS=n SECURITYMODE=SQL

Command to upgrade SQL Server 2005 Express:

"C:\SQL Server 2005 Express Extract\setup.exe" /qb UPGRADE=SQL_Engine
INSTANCENAME=MSDE_NEW ADDLOCAL=SQL_Engine SAPWD=wipro123
INSTALLSQLDIR="D:\~DRA\Projects\CAT\SQL2000NEW\"
INSTALLSQLDATADIR="D:\~DRA\Projects\CAT\SQL2000NEW\Data\" AUTOSTART=1
SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0

While the upgrade was successful, the database files were not moved from
default location of MSDE 2000 to INSTALLSQLDATADIR of 2005

Any tips in making the files move during upgrade? I don?t want the data
to be in one location and SQL binary files in some other location.

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: SP1 ISA fails to upgrade MSDE SP3
    ... MS's first response: ... the fully expanded path of "%ProgramFiles%\ Microsoft SQL Server SP4\WMSDE". ... First problem was that the MSDE ... > seems to be working, though, and otherwise the upgrade seems to be OK. ...
    (microsoft.public.windows.server.sbs)
  • Re: Upgrade path from MSDE to SQL Server 2000
    ... Upgrading from MSDE to SQL Server is deceptively simple: ... installation. ... You will be asked if you want to upgrade your existing ...
    (microsoft.public.sqlserver.msde)
  • Re: R2 SQL Upgrade Questions
    ... SQL Server 2000 - Default Instance ... SBS install from MSDE to SQL 2000 to enable full-text search ... Now if/when i do the upgrade, I don't want to break the the other MSDE ... Do I temporarily stop it and disable WSUS while I uninstall SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: MSDE Installation
    ... You can install MSDE with mixed authentication by specifying ... To make the database read/write after you have copied the data and log files ... not associated with a trusted SQL Server Connection.' ...
    (microsoft.public.sqlserver.msde)
  • Re: MSDE and SBS2003
    ... if you have them all running in the same MSDE instance you're ... >> B. Upgrade them to SQL Server DBs and run them within a Single SQL ...
    (microsoft.public.windows.server.sbs)