SQL Delta for SQL Server - Compare and Sync
Schema and Data for SQL Server databases.
Run two or more projects side by side in separate tabs, whether it's two schema compare projects on completely separate servers or a schema compare and data compare project on the same server.
Because each process is run in separate threads you can be reviewing or even running an update script while waiting for other compare processes to complete.
You can assign each project to a project groups making organizing your projects easier. You can place all your data compare projects into a data group. Place a specific server group of projects under one group.
Straight Forward Compare
Comparing two databases is quick and easy. In a new project select your source database target then your target database and click to run your schema compare.
SQL Delta shows an overview of all the objects that are different or not in either the source or target. By selecting each object you can see at the schema level the various differences.
Comprehensive Project Options
Each schema compare project has a range of options to reduce discovery common differences. For example objects constraints with system names are usually different between source and target and these can be ignored.
For some projects your target schema names (owners) are different to your source schema names. Each compare project has the option to map source schema names to target schema names.
SQL Delta can then optionally automatically change the definitions to use the correct schema name. For example your source database uses "dbo" and your target uses "prod" as the schema name for all objects. Simply map dbo to prod and any script changes will ensure the target object is prod.object instead of dbo.object.