deploymeny very slow

angusbeareangusbeare Posts: 3

I want to sync two databases. The first from production which is not particularly large with one that is identical in objects but empty.

I created the new DB on the target and synced the SQL compare 10.

When I run data compare 10 the comparison doesn't take too long but the deployment has been runing for nearly half an hour now and is only at 29%.

I am wondering why it is so slow? What is it doing to take so long? If I use a backup I can restore in seconds and a massive insert script takes just minutes.

Surely, data compare should just be running a script to insert? Then why is it so slow?

Am I doing something wrong?



Sign In or Register to comment.