How can we help you today? How can we help you today?

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.
JDP
0

Comments

4 comments

Sort by
  • Tianjiao_Li
    @JDP

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

    Thanks!
    Tianjiao_Li
    0
  • 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
    JDP
    0
  • 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
    0
  • 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!
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.