Adept SQL Tools - Software Products

AdeptSQL Diff

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 schema tree view, with all differences color-marked. Navigating through the tree, you can see SQL definitions for individual objects (tables, view, stored procedures, etc) compared side-by-side and produce difference scripts for any choosen part or for the whole schema. The program lets you execute the generated scripts either uninterrupted or step-by-step, set breakpoints, turn on transactions and rollback on error. A unique schema matching engine generates the minimal non-destructive SQL for any schema changes you you need to synchronize, keeping your data safe. The current version supports MS SQL Server 7 and 2000, support for other databases is planned.

Keywords: sql compare sql compare database database database utility schema ddl relational ms sql ms sql server sql server database schema difference viewer synchronization tool ms

AdeptSQL Workshop

The AdeptSQL Workshop (aka SQLIDE) is a tool for professional MS SQL developers which smoothly integrates: * SQL-oriented text editor, * macro preprocessor, * DDL compilation into internal schema model, * schema synchronization, * schema decompiler, * SQL debugger, * MS Visual SourceSafe support The AdeptSQL Workshop provides you with the most efficient environment for database schema development and management by keeping the structure of your database in a set of well-structured, readable, reusable and RDBMS-independent SQL scripts. A unique schema matching engine generates the minimal non-destructive SQL for any schema changes you do in the source scripts, providing for easy schema synchronization. The current version supports MS SQL Server only, support for other RDMS is planned.

Keywords: sql database databaseutility schema ddl design er relations relational ide debugger preprocessor mssql mssqlserver sqlserver complete ide creating