Now that we know how to capture these info, including SQL info. Let's store it in SQL DB instead. What's the best SQL DB Schema if you...

In SSMS (maybe only in 2008) , you can "copy results with headers" from query window, then paste it into excel. Done!

If you're going to sync the DB's then eventually you need to find out what column/row is different. This solution doesn't address specific column and row to update in...