AdeptSQL Diff 1.96 Build 92

AdeptSQL Diff 1.96 Build 92 brings users a helpful program for you 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.

Major Features:

1. 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.
2. 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.
3. 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.
4. 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 regular OLE drag&drop) together with very flexible scripting options makes AdeptSQL Diff a perfect tool to explore your database schema.
5. Currently, version for MS SQL Server is available. Support for other SQL databases is planned.

Enhancements:

• This update fixes a critical bug in scripting, first appeared in Build 90.
• Quick links: "List index out of bounds"
• Fixed bugs: Fixed the "List index out of bounds" error introduced in Build 90. Starting from that version, objects to be created and those to be dropped were accumulated in two different lists. Unfortunately, in some situations the wrong list was referred, resulting in either the "out of bounds" exception or incorrect scripting. The bug only affected the "Produce SQL/CREATE from..." and "Produce SQL/DROP from..." commands, not the regular synchro scripting.

Requirements: Access to MS SQL Server 2008, 2005, 2000 or 7.0

 WareSeeker Editor