Sunday, April 14, 2013

Exporting and Importing between Farms

The management shell is the only way to import a site without, restoring from a backup, or recovering data from an unattached database.

Here’s what you do to copy sites around:

login into your source server with an account that has WSS_Admin_WPG (content db where site resides), SharePoint_Shell_Access (config db and Admin db), and SA (SQL Server role) on the Backend database.

Open the management shell as an admin

enter this command, where the URL is the URL to the site you wish to export, complete with all users, versions, and security settings:

Make sure the path is a shared location.

Export-SPweb URL -Path e:\thisIsWhere_Istore_my_contentMigrationpackage\filename_of_contentMigrationPackage.cmp -includeusersecurity -includeversions All -noFileCompression

copy the .cmp file (Note: I’m not sure if .cmp stands for content migration package; but that’s what it seems to do.)

over to the target server, and into a shared path, a path that is shared out to the account that you used to export the SharePoint web.

Create a blank site, based on the custom site template known as… wait for it… “Select Template Later”

That step is key, unless you know the exact template that the source site was built from, you should select the “< Select Template Later>” off the custom tab

Now on the target server, logged in with an account that is a member of the local group WSS_Admin_WPG and SA on the Backend database run this:

Import-SPweb URL -Path e:\PathToWhereICopiedTheCMP\NameOfCMP.cmp -force -includeUserSecurity - noFileCompression -updateVersions append

No comments:

Post a Comment

Thanks for commenting, if you have a question and want a reply, please post it on TechNet forums and reference this blog, or navigate to and post it there, all of these blog posts and more are on my SharePoint Papa site.

Popular Posts