Source Control Static Data File Order

• 
  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,

  Sergio R April 28, 2016 09:01

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

  richardhudson April 28, 2016 09:26

  - 0 +
• 
  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,

  Sergio R April 28, 2016 09:39

  - 0 +
• 
  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.

  jamieburns October 06, 2017 08:25

  - 0 +
• 
  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.

  way0utwest October 06, 2017 17:20

  - 0 +
• 
  Thanks - voted!

  jamieburns October 08, 2017 17:15

  - 0 +
• 
  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.

  dandef October 24, 2017 07:39

  - 0 +
• 
  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.

  DavidLane December 08, 2017 18:31

  - 0 +

Add comment

Please sign in to leave a comment.