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 or IP address.
• Port: if SQL Server is listening on a non-default port, include the port with the server entry.
• Authentication: use Windows Authentication or SQL Server Authentication, depending on how the server is configured.
• Save password: use only where appropriate for your environment, because the project will then be able to reconnect without prompting.
• Database: once the server connection is valid, select the database from the retrieved list.

Common SQL Server project tasks

• Create a new database from the project editor when your account has sufficient rights.
• Use a snapshot instead of a live connection when you want to compare saved schema state.
• Use the saved server list to reuse frequently used connections.
• Switch into the project-specific tabs for mapping, filters, On Completion, and options after the connection is set.

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.