Source Control Static Data File Order

richardhudson

Hi All,

Is there a way to set the order of the insert statements in the Data folder under source control to that of the tables primary key. Currently when changes are made, those changes are shown at the top of the file, making any view of data change history impossible through file comparison. We are mostly using source control for static data, and the ability to compare files rather than SQL would benefit us greatly when understanding the changes that our development team have made.

Thanks.

Richard

Sergio R

Hi Richard,

I am afraid that this is not possible.

To compare source controlled static data and scripts folders you could use SQL Data Compare:

http://www.red-gate.com/products/sql-de ... a-compare/
https://documentation.red-gate.com/disp ... ta+sources

Thank you,

richardhudson

Thanks for the response Sergio, is this a feature that Redgate would deliver in the future?

Sergio R

Hi Richard,

I am afraid to say, but this is not on the roadmap at the moment.

If you want you can suggest this as an enhancement in our uservoice forum:
https://redgate.uservoice.com/forums/39 ... ce-control

That forum is an important source that we consult when deciding what features to add or enhance in SQL Source Control.

Thank you,

jamieburns

Did this ever make it into the uservoice forum?

We need the exact same thing, so if it's not there, I might raise it myself.

way0utwest

Done: https://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/31791202-keep-static-data-stored-in-pk-order

I like this idea. It's really more a Data Compare item, but I'll let them know.

jamieburns

Thanks - voted!

dandef

Voted.

The lack of this feature makes merge conflict resolution extremely difficult and error prone. The presence of a primary key is already enforced in order to source control the data in the first place and, since in most cases primary keys are also the clustering key, adding an order by should have minimal impact on performance when retrieving the data.

To circumvent the lack of this feature, we have resorted to manually ordering the data files before committing them.

DavidLane

This has been a major thorn in our side so much so that we are going to move to another source control . The records when changed, are moved all over the source files and there is no rhyme or reason to records that are sorted. It has caused our team so much wasted time . We have to keep manually changing the files.