Main > Network & Internet > Database Utils >

AdeptSQL Workshop 1.01



 

AdeptSQL Workshop 1.01

Sponsored Links

AdeptSQL Workshop 1.01 Ranking & Summary

RankingClick at the star to rank
Ranking Level
User Review: 0 (0 times)
File size: 1.6M
Platform: Windows 2000, Windows NT, Windows 98, Windows
License: Commercial
Price: $130.00
Downloads: 371
Date added: 2008-10-23
Publisher: Adept SQL Tools

AdeptSQL Workshop 1.01 description

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.

AdeptSQL Workshop 1.01 Screenshot

AdeptSQL Workshop 1.01 Keywords

Bookmark AdeptSQL Workshop 1.01

Hyperlink code:
Link for forum:

AdeptSQL Workshop 1.01 Copyright

WareSeeker.com do not provide cracks, serial numbers etc for AdeptSQL Workshop 1.01. Any sharing links from rapidshare.com, yousendit.com or megaupload.com are also prohibited.

Allok Video Splitter 2.2.0 Review:

Name (Required)
Email(Required)
Captcha
Featured Software

Want to place your software product here?
Please contact us for consideration.

Contact WareSeeker.com
Version History
Related Software
Database Workshop is a professional multifunctional tool for working with databases and database objects. It uses the modern plug-in module technology that combines flexibility and versatility for working with various databases. Currently, the program supports InterBase, MySql, Ms Sql, Oracle, Ms Access, DBISAM, FlashFiler, KeyDb, EasyTable, TinyDb, VolgaDb, Clarion, Paradox and dBase databases. Free Download
With 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 operate. Free Download
This application scripts the database data and schema. You can select the schema tables and objects to include in the script Free Download
Easy SQL Deploy scripts the database schema and data, compress and pack it as a deliverable .exe file Free Download
SQLWRITER is an easy-to-use and powerful SQL scripts editor. Free Download
SQL Server Backup and Restore, writes Create Scripts, Dependencies, Data to XML Free Download
SQL Batch Executor will run SQL scripts for any database with an ODBC compliant driver. Free Download
SQL Script Builder is powerful software that create a database file or sql script from any database. The script or file will migrate the table(s) and the records. Scripts comes in 5 formats ; MySql, MS SQL, Oracle, Pervasive and PostgreSQL. Free Download