Comparing the data of two tables in the same database in sqlserver

sql sql-server redgate
user123 picture user123 · Jul 19, 2013 · Viewed 7.2k times · Source

I need to compare the two table data with in one database.match the data using some columns form table.

Stored this extra rows data into another table called "relationaldata". while I am searched ,found some solutin.

But it's not working to me http://weblogs.sqlteam.com/jeffs/archive/2004/11/10/2737.aspx

can any one help how to do this. How compare two table data with in one database using redgate(Tool)?

Answer

Wonko picture Wonko · Jul 19, 2013

Red Gate SQL Data Compare lets you map together two tables in the same database, provided the columns are compatible datatypes. You just put the same database in the source and target, then go to the Object Mapping tab, unmap the two tables, and map them together.

Data Compare used to use UNION ALL, but it was filling up tempdb, which is what will happen if the table has a high row count. It does all the "joins" on local hard disk now using a data cache.

Related questions

How to execute a 3GB SQL file (Microsoft SQL Server)?

I have a big SQL file that does not fit into memory and needs to be executed against Microsoft SQL Server 2008. It seems that the sqlcmd.exe tool always loads it into memory first which is impossible in this case. …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More