Asked by:
movement of Site collection from one content DB to another

Question
-
Hi All,
I have to move two site collections to an another content database.
can anyone list all the possible ways to perform this task.
2 nd Thought: What if i create a new site collection with a different url, and start moving content from older one to new one by import and export. when everything is moved, then can we delete the old one and rename the new one as the older one. (Is it possible).
Ex.
1.Suppose i have an old site collection that is www.abcd.aspx (I have to move content of this site collection)
2. Then i go to the new content db and create a new site collection there. say (www.abcde.aspx)
3. Then i start import / export to move the content from "abcd" to "abcde"
4. When everything is moved , go to the abcd and delete it.
5. Then go to www.abcde.aspx and rename it as www.abcd.aspx
Suggest ..
- Moved by Emir Liu Thursday, June 20, 2013 7:05 AM
Tuesday, June 18, 2013 4:26 PM
All replies
-
The easiest way is to use Move-SPSite in PowerShell on the server. you can also use Backup and Restore. See here for Move-SPSite:
http://technet.microsoft.com/en-us/library/cc825328(v=office.14).aspxPaul Stork SharePoint Server MVP
Principal Architect: Blue Chip Consulting Group
Blog: http://dontpapanic.com/blog
Twitter: Follow @pstork
Please remember to mark your question as "answered" if this solves your problem.- Proposed as answer by Pratik Vyas Wednesday, June 19, 2013 2:52 AM
- Unproposed as answer by Hemendra AgrawalModerator Wednesday, June 26, 2013 8:43 AM
Tuesday, June 18, 2013 4:44 PM -
Hello
It would be much simpler to just backup the site and restore it:
Backup-Spsite / Restore-Spsite
http://technet.microsoft.com/en-us/library/ff607901.aspx (backup)http://technet.microsoft.com/en-us/library/ff607788(v=office.14).aspx (restore)
Once you've verified, delete original site
Import/export would work too. import/export can get more granular if necessary.
MCITP-EA | "Never test how deep the water is with both feet"
- Edited by ThatGuyRyan Tuesday, June 18, 2013 4:46 PM
- Proposed as answer by Pratik Vyas Wednesday, June 19, 2013 3:54 AM
- Unproposed as answer by Hemendra AgrawalModerator Wednesday, June 26, 2013 8:43 AM
Tuesday, June 18, 2013 4:45 PM -
The best and correct way to do this would be to use central admin to create a new content database.
Goto central admin > application management > manage content databases
create a new content database
then in sharepoint powershell - use
Move-SPSite .<<a href="http://servername/sites/sitename>">http://servername/sites/sitename> -DestinationDatabase <<NewContentDb2>>
ALWAYS REMEMBER TO DO AN IISRESET AFTERWARDS.
Andy Reeves
Tuesday, June 18, 2013 7:31 PM -
Hi,
If your goal is move the sitecollection to a dedicated or different content database on the same webapplication then you can use Move-SPSite
If you are taking about moving from webapplication to another then the possible option is to use the powershell commands
backup-spsite and restore-spsite
Regards Murali
Tuesday, June 18, 2013 9:40 PM -
Hi All,
I am sorry, i forgot to mention it is in..SP 2003..
Wednesday, June 19, 2013 10:02 AM