AdeptSQL Workshop v.1.01


Adept SQL Workshop supports all phases of database schema development from writing (or generating from an existing database) a set of SQL sources to the debugging and to the subsequent database syncronization 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.An important part of Adept SQL Workshop is a convenient text editor with SQL syntax highlighting and shortcuts for commonly used SQL statements. A separate "statement list" panel groups, by the affected schema object, all SQL statements, providing instant access to any statement in any of the open project scripts.Before the scripts are fed to the SQL server, they are passed through a macro preprocessor. With a usual combination of #includes, #defines and conditional compilation directives, you can put into a single declaration file macros for all project-specific data types or commonly used field combinations. This will help you to keep the project scripts compact, consistent, DBMS-independent and easy to modify.In Adept SQL Workshop, any of the preprocessed SQL statements can be previewed and executed. You can set breakpoints, run or step-through specific scripts or all scripts in the project. Query results can be displayed in a separate window.An SQL project can be very easily re-created from an existing database. Not only Adept SQL Workshop generates the SQL scripts based on the database schema, it also provides many convenient ways to split the resulting script to multiple modules and to replace, where appropriate, raw SQL with project-defined macros.Most databases, except for trivial ones, can be split into logical sections (groups of tables, views, procedures, etc) relatively independent from each other. Iimplementing each of the groups as a separate script make the schema sources much easier to view and maintain. The project-oriented approach used in Adept SQL Workshop makes it very natural to construct your database from many script files which all share the same set of macro declarations. You can easily add, remove or rearrange scripts within the project, execute all or selected scripts.Adept SQL Workshop fully understands the DDL subset of MS Transact-SQL (CREATE/DROP/ALTER statements and the stored procedure calls modifying the schema, like "exec sp_addtype"). The program can build an internal schema representation right from the SQL sources and then do various interesting things with it, like comparing against the database schema and producing the difference scripts. This means that the same SQL script can be run against the live database any number of times without affecting unchanged tables. It will emit only the minimal SQL necessary to syncronize the source and the database, therefore greatly simplifying changes in the database.Adept SQL Workshop optionally generates history scripts, which can be played on customers remote machine to synchronize their database with your master copy. This play-back is done by a stand-alone utility, which can be run either as a simple and user-friendly GUI application or silently from a command line. Preparing a database for versioning, you associate with it a history script - an SQL file describing, in one or more version sections, the current database schema. Having made changes to the database schema, you can then update the history script with a single menu command. The program will match the current database schema against the last schema recorded in the history script, then append the changes to the history under a new version number.Since all your database structures are kept in SQL scripts (text files), the regular version control methods can be used to manage the team work. If several developers are responsible for the development of specific logical sections of the database, they can work independently on their SQL scripts (and their local copies of the database) using a 3-rd party source code control software. Adept SQL Workshop includes the basic version control commands in its user interface, interfacing with a specific VCS software through a separate plug-in module. Adept SQL Workshop ver. 1.0 supports MS Visual SourceSafe 5.0 or higher, support for other version control systems may be added in future versions.

Adept SQL Workshop supports all phases of ...

compare schema, compare tables, sql diff, synchronize sql, change manager, database synchronization, database, comparison, schema, compare database, sql tools, ms sql, database compare tool, database tools, apex, compare sql, sql script

  • AdeptSQL Workshop
  • 1.01
  • Adept SQL Tools
  • Windows 2000, Windows NT, Windows 98, Windows
  • Commercial
  • 1.6 Mb
  • 157
  • $130.00

Review AdeptSQL Workshop

  • captcha

Other software of Adept SQL Tools
  • AdeptSQL  v.1.1The complete IDE for creating and managing databases from SQL scripts, including macro preprocessor, syntax-oriented editor, schema decompiler/synchronizer and debugger. Schema change versioning, MS Visual SourceSafe integration. Works with MS SQL ...
  • AdeptSQL Diff  v.1.96 BuildWith AdeptSQL Diff, you can visually compare two MS SQL Server databases, then produce and execute difference scripts for a choosen part or for the whole schema. Also compares table data. Very fast and easy to ...
  • SeQueLizer IDE  v.0.99SeQueLizer IDE 0.99 is an easy to use, high performance tool which is designed for professional MS SQL developers which smoothly integrates: An SQL-oriented text editorMacro preprocessorDDL compilation into internal schema modelSchema ...

New Utilities software
  • PresenTense Time Client  v.5.2PresenTense Time Client is a time client for all versions of Windows. It synchronizes your PC system clock to a GPS or network time server. Supports e-mail and syslog alarm redundancy and can be centrally managed and configured by LanTime Analyzer.
  • AddWit TeamMessenger  v.1.0AddWit TeamMessenger 1.0 provides you an useful Microsoft certified secure real-time collaboration and live communications application for business and virtual teams for whom privacy, security and compliance are a key requirement. It consists of a ...
  • AdeptTimeSheet  v.1AdeptTimeSheet 1 is a helpful and convenient-to-use program with which the user can logon to Projectserver and gain access to his/her assignmens and can enter Actual hours to the project. He/She can also create periodically time report and view ONLY ...