Comparing a datatable to another datatable to see if they are exactly the same
-
Hi everyone, I was wondering if anyone out there knows of a way to compare a datable to another datatable in VS 2003. I would like to compare the two datatables to see if any updates were made to a datatable. Is there a better way than looping through all the records within each datatable? thanks
-
Hi everyone, I was wondering if anyone out there knows of a way to compare a datable to another datatable in VS 2003. I would like to compare the two datatables to see if any updates were made to a datatable. Is there a better way than looping through all the records within each datatable? thanks
To best of my knowledge VS 2003 has no such facility, however, there are quite a few third party applications you can use to compare sql database, and some of them also let you generate script to synchronize both copies. Sql data compare from http://red-gate.com/ is one such example. Hope this helps. Difficult - > Challenging, this simple replacement made me take my life little easy;)
-
To best of my knowledge VS 2003 has no such facility, however, there are quite a few third party applications you can use to compare sql database, and some of them also let you generate script to synchronize both copies. Sql data compare from http://red-gate.com/ is one such example. Hope this helps. Difficult - > Challenging, this simple replacement made me take my life little easy;)