Attach dei DB di Project Server (SharePoint)

Questo script in PowerShell 2 permette di agganciare il content DB della PWA e gli altri 4 database di Project Server 2010 (Archive, Draft, Published e Reporting) a SharePoint Server 2010

PowerShell: AttachProjectDb.ps1

$instancedb = "sharepointDB\CONTENT"

$url = "http://sharepoint2010"
$urlPWA = "http://sharepoint2010/PWA/eps03"
$AdminAccount = "DOMINIO\utente_Farm"
$contentdb = "MOSS2007_PWA_Content"

$contentArchive = "MOSS2007_PWA_Archive"
$contentDraft = "MOSS2007_PWA_Draft"
$contentPublished = "MOSS2007_PWA_Published"
$contentReporting = "MOSS2007_PWA_Reporting"

$ErrorActionPreference = "Stop"

Mount-SPContentDatabase -Name $contentdb -DatabaseServer $instancedb -WebApplication $url 

New-SPProjectWebInstance -Url $urlPWA  -AdminAccount $AdminAccount -PrimaryDbserver $instancedb -PublishedDbname $contentPublished  -ArchiveDbname $contentArchive -DraftDbname $contentDraft -ReportingDbserver $instancedb  -ReportingDbname $contentReporting
l'esecuzione del comando da un output simile al seguente

DOS / Batch file

100,00%

Id               : 5ea86651-5270-4e2f-b6e5-d85d8f6af5f2
Name             : MOSS2007_PWA_Content
WebApplication   : SPWebApplication Name=sharepoint2010
Server           :"sharepointDB\CONTENT
CurrentSiteCount : 1

Creation of PWA site queued
Può essere utilizzato per migrare i DB da Project Server 2007 a Project Server 2010
Tags:
Database75 Project Server12 SharePoint498 SharePoint 2010224
Potrebbe interessarti anche: