deploymeny very slow

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

deploymeny very slow

Postby angusbeare » Mon Aug 19, 2013 12:41 pm

Hi

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?

thanks
Gus
angusbeare
 
Posts: 2
Joined: Mon Aug 19, 2013 12:34 pm

Postby angusbeare » Mon Aug 19, 2013 12:44 pm

never mind

I think there was a random internet bottle neck or something.

seems ok now
angusbeare
 
Posts: 2
Joined: Mon Aug 19, 2013 12:34 pm


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests