compare tables 
Author Message
 compare tables
hi
how can i compare 2 tables???
i have to know if a subset of coloumns are the same
thanks

Carlo



Sat, 13 May 2006 15:13:14 GMT
 compare tables

If it's the schema you are trying to Compare there's a 3rd party utility
called SQLCompare.

If it's the data something like :-

    SELECT a.Col1, b.Col1 FROM tbl1 a JOIN tbl2 b
        ON a.Col1 = b.Col1

If you post the schema of the 2 tables and some sample data we will be able
to help further

--
HTH
Ryan Waight, MCDBA, MCSE


Quote:
> hi
> how can i compare 2 tables???
> i have to know if a subset of coloumns are the same
> thanks

> Carlo



Sat, 13 May 2006 15:21:50 GMT
 compare tables
Even if its SCHEMA,
you can query the INFORMATION_SCHEMA views
to do the compare.

--
Roji. P. Thomas
SQL Server Programmer ;)
________________________

Quote:
> hi
> how can i compare 2 tables???
> i have to know if a subset of coloumns are the same
> thanks

> Carlo



Sat, 13 May 2006 15:44:54 GMT
 compare tables
check out www.dbghost.com
Quote:
>-----Original Message-----
>hi
>how can i compare 2 tables???
>i have to know if a subset of coloumns are the same
>thanks

>Carlo

>.



Sat, 13 May 2006 18:15:10 GMT
 compare tables
Hi Carlo,

Thanks for your post. Based on your description, I am not quite clear what
your accurate concern is, can you describe it in detail?
You wrote "how can I compare 2 tables???", what do you want to compare,
schema or data? Do you want to compare manually or automatically?

SQL Compare by Red-Gate is a product to let you compare two SQL Server
databases and generate a script to sync any differences in objects (tables,
procedures, even users and roles).
For more information regarding SQL Compare, please refer to the following
article:
Review of SQLCompare
http://www.sqlservercentral.com/columnists/awarren/sqlcomparereview.asp

This document contains references to a third party World Wide Web site.
Microsoft is providing this information as a convenience to you. Microsoft
does not control these sites and has not tested any software or information
found on these sites; therefore, Microsoft cannot make any representations
regarding the quality, safety, or suitability of any software or
information found there. There are inherent dangers in the use of any
software found on the Internet, and Microsoft cautions you to make sure
that you completely understand the risk before retrieving any software from
the Internet.

I am standing by for your response.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.



Fri, 19 May 2006 10:41:26 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Compare Table against Full Text Indexed Table

2. Comparing tables to tables(????)

3. Comparing table contents of two tables

4. Compare tables

5. comparing tables

6. Compare tables

7. Comparing tables in separate dbs

8. Comparing Tables in Different DB?

9. Finding unmatched rows (compare tables)

10. Compare table contents

11. Compare Tables

12. Compare table structures


 
Powered by phpBB® Forum Software