What are the challenges you face when working across database platforms? Take the survey
Options

SQLDataCompare.exe get stuck

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.
Tagged:

Answers

  • Options
    @JDP

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

    Thanks!
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
  • Options
    JDPJDP Posts: 2 New member
    edited November 6, 2020 11:54AM
    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
  • Options
    Tianjiao_LiTianjiao_Li Posts: 684 Rose Gold 5
    edited November 11, 2020 3:28PM
    Thanks for your reply!

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

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
  • Options
    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!
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.