Hi,

There is any ways(utilities) that I could compare the data between
tables(same structure).
in sql 2k sp4.

Thanks,

You can use a tool from www.red-gate.com to compare the schema or the data
but there are no built in ways to do this.

Show quoteHide quote

If you are willing to use a Java-based tool in your environment, you
can use SchemaCrawler, a free open-source tool that can compare schemas
as well as data. SchemaCrawler is a command-line tool to output your
database schema and data in a readable form. The output is designed to
be diff-ed with previous versions of your database schema.

http://schemacrawler.sourceforge.net/

All you will need is a JDBC driver, and any diff tool such as WinMerge.

Sualeh Fatehi.

mecn a écrit :
Just a SQL Query !!!!

SELECT *
FROM   TABLE1 T1
WHERE  NOT EXISTS(SELECT *
                   FROM   TABLE1 T1
                   WHERE  T1.COL1 = T2.COL1
                     AND  T1.COL2 = T2.COL2
                     AND  T1.COL3 = T2.COL3
                   ...
                   )

A +

Thanks all
I'll try all


Show quoteHide quote

Deadlock problem with insert trigger
enable advanced performance - no UPS
Supporting user-defined "columns" with eye to SQLRS
"Timeout Expired" on large table change
MSDE 2000 problems with linked server
Can you share SQL Server registration across different machines?
Installing SQL Server 2005
Q: Diagram in SQL Server
Distributed Partioned Views between different SS versions
transactional replication for web nodes