Compare the data of 2 Tables (Updated)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by G.R.Preethiviraj... » Compare the data of 2 Tables (Updated)

Compare the data of 2 Tables (Updated)

Rate Topic

Display Mode

Topic Options

Author

Message

G.R.Prithiviraj Kulasingham

Posted Sunday, September 23, 2007 10:57 AM

SSC-Addicted

Group: General Forum Members
Last Login: Sunday, October 21, 2012 8:59 PM
Points: 421, Visits: 362

Comments posted to this topic are about the item Compare the data of 2 Tables (Updated)

Cheers,
Prithiviraj Kulasingham

http://preethiviraj.blogspot.com/

Post #401620

Shiva-328755

Posted Monday, December 24, 2007 9:43 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 27, 2012 3:19 PM
Points: 134, Visits: 56

Hi,

It's a great script that you have given us. Very handy to verify ETL migrations programmatically.

Just to add (probably most of you already know this), there is a tool that comes with SQL Server called "TableDiff", which pretty much does the same. Only thing, it is a command prompt tool!

Thanks,
Shiva.

---------
Cheers,
Shiva.

Post #436176

Preethiviraj Kulasingham

Posted Wednesday, March 18, 2009 3:34 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 01, 2013 6:02 AM
Points: 19, Visits: 85

Hi,
Thank you for the note, sorry for the late response.
Actually the code was first written in 2002 and I modified in 2004. I can't remember touching this code after that. When I wrote the code there weren't many tools for this purpose and I wrote it for personal use.

This tool may have little value now as there are many tools available. But that was not the case when it was written. :)

Cheers,
Prithiviraj Kulasingham

Plan to Test your Plan!

Post #678211

« Prev Topic | Next Topic »

Permissions