AdeptSQL Diff 1.95 Build 87

With SQL2005 client installed, the Diff would permanently freeze reading a database (whether SQL2005 or SQL2000 one) if any time AdeptSQL Diff is a lightning fast and intuitive tool to visually compare and synchronize two MS SQL Server databases. The program scans both databases and displays the combined schema tree view, with all differences color-marked.
Navigating through the database schema tree, you can see SQL definitions for individual objects (tables, view, stored procedures, etc) compared side-by-side in the larger panel to the right of the schema tree.
AdeptSQL Diff is a program that helps you manage SQL databases.
You can produce difference scripts for any chosen part or for the whole schema. The schema matching engine generates effective update SQL for any schema difference you need to synchronize, trying to preserve the table data whenever possible.
The generated scripts are displayed in a separate debugger-style popup window where you can edit them, execute them either uninterrupted or step-by-step, set breakpoints, turn on transactions and rollback on errors.
Even if you have only one database to work with, the drag&drop scripting (you simply drag one or more schema items to any text editor supporting OLD drag&drop) together with very flexible scripting options makes AdeptSQL Diff a perfect tool to reverse-engineer your database schema.
Currently, versions for MS SQL Server, and Interbase are available. Support for other SQL databases is planned.
Main features:
- The Diff no longer uses SQLDMO to obtain the list of available servers, using instead the list of known servers the SQL client keeps in Windows registry. This way the Diff doesnt have to spend time pinging the LAN and there is no need to have SQLDMO around. This also happens to solve the "freezing" bug described below
- Besides keeping connections in saved "comparison documents", the last valid connection settings are remembered as defaults for the next session, as it was before 1.90.
- For views and table functions with SCHEMABINDING dependencies are resolved correctly. Normally it is possible to change a table without dropping and re-creating views and functions that refer to this table. However, views and funcs which have the WITH SCHEMABINDING clause must be dropped prior changing a table they refer to. So the Diff now does this.
Version restrictions:
- 30 days and 50 uses trial