When adding a new static data table, the xml should first be added, then sorted
When you save one or more static data objects to the schema model, it also affects the RedGateDatabaseInfo.xml file:
1. The <Count> value is incremented
2. The existing <DataFile> nodes are sorted by the full schema and object name
3. A new <DataFile> node is appended to the end of the list for each of the newly saved items.
The sorting means that, unless you add static data items in strictly alphabetical order, there will always be a larger diff due to the other tables being reordered. This is annoying and causes some consternation when reviewing the changes as nothing has materially changed with the existing items.
It would be preferable if the new nodes could be added, then the full set sorted. Then the diff shows simply the count update and the insertion of the new <DataFile>s.
Attached is an example of what happens presently. The prior change that I made was to add both dataTable1 and dataTable2, so they are initially at the bottom. Then I added reference_tab. Suddenly dataTable1 and 2 get rearranged to be in alphabetical order, but reference_tab remains at the bottom.