The Complete Development Environment for SQL Programmers

SQL-Programmer provides a complete development environment for Oracle PL/SQL, Sybase, and Microsoft Transact-SQL programmers. Its intuitive user interface and extensive tool-set allow for easy creation, management and testing of all programmable objects such as Stored Procedures, Triggers, Functions, Packages, Views Indexes and more... With SQL-Programmer, database developers and administrators will be more productive, find and fix bugs faster, improve the quality of applications, and better manage mission-critical information. For Win95/98, Windows 2000 and Windows NT.

SQL-Programmer addresses developers' needs for a responsive, easy-to-use interface to these powerful, but often difficult to use, database environments.

SQL-Programmer's unique user interface follows standard Windows 95 and Windows NT interface design, which is familiar, easy-to-use, and will enhance your productivity in no time.

If you create or maintain SQL applications, SQL-Programmer will improve your productivity by streamlining both routine and complex tasks familiar to all database developers.

For Oracle Server users, these include creating and modifying:

• Functions, packages, and stored procedures
• Indexes and triggers
• Tables, synonyms, and views

For Microsoft and Sybase SQL Server users, these include creating and modifying:

• Stored procedures
• Indexes and triggers
• Tables, views, defaults, and rules
• User-defined datatypes

In addition, no matter which database server you use, you can:

• Quickly and easily generate reports and scripts
• Take advantage of SQL-Programmer's unique facility for creating and using Batch Objects

Who Should Use SQL-Programmer

SQL-Programmer is a powerful tool for the entire development team, in particular for SQL programmers in multi-user Relational Database Management System (RDBMS) environments. SQL-Programmer is also useful for system administrators, database administrators and development managers. In fact, anyone involved in the development, administration or maintenance of an RDBMS using the Oracle Server, Microsoft SQL Server, or Sybase SQL Server will benefit from using SQL-Programmer.

Features

Comprehensive Workplace

SQL-Programmer provides users with complete information in the most intuitive and logical manner possible. Each PL/SQL and Transact-SQL Object, for a particular Database Server, has it's own context-sensitive SQL-Programmer Development Window. These windows are MDI children of the Main Workplace. This facilitates working on several objects at once from any database server. Every SQL-Programmer Development Window allows all aspects of a particular Server Object to be managed from a single point of access. A context-sensitive Toolbar provides action functionality. Tabs provide access to related information. The Privileges Tab of a Stored Procedure window provides access to existing privileged information in force, allowing them to be modified or added, all from within the Stored Procedure Development Window.

SQL Documenter: Production Quality SQL Documentation Generation

Production Quality Documentation: Once all that hard work has gone goes into developing the database and setting up security, it's a tremendous advantage for production quality reports to be produced, not only as documentation, but also as an important impact analysis aid.

SQL Documenter is an add-on component of SQL-Programmer IX which automates the entire database documentation process.

SQL Documenter gives the user production quality reports to professionally document your Databases and Schemas and to provide programmers and analysts with valuable information. A reporting button on the main toolbar provides gains access to a reporting menu.

SQL-Programmer with the SQL Documenter option comes complete with over 60 different canned reports. Reports such as: Basic Stored Procedure, Detailed Stored Procedure, Basic Table, Detailed Table, Table Chain, Index, Trigger Chain, Trigger Basic, User-Defined types, Rules, Defaults, Functions, Packages reports, Database server configuration, "Batch Object" reports and quite many more...

SQL Documenter also allows previewing to screen any report or print request.

SQL Documenter generates all reports in the background, allowing other SQL-Programmer IX activities to be performed. Multiple Report Generation session can run concurrently, at user's will. You can preview multiple reports results concurrently using SQL Documenter Print Preview feature!

SQL-Programmer Database Explorer

The SQL Explorer component of SQL-Programmer provides access to all the editable and executable objects. The objective of this component is to browse through any object on all of the supported server types. A context-sensitive toolbar gives access to an object's related information, plus direct access to create, edit, print and script functionality. The Viewer changes to reflect source code and lists of pertinent data of graphs. Use the Explorer to drag and drop objects. It is possible to recreate the structure for an entire Database or Schema.

SQL Scripter: SQL Script Generator

Automated Database Schema Scripting: Having scripts to recreate your database server environment is a crucial part of a good backup/recovery plan. With a click of the mouse, SQL Scripter will generate scripts for multiple objects of any object type residing on multiple database servers regardless of the platform. Without SQL Scripter, this task is time consuming, laborious, and prone to unnecessary errors and revisions.

SQL Scripter is an add-on component of SQL-Programmer IX which automates the entire process and ensures the quality and consistency of the scripts produced.

SQL-Programmer Script Generator (with SQL Scripter) produces the DDL commands to regenerate each object selected while SQL Scripter generates your scripts in the background, allowing you to carry out other important SQL-Programmer functions. Multiple Script Generation sessions can be activated concurrently, at user's will. Do it all at once... you'll be amazed with the results.

Batch Object

SQL-Programmer supports a new kind of Server Object, the "Batch Object" (screen shot). SQL-Programmer has the facility to store batches of SQL statements directly on the Server they were designed and destined to run against. The "Batch Object" as its name implies, can be used for Batch/Administration Jobs, such as manipulating the Database structure, updating data information, index statistics, moving data...

As a bonus, users no longer have to rely on unsecured file server technology to house these mission critical objects. Synchronization is not a problem since they are stored within your defined database and are always in sync with your defined backup/restore methodology/procedure.

With each copy of SQL-Programmer a free utility is included that allows you to execute those database stored batch transaction from outside the scope of SQL-Programmer. It is called "BSQL", (stands for Batch SQL). It is a 32-bit console mode application that you call using optional parameters. Added to your scheduling software (such as NT AT Service or other) this allows you to schedule periodic Batch Transaction to be executed.

