Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Comparing Tables and Rows for Whats Different.

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-03-30 : 09:24:30
Jason writes "I have two SQL Databases, one New, one OLD.

I am trying to scan, each table, then each row, and only show what actually changed and place that in a new table.

EG (Results)

Table : CPU
Column : Speed
NewValue : 36
OldValue : 42

Nothing i have found in SQL allows me to compare with a result per row/column identified. (From their i could use VB.Net to generate results).

Ideas ?"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-03-30 : 09:27:17
Comparing table
http://weblogs.sqlteam.com/jeffs/archive/2004/11/10/2737.aspx

Comparing database
http://www.sql-server-performance.com/vg_database_comparison_sp.asp

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -