Documentation

for SQL Delta

sqldelta.com

SQL Delta Help

Project Options - SQL Server

This page is the first detailed project-options path and aligns to SQL Server, which is also where the current option documentation is most complete.

Main SQL Server option groups

  • Load: connection and command timeouts, slow connection handling, system-object loading, and encrypted connection support.
  • Table: column order, defaults, identities, constraints, replication settings, compression, statistics, file groups, and related table behaviors.
  • Compare: whitespace and formatting rules, permissions, full text, owners, users, roles, certificates, extended properties, and other comparison-level switches.
  • Script: comments, transactions, stop-on-error behavior, recreate strategy, trigger handling, database context, and other script-generation controls.

SQL Server-specific emphasis

  • Options involving dbo, schema ownership, full text, replication, file groups, statistics, or SQL Server security objects are strongest examples of SQL Server-specific meaning.
  • Options such as Ignore Owners and No Owner Change should be read carefully because they can change both compare behavior and generated scripts.
  • If you are scripting to production, transaction behavior, dependency handling, and recreate-table choices deserve explicit review rather than relying on defaults.
  • Server-version-sensitive areas matter more on newer SQL Server builds. Version 6 notes explicitly add SQL Server 2019 and SQL Server 2022 support, and Version 7 adds SQL Server 2025 together with JSON field type and JSON index support, so older saved projects should be rechecked when they are first moved onto those platforms.
  • Late Version 6 releases also add encryption-related compare choices such as decoding encrypted definitions, adding WITH ENCRYPTION, and ignoring encrypted objects or WITH ENCRYPTION changes. These can materially change both visibility during compare and the script that is generated.
  • Recent release notes also point to improvements in dependency ordering, script execution reliability, and large-file editing. Those improvements reduce friction, but they do not remove the need to review high-risk switches such as recreate-table, disable triggers, stop-on-error, and transaction wrapping before deployment.

For the full option list and screen-level detail, see Schema Compare Options and Data Compare Options. For the shared framing of option groups, see Project Options Overview. For server/version scope, pair this page with Supported Versions and Editions.