Search for Text in Your Server Objects

Searching for the text string "Update" in all procedures and functions in the pubs database on a SYBASE Server, is shown above. Connected servers are displayed in a TreeView, which in this case include ORACLE, MICROSOFT and SYBASE SQL Server.

The results of the Search, shown in the dialog illustrate that two triggers contained the text string "update" and the selected trigger is displayed with the search text highlighted. The Search Results Dialog's Toolbar provides the capability to edit the currently selected object, Print it, Print Preview it, Script it, Drop it, or Copy it to an internal clipboard.

Virtual SQL Editor and SQL Debugger

For ORACLE Server, SQL-Programmer adds unparalleled functionality for use in the development and maintenance of Procedures, Packages, Functions, Views, Triggers, Tables, Indexes, Synonyms and the powerful Batch Object. Each of these objects can be displayed and edited in its own MDI Window.

Here the developer can modify, save, execute, drop, get dependencies, get distinct or combined statistics, export the source, and more.

All this without affecting the original Object, protecting your Production version currently in your Database Server!

For MICROSOFT and SYBASE SQL Server, SQL-Programmer facilitates the live editing of SQL Server objects, including Stored Procedures, Triggers, Rules, Defaults, Views, User Defined Types, Tables, Indexes and Batch Objects.

Here the developer can modify, save, execute, drop, get dependencies, get distinct or combined statistics, export the source, and more.

All This without affecting the original Object, protecting your Production version currently in your Database Server!

Prologue and Epilog, Unique to SQL-Programmer!
SQL-Programmer also offers a superior "test while you edit" environment, permitting execution of Prologue, Edited Object, and Epilog Code either in sequence or individually. Any particular statement can be selected and set for execution. Each result is returned to a Tab of the SQL-Programmer Development Window.

Table Creation and Editing

SQL-Programmer's expanded functionality includes Editing of Tables and Index Definition.

This SQL-Programmer Development Window for ORACLE Tables illustrates the completely redesigned interface, providing complete functionality from within a single MDI window. The context-sensitive toolbar reveals the capability to Save, Drop, Execute, Cancel Execution, Analyze, Truncate, Print, Print Preview or Script the target table.

The Edit Tab depicted provides the interface to create and edit a table's columns. The Constraint Tab contains an interface to define constraints associated with the table. The Select Tab contains a select definition dialog permitting selection of data from the table to immediate viewing in the Results Tab. The Audit Tab allows definition of the auditing to be applied to the table. The two Privilege Tabs provide interfaces to define any privileges associated with the table. The Dependencies, Indexes and Triggers Tabs provide lists of the table's dependents, indexes, and triggers respectively. The Synonyms Tab contains the interface to define Synonyms for the target table, And the Activity Log Tab keeps track of the actions being performed on the table.

Multiple Database Server Connections

SQL-Programmer permits multiple connections to ORACLE, MICROSOFT and SYBASE SQL Servers. From the main toolbar the Login dialog can be accessed to display current connections, change connections, or to connect to a different server.

Team Programming!

For those involved in multi-developer environments, SQL-Programmer provides a unique Check-in/Check-out capability, which, when enabled, forces developers to check the object out for editing automatically, avoiding the frustration of having someone inadvertently destroying another's work. This is automatic, and included with each copy of SQL-Programmer!

Version Control!

SQL-Programmer features Automatic version control of all changes of Programmable Objects on any connected Database engine. SQL-Programmer provides a direct interface to Microsoft SourceSafe, Intersolv PVCS and MKS Source Integrity for easy corporate control within existing implemented standards. This is automatic, and included with each copy of SQL-Programmer!

PL/SQL Code Analyzer

This feature uses 50 metrics to measure the various aspects of SQL database code, empowering users to measure and improve key aspects of their code providing a detailed list of recommendations to highlight possible problem areas within the code as well as other dependency checks.

PL/SQL Code Formatter/Beautifier

This feature automatically reformats existing SQL code to a common standard with optional coding recommendations and PL/SQL level dependency checks. Using a standard code format improves the readability and maintainability of your SQL code by eliminating many different coding styles. It includes enhanced formatting options such as: choosing from various options when setting the case of variables/key words and system packages and more.

PL/SQL Code Profiler

SQL-Programmer profiles the execution of PL/SQL Procedures, Functions and Packages with one click of the mouse. The PL/SQL Profiler allows developers to quickly determine which lines of code are taking the longest and jump to that code immediately to fix the problem. This capability is available for users of Oracle 8i and up.

Increase Productivity

SQL-Programmer increases the productivity of the SQL programmer responsible for the coding of the server-side transactions, i.e.: Stored Procedure, Triggers, Functions, Views, functions, packages, etc... The product will pay for itself within a few hours of utilization. The time saving using SQL-Programmer vs. traditional methods is phenomenal!

Getting the Job Done

SQL-Programmer makes sure that your job gets done correctly. Internally, SQL-Programmer always makes copies of the procedure you are working on and never replaces any production server procedure until SQL-Programmer is sure it contains no errors.

Team Coordination

SQL-Programmer makes sure that only one programmer at a time is working on a particular object. Also, SQL-Programmer produces reports indicating who did what, where, when and for what reasons. SQL-Programmer is a 32-bit designed application that is certified for Windows 95, Windows NT (3.51 and 4.0) and Windows 2000. All ORACLE 7 and above on all platforms, all SYBASE versions, on all platforms and MICROSOFT SQL Server (4.2 up to 7.0) are supported at the same time, on ALL platforms, etc.: UNIX, SUN, VMS, NLM, NT...

System Requirements: