A full Technopedia catalog sync is a synchronization process that performs a full catalog download instead of the incremental update normally done during a regular/delta catalog sync. This may be helpful, as sometimes updates are made that do not reflect in your catalogs. A full catalog sync will complete the update.
To force a full Technopedia catalog sync, follow the steps below.
update BDNA.dbo.TECHNOPEDIA_VERSIONS set PKG_ID=-1 where _src='TECHNOPEDIA';
After running the Technopedia catalog sync, the full catalog will be downloaded and synced with your system.
NOTE: As this is a full catalog sync, it will take longer to complete than a regular/delta catalog sync.
on
Aug 08, 2019
03:45 AM
- edited on
May 31, 2024
10:34 AM
by
HollyM
For me, running SQL Server 2019 and SQL Service Management Studio 18,
this command required double quotes around the "_src" in order to work.
So the command is:
update BDNA.dbo.TECHNOPEDIA_VERSIONS set PKG_ID=-1 where "_src" = 'TECHNOPEDIA';