Allow bulk insert when first populates data to target database
It took over 10 hours to move 6GB of data to target database on the first synchronization. When I used SQLAzureMW, it took less than hour.
Data Sync team is planning to improve initial synchronization performance by using bulk insert and other optimization techniques.
Then how will you handle the _Tracking tables after first sync (Using SQLAzureMW) because in the next sync it will again go for the Full table sync.
I am getting the Same Issue :
Synchronization took approximate 17 Hrs to on the first Synchronization, Total number of records moved to Cloud DB was 1305538.
Here is the Table Info :
Number of Columns 184
Row Size in in Byte 234181
It would be nice if we can snapshot data on first synchronization.