SQLDataCompare.exe get stuck

JDP

Hi,

Using command line to synchronize 20Gb of data between two databases with exact same schemas, the process get stuck at the end of the comparison task step.

Here is the last entries of the logs  : 

  10:08:39.309|Debug  |SQL Data Compare Eng|12 |Comparison task has successfully finished

  10:08:39.309|Verbose|SQL Data Compare Eng|12 |Finished analyzing mapping

  10:08:39.309|Verbose|SQL Data Compare Eng|12 |Mapping cleanup complete
  10:08:42.340|Info   |PFUR                |6  |Sending 1 event: ...

  10:08:42.527|Info   |PFUR                |6  |Usage reporting request made to https://featureusage.red-      gate.com/v1/usageevents

    Number of submitted usage events = 1

    HTTP status code = 200 OK

    Response body =

When monitoring with Process Monitor, i can see that when stuck, the process only does Thread Create and Exit, no disk or network access whatsoever.

CPU and Memory usage stay low,
Il let the process run for 5 days with no result.

Tianjiao_Li

@JDP

Could you confirm the full version number of your SQL Data Compare as well as your SQL Server?

Thanks!

JDP

Hello,

SQL Data Compare Command Line : V14.4.4.16824
Microsoft SQL Server Enterprise (64-bit) : 2016 SP2 (13.0.5026.0)

The computer running SQLDataCompare :
OS : Windows Server 2016 Standard x64
Processor : Intel Xeon E5-2660 v3 @2.6GHz with 2 logical processors allowed
Memory : 8 Gb

Tianjiao_Li

Thanks for your reply!

I'll check it with the development team but we may need to review the whole log.

Tianjiao_Li

The development team said 20GB is huge and SQL Data Compare is not really designed to sync entire databases like this size. 
- Have you run out of disk space?
- What are you trying to achieve?
- Have you tried to select a subset of tables to sync?

Thanks!