Offline sync service: check if data sync is in process

Sometimes when Offline Sync Service is syncing a large table (with a lot of data), it’s interesting to check the status of sync – to validate how many records have been already inserted. For this we can execute Uncommitted read in SQL Management Studio:

set transaction isolation level read uncommitted

begin transaction;

SELECT COUNT(*) FROM [AxRetailPOS_OfflineDB].[ax].[MY_TABLE_NAME]

SELECT COUNT(*) FROM [AxRetailPOS_OfflineDB].[ax].[INVENTTABLE]

SELECT COUNT(*) FROM [AxRetailPOS_OfflineDB].[ax].[CUSTTABLE]

SELECT COUNT(*) FROM [AxRetailPOS_OfflineDB].[ax].[ECORESPRODUCT]

SELECT COUNT(*) FROM [AxRetailPOS_OfflineDB].[ax].[PRICEDISCTABLE]

commit transaction;