Red Gate forums :: View topic - deploymeny very slow
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare 10
SQL Data Compare 10 forum

deploymeny very slow

Search in SQL Data Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
angusbeare



Joined: 19 Aug 2013
Posts: 2

PostPosted: Mon Aug 19, 2013 12:41 pm    Post subject: deploymeny very slow Reply with quote

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
Back to top
View user's profile Send private message
angusbeare



Joined: 19 Aug 2013
Posts: 2

PostPosted: Mon Aug 19, 2013 12:44 pm    Post subject: Reply with quote

never mind

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

seems ok now
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group