How to create a DiffGram in SQL Server?

I have a requirement like below. A client is sending his data(xml file) in a particular file format/structure and now he made few changes to the format (I guess he moved few field positions and added few fields/columns). What is the best way to compare the prior and revised file formats? I believe creating a DiffGram an option. However, I couldn't find enough info online on how to create the Diffgram. Can anyone out there pls help me?

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush commented · Jul 19, 2016 at 11:24 AM

As far as I can see, a DiffGram is about changes to the data, not the schema. Have you asked this client for details of what he has changed? Hopefully he doesn't expect you to play 'spot the difference' and change your system to fit his alterations.

0 ·

JohnM commented · Jul 19, 2016 at 12:39 PM

You might look at something like Beyond Compare http://www.scootersoftware.com/. It has a command line to allow you to identify differences. I've used it previously, however not utilizing the command line to automate things. For $30-$60 it might be a worth while investment. EDIT: I realize now that you were looking for a way to do this within SQL Server, so forgive me. This might not help at all.

0 ·

question