change list url in sharepoint 2019 to create duplicate list is an important task for an administrator. When list view threshold of a list is crossing the limit, user want to create similar list with different name. we can copy list items form one list to another list in this situation. We can follow other ways as well as below.

• Export list using powershell and import in UAT. Else we can backup content database and restore using powershell in UAT as well.
• Rename list and change list url in sharepoint using powershell.
• Export list in UAT using powershell and import list in PROD using powershell. Else you can follow recovering list from unattached content database.

Export list using powershell and import list in SharePoint UAT

Follow the blog post export import list library sites in sharepoint to export list from PROD and import in UAT.

Backup content database in sharepoint and restore using powershell in UAT

Follow the blog post dismount Mount content database in sharepoint 2019 using powershell to do back up and restore content database.

Rename list and change url of list using powershell

Once list is moved to UAT, we can use below powershell for list url change. Modifying title of list using UI method will not update the url, it will remain unchanged, So we have to using powershell method change list address.

$liUrlOriginal="/Lists/Budget2020";
$liUrlNew="/Lists/Budget2020Archieved";
$web= Get-SPWeb -Identity http://spmcse-sp19:37985/sites/SPMCSE
$li=$web.GetList($web.Url + $liUrlOriginal)
$rootFolder=$li.RootFolder;
$rootFolder.MoveTo($web.Url + $liUrlNew)

Export list in sharepoint UAT using powershell and import list in PROD

Follow the blog post export import list library sites in sharepoint to export list from UAT and import in PROD. Else you can follow, list recovery method from unattached content database as described below.

Recover list from an unattached content database in sharepoint 2019

You can follow export import list method as mentioned above or you can use recovering a specific list from unattached content database method.

change sharepoint list url completed. Duplicate list or a similar list with reference to another list in same site is created in production environment. Save list as template including content is one of the solution to create duplicate list but there will be error if the number of items is very high, especially for financial sites, we can follow these process.

Follow the video below, to understand better in video format.

Categories: administration, backup restore in sharepoint, content databases, powershell script, SharePoint 2019, sharepoint server, sharepoint templates

Tags: change library url, change list url in sharepoint using powershell, change list url sharepoint, change sharepoint list url, change sharepoint list url name, change sharepoint list url using powershell, change url lists, copy list items to another list sharepoint, copy sharepoint list to another list, create duplicate list, duplicate list in sharepoint, modify list url, move items from one list to another, sharepoint list url, sharepoint powershell copy list items to another list