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.