Schema Compare v3.8 release notes

SQL Server 2014 support

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