Export (0) Print
Expand All
Expand Minimize

ConvertTo-SPProjectDatabase

Project Server 2013
 

Applies to: Project Server 2013

Topic Last Modified: 2013-12-18

Combines the Project Server 2010 Draft, Publish, Reporting, and Archive databases into a single Project Web App database.

ConvertTo-SPProjectDatabase [-WebApplication] <SPWebApplicationPipeBind> -ArchiveDbname <String> -Dbserver <String> -DraftDbname <String> -ProjectServiceDbname <String> -PublishedDbname <String> -ReportingDbname <String> [-AbortAfter <String>] [-AssignmentCollection <SPAssignmentCollection>] [-Confirm [<SwitchParameter>]] [-SQLAzure <SwitchParameter>] [-SQLLogon <PSCredential>] [-WhatIf [<SwitchParameter>]]
ConvertTo-SPProjectDatabase [-ServiceApplication] <PsiServiceApplicationPipeBind> -ArchiveDbname <String> -Dbserver <String> -DraftDbname <String> -ProjectServiceDbname <String> -PublishedDbname <String> -ReportingDbname <String> [-AbortAfter <String>] [-AssignmentCollection <SPAssignmentCollection>] [-Confirm [<SwitchParameter>]] [-SQLAzure <SwitchParameter>] [-SQLLogon <PSCredential>] [-WhatIf [<SwitchParameter>]]

The ConvertTo-SPProjectDatabase cmdlet combines the Project Server 2010 Draft, Publish, Reporting, and Archive databases into a single Project Web App database.

 

Parameter Required Type Description

ServiceApplication

Required

Microsoft.Office.Project.Server.Cmdlet.PsiServiceApplicationPipeBind

The Project Service Application that the Project Web App database is associated with.

WebApplication

Required

Microsoft.SharePoint.PowerShell.SPWebApplicationPipeBind

The web application that the Project Web App database will mount to.

ArchiveDbname

Required

System.String

The name of the Project Server 2010 Archive database.

Dbserver

Required

System.String

The name of the instance of SQL Server where the databases are located.

DraftDbname

Required

System.String

The name of the Project Server 2010 Draft database.

ProjectServiceDbname

Required

System.String

The name of the new Project Web App database.

PublishedDbname

Required

System.String

The name of the Project Server 2010 Published database.

ReportingDbname

Required

System.String

The name of the Project Server 2010 Reporting database.

AbortAfter

Optional

System.String

Internal use only.

AssignmentCollection

Optional

Microsoft.SharePoint.PowerShell.SPAssignmentCollection

Manages objects for the purpose of proper disposal. Use of objects, such as SPWeb or SPSite, can use large amounts of memory and use of these objects in Windows PowerShell scripts requires proper memory management. Using the SPAssignment object, you can assign objects to a variable and dispose of the objects after they are needed to free up memory. When SPWeb, SPSite, or SPSiteAdministration objects are used, the objects are automatically disposed of if an assignment collection or the Global parameter is not used.

NoteNote:
When the Global parameter is used, all objects are contained in the global store. If objects are not immediately used, or disposed of by using the Stop-SPAssignment command, an out-of-memory scenario can occur.

Confirm

Optional

System.Management.Automation.SwitchParameter

Prompts you for confirmation before executing the command. For more information, type the following command: get-help about_commonparameters

SQLAzure

Optional

System.Management.Automation.SwitchParameter

Internal use only.

SQLLogon

Optional

System.Management.Automation.PSCredential

Internal use only.

WhatIf

Optional

System.Management.Automation.SwitchParameter

Displays a message that describes the effect of the command instead of executing the command. For more information, type the following command: get-help about_commonparameters

Project Server 2013 has only a single database per Project Web App instance. This command converts the four Project Server 2010 databases into a single Project Web App database. It combines the Draft, Publish, Reporting, and Archive database into a single database to be used with Project Server 2013.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft