I am attempting to replicate data from a Dynamics 365 instance to a Azure SQL Server database. I also want to schedule the package to run every 30 minutes to get new or change data replicated.I am recieving the following error messages. The database and tables are already created on SQL Server. Is it better to allow Skyvia to create the tables and schema initially? Does Incremental Updates have to be selected in order for Skyvia to pick up changed or modified data?
Failed to get the schema from data source. Detailed error messages are: Invalid object name 'roletemplate'.
Failed to get the schema from data source. Detailed error messages are: Invalid object name 'interprocesslock'.
The source object 'accountleads' does not have 'modifiedon' column and cannot be used when the 'Incremental Updates' check box is selected.
In error number three the 365 Dynamics Entity does not use modifiedon at the field that records the changes. The record creation field is SinkCreatedOn and the date/time change value is saved in SinkModifiedOn. SinkModifiedOn is standard throughout the entire schema. How can I make Skyvia replication use SinkModifiedOn as the date the record has been changed? Also, to pick up new records Skyvia has to use SinkCreatedOn.