SQL Server Schema Compare Hanging When Sync Button Pushed

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
negandhi
Posts: 7
Joined: Fri 11 Nov 2016 14:50

SQL Server Schema Compare Hanging When Sync Button Pushed

Post by negandhi » Thu 15 Sep 2022 19:22

Downloaded Schema Compare to trial using a complicated test -> prod deployment and it's always hanging when I choose one particular stored proc and click Synchronize to bring up the wizard (the wizard never shows). The stored proc (named [usp_GetOutOfWorkWithFilter]) isn't particularly long or complicated so I don't know why the app is always hanging.

negandhi
Posts: 7
Joined: Fri 11 Nov 2016 14:50

Re: SQL Server Schema Compare Hanging When Sync Button Pushed

Post by negandhi » Fri 16 Sep 2022 20:04

And now hanging on a simple table. I even tried starting the sync using snapshots.

dzhanhira
Devart Team
Posts: 239
Joined: Mon 26 Oct 2020 13:49

Re: SQL Server Schema Compare Hanging When Sync Button Pushed

Post by dzhanhira » Tue 27 Sep 2022 08:20

Hi,

Thank you for contacting us!

Could you please specify which server, database do you use and the versions of them?

Version of our product? (Check\update to release version)

Provide us with detailed steps (important not to miss anything, even better - record a video).

and DDL Source and Target.

Show please which settings used when syncing.

Also, it's needed a dump and log file.

negandhi
Posts: 7
Joined: Fri 11 Nov 2016 14:50

Re: SQL Server Schema Compare Hanging When Sync Button Pushed

Post by negandhi » Wed 28 Sep 2022 14:52

I went with a different product. Sorry.

Post Reply