Dynamics 365复制-在SQL DEST/增量复制处自动创建表 [英] Dynamics 365 copy - auto table creation at sql dest/incremental copy

问题描述

需要将批量表数据从Dynamics 365云复制到Sql Server.通过复制向导，只有在目的地中创建相同的表定义后，我才能复制单个表.

Need to copy bulk tables data from dynamics 365 cloud to Sql server.  Through copy wizard i am able to copy the individual table only after creating same table definition in destination.

在批量复制过程中，有什么方法可以在目标位置自动创建表结构吗?

Is there any way it can create automatically table structure in destination, while in bulk copy process?

另一个问题，如何创建增量副本动态365表中的数据，每个实体的修改日期都已更改.我已经通过在源代码中创建另一个watermarklookup表看到了从sql到sql的示例，但是在cloud dynamic 365中如何实现 SQL访问受到限制的地方.

Another question, how to create the incremental copy  from dynamics 365 tables and every entity has modified date. I have seen the example from sql to sql through creating another watermarklookup table in source, but in cloud dynamic 365 how to achieve where SQL access is restricted. 

https://docs.microsoft.com/zh-cn/azure/data-factory/tutorial-incremental-copy-portal

https://docs.microsoft.com/en-us/azure/data-factory/tutorial-incremental-copy-portal

推荐答案

感谢有人回答我的查询.

Appreciate if anybody answers my query.

这篇关于Dynamics 365复制-在SQL DEST/增量复制处自动创建表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！