SQL Delta for Oracle 188.8.131.52 | 68 Mb
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.
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.
Comprehensive Search and Filtering
Within the compare results the objects can be filtered based on a range of options. For example hide all objects that are the same is a frequent filter.
Filters can be persisted so whenever you re-run the project the filter is re-applied. This persistence can also be used to preselect or pre-deselect objects which is handy if you have objects in your source that should not be sent to target.
Filter Schema Load
You can apply a filter to the schema load to exclude objects from loading. For example you could have a set of functions that are part of your source database that are never part of your target database. By adding the load filter you can exclude these functions from the load and therefore the compare.
Two Click Synchronize
Once the schema compare tab is shown simply click Script to generate the deployment script and then click Execute to apply to the target.
Report on Compare
SQL Delta can generate an HTML report of the schema compare highlighting the object differences throughout the schema.
Operating System: Windows 7, 8/8.1, 10, 11
Home Page – https://www.sqldelta.com/