Schema Compare Changes from Version 5

Most features of SQL Delta Version 5 exist within Version 6 however in some cases the implementation is different or wording has changed.

Inline editing a project from manager

Version 6 has introduced a number of enhancements to Schema Compare projects plus added the ability to run multiple projects are one time. We felt that editing a project within a tab fits within the improved tabbed design and is more reminiscent of a web browser where tabs display discreet pages. To contain all of the edit project functionality within the inline project edit of version 5 was cumbersome or introduced dialogs that defeated the tabbed interface design. 

Disable Connection removed

The Schema View Project type now replaces the disabled connection feature. Disabled connection allowed you to create a single server connection and then display the schema of the database using schema compare display. The new Schema View project provides a dedicated view of the database schema plus other features such as a script editor and data display.

Project Options - Objects to Compare removed and moved

There are many cases where restricting the load of a core object such as a table, view, etc. causes a number of issues within SQL Delta not least dependency analysis. Even so we recognized that some object types may cause a large number of differences that can be ignored or you may wish to ignore them. 

Version 6 continues to provide a filtering mechanism for objects to compare and this can be found in Mapping and Filters within the schema compare or data compare project. Filters can restrict the load of entire object types or simply the name of an object.

The option to load system objects has been moved into Project Options/Load Options

General options removed from Project Options

Most of the general options shown in version 5 where globally specific options and these have been moved to System Preferences. The timeouts existing in system preferences and have been moved to Project Options/Load options so you can configure specific timeouts per project.

Owners tab removed from Project Options

Owner Mapping is now a standalone item within the Schema Compare project. Ignoring Owners (Schema) has been moved to Project Options/Compare Options/Ignore Owners and No Owner Change.

Data Options Removed

Data options only appear in a Data Compare Project.

Automatically Fix Incorrect Names

Fix incorrect names option has been removed from this version of SQL Delta.

Revert has been removed from editing a project

Version 5 automatically saved projects and revert allowed you to undo inadvertent changes to the project prior to saving. This feature has been removed and SQL Delta requires explicit saving and allows a project to be not saved by closing the edit tab. SQL Delta V6 has automatic project saving so closing the project tab will also save the project however this can be temporarily switched off by clicking the Auto Save Active message. Also shutting down SQL Delta without closing the edit project tab will prevent auto save.

Version 5 Snapshots not supported

Old snapshots cannot be loaded into version 6.

Compare Databases is now Run

In version 5 to run a project you clicked Compare Databases and in version 6 you press Run (Run project). The project manager now has a project type that does not compare databases so the term Compare Databases no longer is applicable. Additionally we may add more project types to SQL Delta in the future and these may not be compare projects.

Data Compare is a separate project

Version 5 required the schema compare to run first and then the data compare could be configured and run. This is no longer the case and the Data Compare Project is separate and performs its own schema loading as a separate process. You may wish to have two projects, a schema compare and a data compare to update the schema and the data however this is not a requirement.