I wanted to share a SQL script that a colleague of mine created for me. The purpose was to update the Paperless office SQL tables in 2017 after the final go live migration. The go live migration excluded the system files and only migrated company data. A linked server connection was created between the 2017 SQL instance and 2013 instance. The records updated in the source 2013 since the pilot was done a few weeks ago are now appended to the 2017 version. Thankfully the paperless storage folder remains in the same location, therefore no relinking is required.
begin tran
insert [dbo].[PL_JournalPDFLog]
SELECT * FROM [MAS03].[MAS_SYSTEM].[dbo].[PL_JournalPDFLog] where [Filename] not in (select [Filename] from [dbo].PL_JournalPDFLog)
commit tran
In my case the client is only using Paperless for Journal and register storage, if they were saving period end PDFs and reports, then you could use the same script but replace the PL_JournalPDFLog with PL_PeriodEndPDFLog and PL_ReportPDFLog.