Portfolio Analyzer Views Migration tool
This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.
Topic Last Modified: 2016-11-14
The Portfolio Analyzer Views Migration tool is a utility in the Project Server 2007 Project Resource Kit (PRK). It enables administrators to bulk edit the Microsoft SQL Server Analysis Services settings in Data Analysis views. This is particularly useful when a Microsoft Office Project Server 2003 database has been migrated to Microsoft Office Project Server 2007 and the computer on which SQL Server Analysis Services is installed has changed. The benefit of using this tool is that administrators avoid having to manually edit the values for each view individually.
Click to download (http://www.microsoft.com/downloads/details.aspx?FamilyId=A33D253C-6424-48E4-B87E-0861D1977BB7\&displaylang=en) the Project Server 2007 PRK from the Microsoft Download Center.
The Portfolio Analyzer Views Migration tool has the following requirements for usage:
Microsoft Windows XP, Windows Vista, or Windows Server 2003.
Microsoft .NET Framework 2.x or 3.x.
Migrate Portfolio Analyzer views
Run PAViewsMigration.exe to start the Portfolio Analyzer Views Migration tool.
On the Project Server URL page, specify the Office Project Server 2007 instance where the Data Analysis views exist. In the Project Server URL box, type the URL of your Project Server instance. Click Next.
On the Select an Authentication Mode page, select the authentication mode that you use to connect to Project Server. Your options are:
Use Windows Account information.
Use forms authentication account. You will also need to enter your user name and password.
On the Select Views page, specify the Data Analysis views that you are going to bulk edit. All available views are shown in the Available Views list.
Use the buttons as follows to put views in the Migrate Views list:
Click Add All to move all available views to the Migrate Views list.
Click Add to move individual views to the Migrate Views list.
Click Remove to move individual views from the Migrate Views list to the Available Views list.
Click Remove All to move all views from the Migrate Views list to the Available Views list.
On the Analysis Server page, specify the SQL Server Analysis Server and the Analysis Server database that the views will use.
In the Analysis Server box, type the name of the Analysis Server.
In the Analysis Server Database box, select the Analysis Server database from the drop-down list.
Click Next. The tool goes through each view and sets the view to reference the SQL Server Analysis Services server that you specified.
Download this book
This topic is included in the following downloadable book for easier reading and printing:
See the full list of available books at Downloadable content for Project Server 2007.