You’re offline. This is a read only version of the page.
1,965
Hi,
So i know when i first enable change tracking and create a data project with incremental push. Then the first export will contain everything then it will start just exporting new data.
However, i noticed sth that didn't hapoen before.. I deleted the data project and recurring data job then i created them again but it didn't export everything the first time.. I waited for a new record to be created? Shouldn't it start from scratch when i delete the project? Or am i missing sth?
Hi IntegrationBeginner,
When you delete the data item, BYOD will not synchronize the data if the data is not changed from D365FO.
Please read the document about how it works:
docs.microsoft.com/.../about-change-tracking-sql-server
You could also use the script to check which tables in the database have change tracking enabled.
SELECT sct1.name AS CT_schema, sot1.name AS CT_table, ps1.row_count AS CT_rows, ps1.reserved_page_count*8./1024. AS CT_reserved_MB, sct2.name AS tracked_schema, sot2.name AS tracked_name, ps2.row_count AS tracked_rows, ps2.reserved_page_count*8./1024. AS tracked_base_table_MB, change_tracking_min_valid_version(sot2.object_id) AS min_valid_version FROM sys.internal_tables it JOIN sys.objects sot1 ON it.object_id=sot1.object_id JOIN sys.schemas AS sct1 ON sot1.schema_id=sct1.schema_id JOIN sys.dm_db_partition_stats ps1 ON it.object_id = ps1. object_id AND ps1.index_id in (0,1) LEFT JOIN sys.objects sot2 ON it.parent_object_id=sot2.object_id LEFT JOIN sys.schemas AS sct2 ON sot2.schema_id=sct2.schema_id LEFT JOIN sys.dm_db_partition_stats ps2 ON sot2.object_id = ps2. object_id AND ps2.index_id in (0,1) WHERE it.internal_type IN (209, 210) ORDER BY Tracked_Name
Share
Report
All responses (
Answers (
