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 database) using SQL Server Upgrade Advisor. The following is the Report.
2. Took the backup of database from Machine1 and restored as database in Machine2.
3. Executed the Stored Procedure mentioned in the link (http://support.microsoft.com/kb/906145 ) in Machine2. (Optional)
4. Configured MCMS to new database using Database Configuration Application.
Note: Assumed that MCMS 2002 SP1A and MCMS 2002 SP2 are installed in Machine1
5. Made necessary config changes to point to new content database in Machine2

Comments

Post a Comment

Popular posts from this blog

Better manage customer relationships using Outlook Customer Manager

Microsoft Office 365 has always been a go-to solution for small, medium and large scale businesses. Enterprises have benefited in areas of productivity and collaboration using Office 365. The customer manager helps to better manage your customer relationships more effectively. The main pain points of businesses are to able to keep track of the conversations and requests from customers and these are essential for repeat business scenarios. The new Office 365 service, Customer Manager helps you in maintaining and managing your communications with customers in an easy and effective manner. It provides holistic view of customer interactions and helps keep track of tasks and opportunities along with providing alerts. Customer Manager automatically organizes customer information—such as emails, meetings, calls, notes, files, tasks, deals and deadlines as a timeline. Those users with Dynamics 365, can migrate customer information to achieve process efficiency and consistency, and deeper
Read more

Understanding the Cloud Spectrum

As today’s organizations make a steady progress to the cloud, it does have impact the organizational roadmap and what they wish to achieve. CIO’s within each organization make it possible framing the IT goals to shift processes and programs to the cloud. The understanding of the cloud enablement and which technologies are cloud ready is critical to the success of such migrations. Here is an article from Gartner, with an initial guidance on cloud enabling and computing along with stages. Read it here .
Read more

Multi-Factor Authentication for Office 365

Multi-Factor Authentication for Office 365 works exclusively with Microsoft Office 365 applications at no additional cost and is managed from the Office 365 portal. Multi-Factor Authentication for Office 365 offers the following subset of Azure Multi-Factor Authentication capabilities: Ability to enable and enforce multi-factor authentication for end users Use of a mobile app (online and one-time password [OTP]) as a second authentication factor Use of a phone call as a second authentication factor Use of an SMS message as a second authentication factor Application passwords for non-browser clients (for example, Microsoft Outlook messaging and collaboration client and Microsoft Lync communications software) Default Microsoft greetings during authentication phone calls Read more : https://technet.microsoft.com/en-us/library/dn383636.aspx
Read more