Tuesday, February 19, 2008

Series Article: Article 1 Migrating Project Server 2003 (PS03) to Project Server 2007 (PS07)

This will be a several part article. Enclosed is part1
Migrating Project Server 2003 (PS03) to Project Server 2007 (PS07)

There have been a ton of questions from people on migrating PS03 to PS07 so I am creating this white paper as a resource. My best piece of advice is to hire a Project Server Consultant who has done this before as there are many pieces to the process. With that said, enclosed are the steps to follow along with links to other resources and information.

Step 1 Backup the Project Server 2003 Databases

Backup, Backup, and backup again.

Backup the Project Server 2003 solution. Backup the databases; this includes Project Server and SharePoint databases. If you’re not sure what databases are being used by the solution follow these steps.

1. Determine the primary database for Project Server 2003. If you installed the application in the primary directory, look in C:\program files\Microsoft Office Project Server 2003\BIN\1033. There you will find a tool called Conninfo.exe run the executable and you will see the following window.

2. This tool shows you what SQL Server you are using as well as what is the primary database.

3. Determine the SharePoint Database. To find out what SharePoint database you are using follow these instructions. From PWA go to Admin à Manage Windows SharePoint Services. You will see the following screen.

4. The red box shows the SharePoint Central admin site. Click the “Test URL” link and open SharePoint Central Administration. Look under the section “Server Configuration”.

5. Click on the two links, first check the content database. This will only tell you what server the database is on, not what database but the database will look like this “STS_(ServerName)_GUID” the GUID is a unique number for each instance of SharePoint. If you installed multiple instances, back them all up.

6. Next check the configuration database. Click the “Set configuration database link”. (Note you may need to click the back button first.)

7. The red box in the image above shows the server and the database for the SharePoint Content.

8. You must back up each of these databases before beginning a migration. To back an SQL Database it depends on which version of SQL you are using but generally, you can log into the database server, open either Enterprise Manager in SQL 2000 or SQL Management Studio in SQL 2005. Expand the databases section, find the database you wish to backup and right click on it. From the dropdown select backup. There are many settings within backup. I recommend that you get a SQL DBA to backup these databases for you. If one is not available then check out Microsoft information on doing SQL backups here: (SQL 2000 -
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx) (SQL 2005 - http://msdn2.microsoft.com/en-us/library/ms191239.aspx)

Step 2 Review the Microsoft Project Server 2003 Migration Guide

1. Once the Project Server 2003 and SharePoint databases have been backed up, you must review the documentation from Microsoft for Migrating Project Server 2003. That information is found here:
http://technet2.microsoft.com/Office/en-us/library/6771be81-3881-47b3-ba5f-29adf893286d1033.mspx?mfr=true The downloadable book from Microsoft is here: http://go.microsoft.com/fwlink/?LinkID=85679

Next Part: Article 2 Coming Soon...

No comments: