This software is an all-in-one IDE for database creation and management using SQL scripts. It includes a macro preprocessor, syntax-focused editor, and schema decompiler/synchronizer.
One of the most impressive aspects of Adept SQL Workshop is the way it keeps the structure of your database organized. The software generates a set of well-structured, readable, reusable, and RDBMS-independent SQL scripts. This makes it easier to manage the database and ensures that any changes made are properly documented. The schema matching engine is also a standout feature, as it generates minimal, non-destructive SQL for any schema changes you make in the source scripts.
The current version of Adept SQL Workshop only supports MS SQL Server, but support for other RDMS is planned. Despite this limitation, I have found the software to be an indispensable tool for managing and developing database schema. The SQL debugger is particularly useful, as it allows for easy testing and fixing of any issues. I highly recommend Adept SQL Workshop for any professional database developer.
Version 1.0: N/A