MCMS Database Migration - SQL Server 2000 to Sql Server 2005
Approach 1:(Create a new MCMS 2002 and SQL Server 2005setup and migrate the sites) Machine1: Install SQL Server 2005. Machine2: Install MCMS. The following are the steps followed 1. Created a database for the MCMS sites on Machine1 2. Executed the Stored Procedure mentioned in the link ( http://support.microsoft.com/kb/906145 ) in Machine1. 3. Installed MCMS 2002 SP1a in Machine2. 4. Installed MCMS 2002 SP2 in Machine2. 5. Configured MCMS to database created on Machine1 using Database Configuration Application. 6. Created a backup of the MCMS site in the previous MCMS setup( MCMS 2002 on Sql Server 2000) and restore it on the current setup( MCMS 2002 on Sql Server 2005) Approach 2: ( Here we are planning to migrate the Sql Server DB from 2000 to 2005) We are installing the new SQL Server 2005 on Machine 2. Machine 1 has the MCMS 2002 and Sql Server 2000 setup The following are the steps followed 1. Analyzed the [Machine1].(content databa