data content comparison

21 Dec 2005 7:05 PM

GB

Hello:
I'm looking for a free tool or procedures
to compare data content of two tables
which belongs to different servers.
Each table does not have any indexes or primary key. I need this as
verification procedures for my
log shipping process.

Thanks,
GB

21 Dec 2005 7:12 PM

SQL

Take a look at Red Gate SQL Data Compare
(http://www.red-gate.com/products/SQL_Data_Compare/index.htm)

http://sqlservercode.blogspot.com/

21 Dec 2005 7:29 PM

GB

I ask it for FREE.

Show quote

"SQL" <denis.g***@gmail.com> wrote in message
news:1135192364.052961.258020@z14g2000cwz.googlegroups.com...
> Take a look at Red Gate SQL Data Compare
> (http://www.red-gate.com/products/SQL_Data_Compare/index.htm)
>
> http://sqlservercode.blogspot.com/
>

21 Dec 2005 8:07 PM

Aaron Bertrand [SQL Server MVP]

>I ask it for FREE.

There is no FREE, one-click, easy button -- not even Staples has one of
those. So, you can invest the time in writing queries tailored to your
schema, or you can invest the money in a product that does the work for you.

21 Dec 2005 7:49 PM

Trey Walpole

when you say "each table does not have any indexes or primary key" do
you mean:
-- No tables have indexes/pks or
-- Some tables do, but not all of them

and
-- They don't have a pk [or unique?] constraint defined, but they do
have a logical pk or
-- They don't even have a logical pk defined

if it's that they don't even have a logical pk defined, then how would
you know what you're comparing? you'd have to be able to determine what
data constitutes being the same between the two similar tables on
different servers. [an identity/guid is most likely irrelevant in this
situation, as the chances that two tables in different servers have the
same identity value for the same data is extremely small]
even if it's that the pk (or unique?) constraint is not defined, then
you still might have duplicates within a singe table.

most comparison tools i've seen pull the pk dynamically, so if it's not
defined, you'll also need a tool that lets you specify the pk column(s).

GB wrote:
Show quote

> Hello:
> I'm looking for a free tool or procedures
> to compare data content of two tables
> which belongs to different servers.
> Each table does not have any indexes or primary key. I need this as
> verification procedures for my
> log shipping process.
>
> Thanks,
> GB
>
>
>

21 Dec 2005 7:59 PM

GB

Some tables do, but not all of them

Show quote

"Trey Walpole" <treypole@newsgroups.nospam> wrote in message
news:up2tgcmBGHA.2040@TK2MSFTNGP14.phx.gbl...
> when you say "each table does not have any indexes or primary key" do
> you mean:
> -- No tables have indexes/pks or
> -- Some tables do, but not all of them
>
> and
> -- They don't have a pk [or unique?] constraint defined, but they do
> have a logical pk or
> -- They don't even have a logical pk defined
>
> if it's that they don't even have a logical pk defined, then how would
> you know what you're comparing? you'd have to be able to determine what
> data constitutes being the same between the two similar tables on
> different servers. [an identity/guid is most likely irrelevant in this
> situation, as the chances that two tables in different servers have the
> same identity value for the same data is extremely small]
> even if it's that the pk (or unique?) constraint is not defined, then
> you still might have duplicates within a singe table.
>
> most comparison tools i've seen pull the pk dynamically, so if it's not
> defined, you'll also need a tool that lets you specify the pk column(s).
>
>
> GB wrote:
> > Hello:
> > I'm looking for a free tool or procedures
> > to compare data content of two tables
> > which belongs to different servers.
> > Each table does not have any indexes or primary key. I need this as
> > verification procedures for my
> > log shipping process.
> >
> > Thanks,
> > GB
> >
> >
> >