?
Solved

Opinions on Red-Gate SQL Data Compare Tool

Posted on 2006-11-08
6
Medium Priority
?
599 Views
Last Modified: 2012-08-13
We are considering using a tool from Red Gate called SQL Data Compare for keeping four databases in sync.

I was at a Microsoft seminar last night which was being sponsored by Red Gate, so I asked them about the performance of SQL Data Compare, I said something like "do you have any figures for what volume of data it can support?" - first reaction:

"volume isn't one of its strong points"

I tried to press them that I wasn't looking to sync millions of transactions, I just wanted some idea of what it would be reasonable to expect from the tool, but the two people I was speaking to were both very cautious about it - "use where clauses to limit the data being loaded", "there is a lot of discussion about this on the newgroups, take a look at them", "there are really too many variables to give any figures".

I don't understand why they are so cautious. I had a look at product reviews for the tool - using Google - and they all appear very positive. Can anyone who uses the tool regularly give any rough figures for the amount of data it will process in a given period?

0
Comment
Question by:purplesoup
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 28

Expert Comment

by:imran_fast
ID: 17897823
>>Can anyone who uses the tool regularly give any rough figures for the amount of data it will process in a given period?

Hi,

I nerver used regdate to compare transaction data only the lookup tables and few of configuration tables the data in those tables are limited may be in thousand and performance was good so the point is
if you  are trying to synch two servers transactional data (huge as compared to lookup and configuration data) you should use one of sql functionality like Replication, Mirroring or LogShipping.

Regards

Imran
0
 

Author Comment

by:purplesoup
ID: 17898086
We can't mirror the whole database, some of the data will need to be different, only selected tables will be affected, but this will include some transactional data as well as lookup and configuration data.
0
 
LVL 28

Expert Comment

by:imran_fast
ID: 17898119
>>only selected tables will be affected, but this will include some transactional data as well as lookup and configuration data.

Then use replication for selected tables only.
0
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 

Author Comment

by:purplesoup
ID: 17898251
It seems it is going to be awkward having two replication mechanisms running for different parts of the data against multiple databases. You say you haven't tried using Red Gate for transaction data yet you seem to rule out using it - is this because you initially tested it for transactional data and found it wasn't suitable? I find the Red Gate UI very simple to use and if the tool can do it I would prefer to do all replication through it.
0
 
LVL 28

Accepted Solution

by:
imran_fast earned 2000 total points
ID: 17898404
No I haven’t tired that on transactional data. See the problem is replication is also keeping track for data changes and it will apply on the changes from the primary server to the secondary server. Imagine you have a table Work order and you might have millions of records in it so if you compare each record in two servers for this table it will take hours. So usually in real time environment we just check for certain block of data. As those guys from red gate suggested use the where clause.
0
 

Author Comment

by:purplesoup
ID: 17898471
OK - that makes sense - getting SQL Data Compare to continually compare all the data in very large tables is where the bottleneck is. I was thinking it would just remember changes made since the last update, not do a full compare - this all makes sense now -  "volume isn't one of its strong points" etc.

So if I had four databases I wanted to keep in sync this would actually be quite difficult because it would need to have some schedule to keep comparing different databases in order to identify the changes.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question