SharePoint 2010 Migration – Using Database attach method

PRE REQUITES

1) Make sure you have enough free disk space for Data/ Back up and Log files on the destination SQL server.
2) Granted DB Owner rights to SharePoint 2010 Install Account on all the Existing/Migrated Content database

COPY/RESTORE CONTENT DATABASE

Copy 2007 Content Database back up copy to the new SQL server.
Restore the Databases in the new SharePoint 2010 SQL environment.
VERIFYING THE CONTENT DATABASENext step is to verify the Content Database using Test-SPContentDatabase Windows PowerShell cmdlet
This cmdlet will test and verify that any custom components that are required for this content database has been installed and configured in the SharePoint 2010 environment.

Test-SPContentDatabase –Name <database name> -WebApplication <URL>

Launch the SharePoint 2010 Management Shell and type the above command, ensuring you have entered your
Information

1) Make sure you have enough free disk space for Data/ Back up and Log files on the destination SQL server.

Test-SPContentDatabase –Name WSS_Content_ABC -WebApplication http:/abcpoint


Review and Resolve the issues if any.

MOUNT CONTENT DATABASE
Next step is to mount the Content Database using Mount-SPContentDatabase Windows PowerShell cmdlet
This cmdlet will mount/Attach content database to the web application.

Mount-SPContentDatabase -Name "WSS_CONTENT_XYZ" -DatabaseServer "SQLSERVER" -WebApplication http://abc/

Review and Resolve the issues if any.