Help for SQL Delta

There are a range of options that can be applied to the view project that change the way the schema is loaded. A small help message shows how the option will change the project.

For Schema View projects there are 3 primary option groups, Load, Table and Display.

Enter text to hide all options that do not match the text. This is handy for finding that hard to locate option, if you have some idea of the text then type into the filter and press enter to filter the options.

Connection & Command Timeout	Configures the Native Client or OLEDB connection settings for connection and command timeouts. Zero uses the global defaults. Slow connections such as remote connections may require these value to be increased to provide greater connection stability. Unfortunately changing these values do not necessarily fix all timeouts and SQL Server can force a connection to terminate when its send data is slow and in other cases.
Slow Connection	When this is switched on SQL Delta will automatically configure all database components to expect a slow connection. This can result in slower performance for fast connections and still may not prevent timeouts and connection failures.
Load System Objects	SQL Delta can load and display system tables and other system objects for compare. Normally SQL Delta hides the system objects since they should not be altered however there are instances where you may wish to confirm the system objects are the same from server to server.
Encrypted Connection	Native Client provides support for encrypted connections however these require specific server-side configuration, the details can be found on the Microsoft website. We recommend you verify the connection is encrypted prior to use if this level of security is essential.

Sort Columns By	Options Column Position or Column Name. Normally columns are displayed in their ordinal column position however you may prefer to view columns sorted by column name.
Ignore Collation	The collation name will be ignored when displaying the script.
Ignore Defaults	All parts of the default will be ignored including the value, name and any bindings and not shown.
Ignore Indexes and Constraints	All indexes and constraints will be ignored when displaying the script.
Ignore Check Constraints	Check constraints will not be shown when displaying the script.
Ignore Foreign Keys	Foreign keys will not be shown when displaying the script.
Ignore Bindings	All rule and default bindings will not be shown when displaying the script.
Ignore Default Names	The name of the default will not be shown when displaying the script.
Ignore System Default Names	SQL Server generates system names for defaults without a name and these name will not be shown when displaying the script
Ignore Fill Factors	Fill factor and padding information will not be shown when displaying the script.
Ignore Data Compression	Data compression settings will not be shown when displaying the script. Data Compression also uses some file group information and we recommend file groups should also be ignored.
Ignore Change Tracking	Change tracking property will not be shown when displaying the script.
Ignore Lock Escalation	Lock escalation property will not be shown when displaying the script.
Ignore Not For Replication	Not For Replication property property will not be shown when displaying the script.
Ignore Replication Settings	All replication properties including SQL Server added columns, triggers and constraints will not be shown when displaying the script.
Ignore Statistics	Statistics will not be shown when displaying the script.
Ignore File Groups	File groups including partition schemes and functions will not be shown when displaying the script. Data compression uses file group information and we recommend ignoring file groups if you ignore data compression.
Ignore Statistics No Recompute	Statistics NO_RECOMPUTE property property will not be shown when displaying the script.

Add Comments	SQL Delta automatically adds some comments to the display script. Set this option to No to prevent the comments.
Indent spaces	Parts of the script are automatically indented by the number of spaces defined, by default 3.
Stop on Errors	By default this value is 0 and the script processor will continue to execute the entire script regardless of errors. Set this value and the script processor will stop execution once the number of errors has been reached.
Records To Load	Number of records to load when viewing data
Add GO	Add GO to the end of display scripts
Show Brackets	Display [] around object names.