Collapse / Expand SQL differences

• 
  Hi Mulmad
  
  Thank you for your post.
  
  I have passed on your suggestion or request onto the Red Gate Development Team.
  
  Your request may appear in a future version of the software but I can not guarantee that your request will be accepted. If your request is accepted I cannot giveyou any time scales as to when it will appear in a future release of the software.
  
  Many Thanks
  Eddie

  Eddie D November 13, 2006 14:47

  - 0 +
• 
  Mulmad,
  
  In SQL Compare 5.3.0, if you right click on the header of the SQL Differences panel there is an expand all / collapse all menu. Hope this is what you were after.
  
  Also there is an internal debate going on at Red Gate as to the usefulness View T-SQL in groups feature. What do you use the grouping bars in the SQL Differences panel for?
  
  Regards,
  
  Jonathan

  JonathanWatts January 30, 2007 07:47

  - 0 +
• 
  Personally i find the view in groups to be great. And the tip on how to collapse/expand all is good as well. I find it very useful to identify that the actual object is identical, and the difference actually lies in the permission or constraint section (usually fillfactor).
  
  I dont like to have many "ignore" settings on as i like things to be as identical as possible - even fillfactors and so on
  
  I would be devastated if the show in groups function was deleted
  
  And ill also take this opportunity to pimp the suggestion of having "jump to next/prev" difference buttons, to save scrolling through all of the code to find the difference. Any decent difference tool has this functionality!

  rgribble February 15, 2007 01:25

  - 0 +
• 
  rgribble,
  
  Thanks for the feedback, we have since resolved the debate: and you will be pleased to hear the grouping bars are staying. I cannot say much about what will be in the new version, but we will run a beta programme before the final release, so that everyone can have their say.
  
  Regards,
  
  Jonathan

  JonathanWatts February 15, 2007 04:45

  - 0 +
• 
  Jonathan, I also prefer groups, but am interested in only expanding those that are not the same. I know you can do them individually, but it's a pain as the groups that differ change from object to object. It' also a pain adjusting the depth of the SQL Difference panel.
  
  I would prefer the following scenario. View as long a list as possible of differing objects, with a small Differences panel showing only group summary.
  
  Click something (perhaps double click the obj) and it expands only those groups that differ (that's all we're interested in, after all) in a maximised panel to show as much of the differences as possible.
  
  Having viewed the differences at your leisure, double-click the panel (or something equally not fiddly), and presto it reverts to the small group summary at the bottom and the maximised list of objects.
  
  I count only 2 double-clicks and minimal scrolling there. I'm open to any improvements on this

  mgwiz February 22, 2007 23:32

  - 0 +

Add comment

Please sign in to leave a comment.