Documentation

for SQL Delta

sqldelta.com

SQL Delta Help

New/Edit Project - SQL Server

This page is the primary detailed path for creating or editing a project. The current help corpus and most screenshots align most closely with SQL Server projects.

Connection details

  • Server: enter the SQL Server name, instance name, or other server endpoint value used in your environment.
  • Authentication: the current SQL Server form supports Windows Authentication, SQL Server Authentication, and several Active Directory authentication modes when the selected driver supports them.
  • User name and password: these fields change with the selected authentication type. Password-saving is only relevant for authentication modes that actually use a stored password.
  • Database: once the connection details are valid, load the database list and select the database to use in the project.
  • Driver selection: if the default SQL Server driver is not suitable for the server or authentication mode you need, use the manual driver selection area to choose a more specific driver.

Common SQL Server project tasks

  • Create a new database from the project editor when your account has sufficient rights.
  • Use the saved server list to reuse frequently used connections. A successful connection or database-list load updates the saved server entry.
  • Switch into the project-specific tabs for mapping, filters, On Completion, and options after the connection is set.

Connection flow

In the current SQL Server editor, the usual sequence is to enter the server details, choose the authentication mode, test or load the available databases, then pick the required database. After that, continue through the remaining project tabs and either save the project or run it.

SQL Server-specific terminology

Shared pages that mention schema usually map directly to SQL Server schema names such as dbo. Where shared pages discuss owner or schema mapping, the SQL Server interpretation is normally the most literal one in the current help set.

For the full existing screen-level walkthrough, see Database Selection. For option groups after the connection is defined, see Project Options - SQL Server and Schema Compare Options.