Additional functionality request

• 

  jwtimoney wrote:

  Ignore [ ] around compared object names, It creates false positives during compares

  
  The problem you are seeing is because SQL Differences Panel does a simple textual comparison of objects. This is done primary for speed, as an entire semantic comparison of an object's SQL would be a lot slower. We may look at this for future point releases, but this won't be changed pre-beta. Sorry.
  

  jwtimoney wrote:

  Can you add in the ability to sync “Database Diagrams†between databases?

  
  Unfortunately there are no SQL DDL commands that would allow us to migrate diagrams. As I understand it we would have to move the data in necessary system tables to migrate a diagram.
  
  This would mean that we would have to run sp_configure to allow direct updates to system tables. As this is something Microsoft advise against in SQL Server 2000, and isn't even allowed on SQL Server 2005 except on the DAC, we feel that it would be unwise for SQL Compare to change these settings.
  

  jwtimoney wrote:

  Add an option to create a synchronization script and create a restore script to reverse the changes the changes.

  
  We are looking into this, or something very similar for a future point release.
  
  I am glad you like the new changes.
  
  Regards,
  
  Jonathan

  JonathanWatts May 21, 2007 05:43

  - 0 +
• 

  Jonathan Watts wrote:

  jwtimoney wrote:

  Ignore [ ] around compared object names, It creates false positives during compares

  
  The problem you are seeing is because SQL Differences Panel does a simple textual comparison of objects. This is done primary for speed, as an entire semantic comparison of an object's SQL would be a lot slower. We may look at this for future point releases, but this won't be changed pre-beta. Sorry.

  
  Whoops, scratch that, I was thinking of a different problem. You are right that the main grid should report the object as identical regardless of [ ].
  
  Sorry,
  
  Jonathan

  JonathanWatts May 21, 2007 07:00

  - 0 +
• 
  Can you make it so that the database comparrison settings are saved even though the first comparrison fails.

  cthame May 21, 2007 22:02

  - 0 +
• 

  cthame wrote:

  Can you make it so that the database comparrison settings are saved even though the first comparrison fails.

  We are looking into this, but it will probably come in the point release rather than the final release.
  
  Regards,
  
  Jonathan

  JonathanWatts May 22, 2007 06:29

  - 0 +
• 
  Can you please add an option to ignore the text "NOT FOR REPLICATION" from compared objects (table's, Sp's, views', etc..), it shows a lot of false positives.
  
  
  thank you

  jwtimoney May 29, 2007 11:48

  - 0 +

Add comment

Please sign in to leave a comment.