0

I have a SharePoint 2010 site on a test server and database. I would like to move my site to a production server and a new SQL instance. What is the best way to do this?

Was really easy, here are the PowerShell commands for exporting and importing.

Export-SPWeb -Identity http://OLDSITE/ -Path \\SERVER\backup\sharepoint\SiteExport.cmp -IncludeUserSecurity -IncludeVersions All -Verbose 


Import-SPWeb -Identity http://NEWSITE/ -Path \\SERVER\backup\sharepoint\SiteExport.cmp -Verbose -Force
Improve this question

1 Answer 1

Reset to default
1

Unless you installed sharepoint using a SQL Alias you will need to create a DNS alias/host file with the old name of the SQL server that points to the new one, and the instance name will need to be the same.

  • Stop SharePoint
  • Backup the databases on the old database server
  • add logins to the new server with sysadmin rights
  • script out SharePoint jobs from old database server
  • rename old database server
  • create DNS alias that point old database server name to the new database server name
  • restore database backups to the new database server
  • run job script on new database server
  • restart SharePoint after a ping resolves the old name to the new server (use ipconfig /flushdns to force update)
Improve this answer
1
  • Edited question to include solution. Commented Jul 22, 2010 at 13:43

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.