AdeptSQL Diff lets you visually compare two MS SQL Server databases, then produce and execute difference scripts for a choosen part or for the whole schema. It is very fast and easy to operate.
- Permissions:Comparison of object-level and database-level permissions has been rewritten. The Diff now recognizes all new types of permissions introduced in SQL2005 on database level, and object-level permissions for all ‘securable’ objects it currently s
- The option to ignore/retain/synchronize permissions is now fully implemented. There is also a new option to ‘optimize’ permissions, which means the Diff would ignore any redundant permissions both on comparison and when scripting. Currently the detected r
- The Diff now supports (loads, compares and scripts) the STATISTICS objects in SQL 2000 and SQL 7.0. They are still not supported in SQL2005, though
- The previous version sometimes showed apparently identical PK and UNIQUE constraints as different. These false differences in PKs were likely to be due to different default ‘fill factor’ settings on the two servers, which would make its way into the index
- An access violation loading the schema was reported by several users but could not be reproduced here. It might have something to do with loading of permissions, in which case it is probably fixed in this version
- Various situations involving a global DEFAULT or RULE bound to a column via a user defined type were not correctly scripted. E.g. altering an existing column to a UDT-with-default does not automatically bind the default, whereas for a new column it does.
- Due to some recent changes in Diff’s internal schema model, the table name was missing in the ALTER TRIGGER statement. Fixed
- The Ignore/Retain/Compare logic (similar to that for permissions) is not yet done for extended properties
- Reading STATISTICS on SQL2005 is not yet done
- The permission processing is supposed to be mostly done (except for the optimization improvements, see below), but the testing done so far included only the most common situations. Database-level and object-level permissions new in SQL2005 have not been t
- The permission optimization currently does not take into account permissions granted to a user through his roles, nor permissions to specific objects implied by that user’s schema-level and database-level rights
- The Diff currently doesn’t process user-to-roles relations, that should be added
- In some situations DataDiff doesn’t report the full “host_name/server_instance” location of the databases in the window caption and tooltips, which might make it impossible to tell which database is where
AdeptSQL Diff 220.127.116.11 Beta