Schema Compare 3.8 release notes

What’s new:

SQL Server 2014 is supported

Generate Schema Script

  • Saving the options setting for future use
  • Support of command line interface
  • Automatic archiving of schema export scripts
  • Writing a report about the process into a log file
  • Automatic removing old files based on date or quantity

Code Completion

Schema Compare

  • Columnstore index is supported
  • Check for object existence option is added to the synchronization wizard
  • Ignore column order in indexes option is added
  • ALTER SCHEMA feature for objects transferring between the schemas is supported
  • Include print comments option is added
  • Exclude comments option is added

SQL Profiler

  • Query plans can be saved visually
  • Results comparison is executed when the required elements are selected
  • Various queries plans can be shown vertically in one view when comparing
  • Buffer and plans cache refresh options are added
  • Zoom menu in the Profiler diagram is available

User Interface

  • Switching tabs by the CTRL+ALT+PAGE UP and CTRL+ALT+PAGE DOWN keys combination
  • SSMS shortcut schema availability

Other Features and Improvements

  • Coloring a database connection according to the document category is possible now
  • Database connection properties are expanded
  • SET connection options in query execution are added
  • Possibility to switch from the wizard page to the main application window is added
  • SQL document zooming by holding the CTRL key and rotating the mouse wheel is added
  • Restoring the documents opened in the last session is possible now