comparing remote database / speed issues

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

comparing remote database / speed issues

Postby alexschmidt » Fri May 25, 2012 12:57 pm

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
alexschmidt
 
Posts: 1
Joined: Fri May 25, 2012 12:47 pm

Postby Chris Auckland » Mon May 28, 2012 3:15 pm

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
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests