Hi,
I am trying to upgrade SQL Server 2000 Enterprise edition to SQL2K5 Developer edition. But it errors out without any detailed message. Is it because, even though the version is being upgraded the edition is downgraded, or could there be a different issue ?
Anyone else facing a similar problem ?
If I have to uninstall 2000 and install 2005 from scratch, what all things do I need to ensure so as no data is lost ?
Thanks,
Tanvi.
Hi Tanvi,
That's not a supported upgrade path (i.e. Sql2k EE to Sql2k5 Dev). See the following link for supported upgrade paths:
http://msdn2.microsoft.com/en-us/library/ms143393.aspx
HTH
Thanks Chad.
I think, I would have to build the database from scratch. What steps should I ensure in order to achieve a smooth transition ?
How should I transfer logins etc.
Any suggestions will be appreciated.
Thanks,
Tanvi.
You can do the following:
1. Create copy of your database files to because SQL 2000 uninstall is going to remove system databases.
2. Uninstall SQL 2000 it will remove system database files.
3. Restore the database files into their original location.
4. Launch SQL 2005 setup and proceed to Components to Install dialog, select SQL Server Database Services and hit Advanced button
5. Expand Database Services feature, select Data Files feature and hit Browse... button
6. Navigate to the location where your old data files are and hit OK.
7. On Feature Selection dialog hit Next and setup will ask you a question if you want to use those data files so select OK.
8. Continue setup and select the same options as in previous instance (Instance name, service account).
Thanks Milos for your response.
Would SQL2k5 setup automatically upgrade the system databases to its new format?
Would it also recognise the jobs, dts packages from msdb database ?
Thanks,
Tanvi.
Setup will updated all databases to new format. The result is the same as if you did upgrade from SQL 2000 directly I am not sure if dts packages are preserved during upgrade.
Thanks
