Comparing data across two databases

Hi,
I have two identical databases (Production and Testing) sitting in different
servers (Server A and B) .
Is there anyway to compare data between these databases at all? More
particularly, I want to compare data in 20 tables from above databases and
identify any difference.
Is this possible at all? Can someone help please?
Harish Mohanbabu
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/
Harish,
There are some great 3rd party tools that can accomplish this. I use the
ones offered at http://www.red-gate.com.
Shaun McDonnell
"Harish Mohanbabu" <Axapta@.online.nospam> wrote in message
news:70D2B1D3-2A33-45F0-A632-B1B4BEAAAA82@.microsoft.com...
> Hi,
> I have two identical databases (Production and Testing) sitting in
> different
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/
|||Look up the tablediff utility in Books Online...
..."TableDiff was intended for replication but can easily apply to any
scenario where you need to compare data and/or schema"
(http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx)
"Harish Mohanbabu" wrote:

> Hi,
> I have two identical databases (Production and Testing) sitting in different
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/
|||You might want to use AlfaAlfa's SQL Server Comparison Tool (SCT)
http://www.sql-server-tool.com/
- you can easily compare data in databases located in different
servers. SCT has lot of fine-tuning options, like: ignoring selected
columns or specifying comparison method (record-by-record or primary
key/index comparison).
Comparison "sessions" can be saved and re-played later without need of
re-entering the parameters. Command line parameter can be used to
fully automate comparisons.
Dariusz Dziewialtowski.