December 5, 2008 at 2:25 pm
Hi,
iam trying to Do in-place upgrade from SQL Server 2000 Developer edition 32 bit to SQL Server 2005 Developer edition on 64-bit. But the Upgrade is blocking and iam getting the following message in Details.
Name: Microsoft SQL Server 2000 (INS1)
Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Edition check:
Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
December 6, 2008 at 3:23 pm
Is it updated with SP3. Check the upgrade matrix at http://msdn.microsoft.com/en-us/library/ms143393(SQL.90).aspx
MJ
December 7, 2008 at 12:32 pm
You need to have SP3 on 2000 at minimum. To move up to 2005.
Are you running SQL 2000 in WOW64 mode on Windows 2003 x64 edition?
There is no supported upgrade from SQL 2000 to SQL 2005 x64, simply by virtue of x64 not being valid on SQL 2000. You could upgrade to SQL 2005 running in WOW64 mode, however that is the 32bit version (and you would have to upgrade to SQL 2005 32bit).
December 7, 2008 at 1:10 pm
Hi Cain,
I think we can do the side-by-side upgrade from sql server 2000 32 bit on windows 2003 32bit to Sql server 2005 64 bit on windows 2003 64 bit as per the 'SQL2005UpgradeTechRef', which says
You cannot perform "cross-bit" upgrades using the in-place upgrade method. There is no direct upgrade path from a 32-bit instance of SQL Server to a 64-bit version of SQL Server 2005, or vice versa. If you want to upgrade a 32-bit version of SQL Server to a 64-bit version of SQL Server 2005, or a 64-bit version of SQL Server to a 32-bit version of SQL Server 2005, you must use the side-by-side upgrade method.
correct me If I understood .
thank you
December 7, 2008 at 1:18 pm
You could do a side by side certainly. This would require installing SQL Server 2005 x64 on the server, backing up and restoring the SQL 2000 databses to the SQL 2005 instance (I wouldn't use a detach/attach method in case of a problem as there is no way to go back to 2000 once you put the databases on 2005).
Just bear in mind that you would have to use a named instance of SQL2005 (if you are using the default instance of SQL2000), and you must be running a x64 version of the OS.
December 8, 2008 at 11:51 am
"Just bear in mind that you would have to use a named instance of SQL2005 (if you are using the default instance of SQL2000), and you must be running a x64 version of the OS".
Can we upgrade named instance of sql server 2000 (32 bit) to sql server 2005 named instance(64 bit on windows 2003 64 bit) and can we keep the sql server 2005 instance name as the old sql server 2000 instance?
December 8, 2008 at 12:01 pm
Realistically the only way to do that is to either backup the SQL2000 databases, uninstall SQL2000 then install SQL2005 and restore the databases.
Or install another instance of SQL2005, backup and restore the databases over there, then uninstall SQL2000, install 2005 as the same instance name as SQL2000 was, then move the databases over and uninstall the first instance of SQL2005 that you installed.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply