Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted Aug 28, 2002

Adept SQL Workshop 1.0 Beta 11 Now Available

By Forrest Stroud

Adept SQL Workshop is a new tool that has been designed to support all phases of database schema development from writing (or generating from an existing database) a set of SQL sources to debugging and to subsequently synchronizing the database when the scripts are changed. Adept SQL Workshop is specifically designed to deal with the DDL subset of SQL and the schema synchronization. It complements query building and analyzing tools like MS Query Analyzer rather then competes with them.

Adept SQL Workshop offers a convenient text editor with SQL syntax highlighting and shortcuts for commonly used SQL statements; a macro preprocessor for keeping project scripts compact, consistent, DBMS-independent and easy to modify; and a SQL debugger that allows you to set breakpoints or step-through specific scripts in a project. Here's a screenshot of the current release:

Additional features in Adept SQL Workshop include the ability to reverse-engineer the database schema; a project-oriented, modular development approach; differential schema synchronization; database versioning (generating history scripts); remote shema updates; and integration with Microsoft Visual SourceSafe.

Beta 11 of Adept SQL Workshop 1.0 has a simplified and more intuitive user interface, visual schema differencing, a side-by-side comparison window for stored procedures and other schema objects, and support for SCC-compliant version control systems. The beta is "Try at Your Own Risk" software -- it still contains a variety of bugs at this point, especially in the code for generating difference scripts.

Beta 11 can be downloaded directly at:


Pricing for Adept SQL Workshop begins at $130 for a single computer license; Enterprise licenses start at $180 per unit with a minimum requirement of four copies. Additional information for Adept SQL Workshop can be found at:


» See All Articles by Editor Forrest Stroud

Database News Archives

Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM