locked
Site Migration from MOSS 2007 to MOSS 2010

    问题

  • Presently our client have the MOSS 2007 Portal and they want to migrate those sites in to MOSS 2010. So, We need to show case something to that client. Please anyone have idea on the same, please let us know. It's very urgent.

    Thanks in advance..

    Regards,
    Pradeep Seella

     

    • 已移动 Mike Walsh FIN 2009年12月24日 11:57 2010 questions go to 2010 forums. Please in future post them directly there. (From:SharePoint - Setup, Upgrade, Administration and Operation)
    2009年12月24日 11:15

全部回复

  • Here is my case

    Install and configure SharePoint 2010, on a new environment

    -          Determine hardware and software requirements (SharePoint Server 2010) http://technet.microsoft.com/en-us/library/cc262485(office.14).aspx

    -          Planning Logical architecture components http://technet.microsoft.com/en-us/library/cc263121(office.14).aspx

            -       deployment guide for Microsoft SharePoint Server 2010 http://technet.microsoft.com/en-us/library/cc262957(office.14).aspx

    After installing and configuring your new SharePoint 2010,

    Moving Content Database from SP 2007 to SP 2010

    1) Find the content Database; These are listed under Central Admin->Application Management->Site Collection List

    2) Backup the content database, You could alternatively detach it, and copy it. Just doing a backup in SQL Server Management studio is easier.

    3) Restore content database to new server, Copy the BAK file to new server. Create an empty DB in Management Studio, restore from backup, you may need to change an option in the "options" tab of the restore dialog to get it to work. (Overwrite db).

    4) Create Web App on SharePoint 2010

    5) Remove Content Database from the new web app.

    Now use STSADM to add restored DB to this web app

    c:\program files\common files\microsoft shared\web server extentions\14\bin on new server is where you can find the STSADM.

    run this command from there. Which will upgrade the content db to 2010?

    stsadm -o addcontentdb -url http://yourwebapp:port -databasename yourcontentdb -databaseserver yoursqlserver

    6) Run ISSRESET from command prompt

     


    Best Regards, Ammar MCT
    • 已建议为答案 Panjain 2010年1月19日 21:32
    2009年12月24日 11:32
  • Dear Ammar,

    Thanks for your Quick reply and support.


    I have followed the above all steps for Portal Migrating. But While attaching the Database I am getting following error:

    "Invalid object name 'Sites'

    Please let me know do you have any solution regarding this.

    Thanks in advance..

    Regards,
    Pradeep Seella

    2009年12月29日 6:26
  • I believe you missed one or more of the preparation steps before moving the 2007 content database. You need to be sure the 2007 farm is running SP2 or later (version 12.0.6421 == 2007 SP2). Run the preupgradecheck command on the 2007 farm before doing the backup. That doesn't change anything, it just alerts you of issues.

    If you do all the steps in the preceding links, the upgrade will work and go relatively smoothly. There just aren't any shortcuts.

    Jeff

    • 已建议为答案 Panjain 2010年1月19日 21:31
    2009年12月31日 20:11
  • Hi Pradeep,

    I am somehow agree the steps mentioned by ammar but he has missed certain steps. If you have deployed any custom componemt in moss 2007 like custom master pages, site definition then your site cannot be blowed up. So I will suggest firstly deploy the custom component in 2010 which you have already deployed in 2007 then follow above steps. Your application will working in the same way as in 2007. If still you face difficulties then let me know what issue you are facing.

    Regards,

    Pankaj Jain

     

    2010年1月19日 21:40
  • Hi Pradeep,

    I have been able to successfully upgrade my MOSS 2007 Portal to SharePoint 2010. The steps that i performed are similar to steps given by Ammar. I have also written about the steps using which i successfully upgraded my MOSS 2007 portal. You can find them here How to Upgrade to SharePoint 2010 using Database Attach method

    Hope it helps!!


    ____________________________________________________________

    Best regards , Anshul Sehgal MCP

    My Blog : Anshul's SharePoint Blog
    2010年1月21日 7:43
  • I think you didn't install the service pack in your old SharePoint 2007 farm, I wrote all the steps and how to validate your old database before doing the migration, I hope it will help.

    http://randombase.blogspot.com/2010/02/how-to-upgrade-moss-2007-site-to-moss.html
    2010年2月27日 12:31
  • Hi ,

    I have sql server 2008, I am not able to take back up of content database becaue I don't have password for SA user.

    I can only view content database by Windows Authentication.

    My SQL Server 2008 Instance for SharePoint is "ServerName\OfficeServers".

    Can you please let me know password of sa user.


    G. Goyal
    2010年3月22日 9:45
  • Hi,

    You can use the same Windows username to have the administration privileges and take your file by following below steps:


    To add a Windows user that has the login "machinename\Administrator" to the sysadmin fixed server role

       1.      Log on to the computer using the credentials for the machinename\Administrator account.
       2.      Click the Start button, point to All Programs, click Microsoft SQL Server, and then click SQL Server Management Studio.
       3.      Connect to an instance of SQL Server.
       4.      Click Security, right-click Logins, and then click New Login.
       5.      In the Login name box, enter the user name.
       6.      In the Select a page pane, click Server Roles, select the sysadmin check box, and then click OK.

     To add a normal Windows user that has the login "domainname \username" to the sysadmin fixed server role

       1.      Log on to the computer using the credentials for the domainname\username account.
       2.      Click the Start button, point to All Programs, click Microsoft SQL Server, right-click SQL Server Management Studio, and then click Run as administrator.
         
    Note: The Run as administrator option elevates the user permissions.

       3.      In the User Access Control dialog box, click Continue.
       4.      In SQL Server Management Studio, connect to an instance of SQL Server.
       5.      Click Security, right-click Logins, and then click New Login.
       6.      In the Login name box, enter the user name.
       7.      In the Select a page pane, click Server Roles, select the sysadmin check box, and then click OK.

    For all the details check this link http://msdn.microsoft.com/en-us/library/bb326612.aspx

    Please let me know if this helps.

    • 已建议为答案 Mac SP 2010年8月31日 11:30
    2010年3月22日 10:40
  • Thanks for your reply.

    We have not installed this instatance "Server\SharePoint". This instance is installed when sharepoint 2010 is installing on server.

    We have tried lots of thing to add an administrative user in this instance but we are not able to add.

    Can you you suggest what could be default password for SA user for this instance.

    I mean when I am installing sharepoint 2010 then It will automatically install sql server & creating new instance for sharepoint ,

    administrator of that server is also not able to create any user or not able to change sa password or not able to take back up or resotore any database.

    Please help.

     

     


    G. Goyal
    2010年3月22日 13:23
  • Hi,

    I hope this link can help, http://support.microsoft.com/default.aspx/kb/322336?p=1

    Regards,
    Hassan

    2010年3月22日 13:33
  • To run this command I have be an administrator or special rights in sql server but on this SQL Server Instance our domain administrator also have no rights.

    By which login This sharepoint default instance is installed on this server?

     


    G. Goyal
    2010年3月22日 13:47
  • Please answer.

    Is any other way to Migrate a Single Site (Which can have multiple sub-sites and other Items) of SharePoint 2007 To SharePoint 2010?


    G. Goyal
    2010年3月22日 14:18
  • Hi,

    even if you are not an administrator you can add your self by following below steps,

       1.      Log on to the computer using the credentials for the domainname\username account.
       2.      Click the Start button, point to All Programs, click Microsoft SQL Server, right-click SQL Server Management Studio, and then click Run   as administrator.

         
    Note: The Run as administrator option elevates the user permissions.

       3.      In the User Access Control dialog box, click Continue.
       4.      In SQL Server Management Studio, connect to an instance of SQL Server your Server/Sharepoint in your case.
       5.      Click Security, right-click Logins, and then click New Login.
       6.      In the Login name box, enter the user name.
       7.      In the Select a page pane, click Server Roles, select the sysadmin check box, and then click OK.

    As per what mentioned in my first links this will work even if you are not Administrator in SQL but you must be an administrator on the server that hosts SQL server.

    Also regarding the SA default password, I believe it will be blank or SA try both, but I think the Mixed mode is not enabled by default.

    Regards,

    Hassan

    • 已建议为答案 Mac SP 2010年8月31日 11:31
    2010年3月22日 14:40
  • Hi,

    even if you are not an administrator you can add your self by following below steps,

       1.      Log on to the computer using the credentials for the domainname\username account.
       2.      Click the Start button, point to All Programs, click Microsoft SQL Server, right-click SQL Server Management Studio, and then click Run   as administrator.

         
    Note: The Run as administrator option elevates the user permissions.

       3.      In the User Access Control dialog box, click Continue.
       4.      In SQL Server Management Studio, connect to an instance of SQL Server your Server/Sharepoint in your case.
       5.      Click Security, right-click Logins, and then click New Login.
       6.      In the Login name box, enter the user name.
       7.      In the Select a page pane, click Server Roles, select the sysadmin check box, and then click OK.

    As per what mentioned in my first links this will work even if you are not Administrator in SQL but you must be an administrator on the server that hosts SQL server.

    Also regarding the SA default password, I believe it will be blank or SA try both, but I think the Mixed mode is not enabled by default.

    Regards,

    Hassan

    2010年3月22日 14:41
  • there are some alternatives, you can switch sql server off and copy the database files manually instead of doing backup/restore, then you can attach these files in your SharePoint 2010 SQL.
    2010年3月22日 14:43
  • Thanks,

    It is working now. Now I am able to log on to sql server.

    Thanks again.


    G. Goyal
    2010年3月23日 5:19
  • Hi 

    Thanks for the process, it worked but i am asking dumb question, what about the UI, will it reflect the New UI or the old moss UI. When i migrated i got the old UI not new one, i don't know if i missed something here?

    2010年4月16日 20:46
  • Sorry i am really dumb, now i got the new UI, in site action there is an option to change visuals and now i have new UI.
    2010年4月16日 20:50
  • Hi Ammar,

     

    Is there any microsoft migration tools for Site Migration from MOSS 2007 to MOSS 2010 (not database attach dettach method) or is their any other solution to do this please help me as it is urgent...

     

    Regards,

    Anil

     

    2010年4月26日 6:59
  • Hi Anil,

    It is not the issue of Site Migration, it is all about upgrade

    When you perform a database attach, in fact you perform a database attach upgrade which means this will do upgrade and attach in one action

    for Microsoft refrence about Perform a database attach upgrade

    • Prepare the new SharePoint Server 2010 environment for a database attach upgrade
    • Attach databases and upgrade to SharePoint Server 2010

    http://technet.microsoft.com/en-us/sharepoint/ee517214.aspx

     


    Best Regards, Ammar MCT http://ahmed-ammar.blogspot.com Posting is provided "AS IS" with no warranties, and confers no rights.
    2010年4月26日 17:29
  • Thanks! Your instructions/steps worked out very well for my migration of moss 07 to moss 10.
    2010年5月27日 21:13
  • Hi,

     

    In your steps..."After installing and configuring your new SharePoint 2010"

    Must i install and run the config wizzard afterwords?

    Thanks

    2010年7月21日 9:56
  • Ahmed,

    I am confused in data base attach migration method for the follwoing scenario .Can you please give me clarity? it is urgent.

    We have a production system in wss3.0. I took  backup of the content database using sql servr management studio tool.

    Can I restore this content DB to a test environment ( on sun Virtual box with 'windows 7' 64-bit host OS) and from test env't to new production system? 

    If my testing is done and ready to move to new production system then How can I add the data accumulated during testing period (one month) to new prod'n system from wss3.0 system.

    Best regards,

    2010年9月5日 21:48
  • Hi -

     

        We have applied all the steps you have mentioned and content database was restored successfully but beside this content database we have backup of this site from SP 2007 and we need also to restore the site to SP 2010.

     

    i have notice that you have created a new web application but in our case we have already exiting site @ SP 2007 and we need to restore it to SP 2010.

     

    Could anyone help us to solve this issue as our work is totally pending on it?

     


    Maylo
    2010年10月7日 9:35
  • Hi Pradeep,

     

    you can find the entire steps of migrating a SharePoint 2007 Site from SharePoint 2010 from this link.

    http://appsense.logimindz.com/?p=37

     

    Let me know if you Face any problem and I will be happy to assist you on this.

    Deepak Sinha

    deepak@logimindz.com

    www.logimindz.com

     


    Deepak Sinha Logimindz Technologies Pvt. Ltd. www.logimindz.com
    2010年12月2日 9:11
  • Site converted to SharePoint 2010 cannot be opened in SharePoint Designer 2010. I am confused what should i do to open it in Designer. Also is it possible??
    2011年3月4日 9:49
  • Hi Fahad,

    Yes, you can open the migrated site in sharepoint designer 2010. Sometimes you are unable to open the site in sharepoint designer because your home page contains web parts. You can open the page in your browser with ?contents=1 then it will display all the web parts. The web part which show error remove that one and try to open the site in designer then it will open without any issue. if you still face an issue then let mw know what exact issue you get.

    Thanks,

    Pankaj jain

    2011年4月6日 9:19
  • Hi,

    When you migrate to SharePoint 2010 using database attach method, does this process create the user groups and permissions in sharepoint 2010?

    I have installed SharePoint 2010 on a new server and need to copy a 2007 site from another server to the new server. Please let me know the correct steps? Do i first need to create the users on the new server ?

    2012年1月17日 5:33
  • Hi Deepak ,

    I am not able to open the URL given by you....

    Thanks,

    LP

    2012年7月2日 6:32
  • yes... as per my knowledge you need to create users first....

    Thanks


    • 已编辑 ANIL M 2012年8月27日 10:17
    2012年8月27日 10:16
  • HI, Anshul 

    Please provide your method which has minimum downtime on my id please d.yevle@gmail.com 


    Regards, DYevle [MCTS]

    2012年8月28日 4:27
  • SharePoint Migration is a complex process and has multiple stages starting from Planning to Post migration fixes.  Use this guide to Migrate from MOSS 2007 to SharePoint 2010:

    Migrate from MOSS 2007 to SharePoint 2010 - Step by Step
    2013年7月30日 14:51