March 4, 2008 at 4:00 am
Hi,
Any idea on how to build a sql script for comparing the data between two tables in a database with similar attributes and non similar attributes?
March 4, 2008 at 4:37 am
sangeethasriram18 (3/4/2008)
Hi,Any idea on how to build a sql script for comparing the data between two tables in a database with similar attributes and non similar attributes?
Could you explain it in a bit more details? In some cases a full outer join (and maybe some extra columns that are calculated based on whether two corresponding columns that are not part of the join are the same or not).
Regards,
Andras
March 4, 2008 at 4:38 am
sangeethasriram18 (3/4/2008)
Hi,Any idea on how to build a sql script for comparing the data between two tables in a database with similar attributes and non similar attributes?
Another note 🙂 There are third party tools for data comparison in your tables in case you need to do this frequently, need a nice UI, have the data in different databases/different servers, need to do full or partial migration/merge
Regards,
Andras
March 4, 2008 at 5:03 am
Wondered if this script might help....
http://www.sqlservercentral.com/scripts/Administration/61813/
Otherwise - recommend the redgate tools 🙂
Regards
Suze.
March 4, 2008 at 5:24 am
Since the number of columns are high,I cannot use the joins in the script to declare each and every column at all times.
Please let me know is there any other possibilities for different data structures to compare with huge amount of columns.
I am not suggested to use third party tools. So plz provide me in the form of SQL script if possible.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply