Skip to Main Content
Essential SharePoint 2007, 2nd Edition
book

Essential SharePoint 2007, 2nd Edition

by Jeff Webb
September 2007
Beginner content levelBeginner
448 pages
10h 2m
English
O'Reilly Media, Inc.
Content preview from Essential SharePoint 2007, 2nd Edition

Performing a Database Migration

The database migration upgrade is best when you are changing hardware as well as upgrading SharePoint. For example, if both SharePoint and SQL Server are hosted on the same server, you can use this approach to move the content database to a dedicated SQL Server for better performance. (SharePoint and SQL Server compete for memory, so using a dedicated SQL Server usually results in better performance.)

Database migration is also the way to go if you want to leave the existing web application in place after upgrade process. Using this process, you can host both the pre- and post-upgrade web applications on the same server. To switch from one to the other, you simply stop one web application in IIS and start the other. You can even use the same URL for both web applications as long as only one is running at a time.

To perform a database migration:

  1. Run PRESCAN.EXE on the web application to upgrade. Prescan must succeed without errors in order to be able to upgrade the web application.

  2. Set the web application's content database to read-only to prevent changes during the upgrade process.

  3. Copy the existing content database to a new database.

  4. Create a new WSS 2.0 web application and attach the copied content databases to that web application. You can do this on your staging server if you have one.

  5. Verify that the new web application works as expected.

  6. Upgrade the new WSS 2.0 web application to WSS 3.0. You can use the in-place or side-by-side upgrade procedure.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office SharePoint® Server 2007 Best Practices

Microsoft® Office SharePoint® Server 2007 Best Practices

Ben Curry, Bill English
SharePoint 2007: The Definitive Guide

SharePoint 2007: The Definitive Guide

James Pyles, Christopher M. Buechler, Bob Fox, Murray Gordon, Michael Lotter, Jason Medero, Nilesh Mehta, Joris Poelmans, Christopher Pragash, Piotr Prussak, Christopher J. Regan

Publisher Resources

ISBN: 9780596514075Errata Page