locked
movement of Site collection from one content DB to another RRS feed

  • 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).aspx

    Paul 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.

    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"


    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