How to copy you production SharePoint database to development environment.
I had my production environment as
- SharePoint 2013
- SQL Server 2012
and I want to move the instance to another environment , which is freshly installed and different environment and different KBs
- Share Point 2013
- SQL Server 2016
How to migrate SharePoint 2013 , SQL Server 2012 Content Database to SharePoint 2013 SQL Server 2016.
Method 1.
This is a general method, which is used for upgrading your content database.
1 . Get the back up of the current Content Database
2. Copy SQL backup to new environment
3. Restore the SQL Back Up in to the new environment
4. Go to the Security Login section and grant permission to content database for existing SharePoint Users.
5. You need to select the User mapping and DBO for the content database.
6 Then, execute below PS in SharePoint PowerShell. Make sure you executed as Run as Administrator
7 Firstly, You need to Update the content database.
8. then, mount the using the command line.
Mount-SPContentDatabase -name "WSS_Content " -WebApplication http://stgwfe01/ -confirm:$false
Method 2.
I would recommend this method for only development environment. If any production updates you should follow the proper method which is mentioned in the method 1.
Firstly run below code against your production content database , and find out the version number.
/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP (1000) [VersionId]
,[Version]
,[Id]
,[UserName]
,[TimeStamp]
,[FinalizeTimeStamp]
,[Mode]
,[ModeStack]
,[Updates]
,[Notes]
FROM [Content_Portal].[dbo].[Versions]
and you will be get something like this.
then take the version numbers and update the content database table in the development environment before attaching the database ( You need to skip the point 7)
update [WSS_Content].[dbo].[Versions] SET [Version] = '15.0.138.0'
where [Id] =2
Comments