Un-Installing SQL Server 2005 32 bit and Installing SQL Server 2008 64 bit - Common GroundUpgrades Only

From DocWiki

Revision as of 16:44, 18 June 2012 by Dosproul (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Upgrading a SQL 2005 32 bit to SQL 2008 64 bit is not supported. The following procedure details how to migrate from SQL 2005 to SQL 2008.

  • Take a backup of all ICM databases (SideA/sideb, AW, HDS, baA) using CGUpgradeBackup.exe.
Go to command prompt and execute the below command :
CGUpgradeBackup -backup -sh <your backup folder name>
  • Un-install 32 bit SQL Server 2005 completely from the system.
  • Open SQL Server 2008 Management studio, select No for Import customized user setting from SQL 2005 and SQL 2005 management studio registered servers dialog.
(These dialog windows appear for the first time when SQL Server 2008 Management Studio is opened.)
  • Restore the SQL db of all the db's (SideA/sideb, Aw, HDS, baA) into SQL Server 2008 Management Studio by using CGUpgradeBackup.exe.
Go to command prompt and execute the below command :
CGUpgradeBackup -restore -sh <your backup folder name>

Rating: 5.0/5 (1 vote cast)

Personal tools