Red Gate forums :: View topic - comparing remote database / speed issues
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product support center
SQL Compare 10
SQL Compare 10 forum

comparing remote database / speed issues

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



Joined: 25 May 2012
Posts: 1
PostPosted: Fri May 25, 2012 12:57 pm    Post subject: comparing remote database / speed issues Reply with quote
Our DB got around 4000 Objects in total.

syncing our Database in the local network takes around 1min.

trying to sync to our remote-database (latency 300ms) takes
forever, around 30-40 min.

is there any best-practise in comparing/syncing towards remote-dbs?

any help would be much appreciated
Alex
Back to top
View user's profile Send private message Send e-mail
Chris Auckland



Joined: 24 Oct 2006
Posts: 710
Location: Red Gate Software Ltd.
PostPosted: Mon May 28, 2012 3:15 pm    Post subject: Reply with quote
Thanks for your post.

There isn't much you can do to speed up the comparison, unfortunately.

What you might like to try would be to take a SQL Compare snapshot of the source schema, and then copy it over to the remote site. You can then do the sync' locally on the remote site. This should help if the problem is with communication over the WAN.

I hope it helps.
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
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