Project Plan For SQL Dev Tools, version 1.7

Introduction

"Data Tools" is a vast domain, yet there are a fairly small number of foundational requirements when developing with or managing data-centric systems. A developer is interested in an environment that is easy to configure, one in which the challenges of application development are due to the problem domain, not the complexity of the tools employed. Data management, whether by a developer working on an application, or an administrator maintaining or monitoring a production system, should also provide a consistent, highly usable environment that works well with associated technologies.

The Data Tools Platform (DTP) project provides a set of frameworks and basic tools to enable data-centric development in a variety of data types, including databases (via JDBC) and ODA data sources (for BIRT reporting). The frameworks are open to allow common interfaces (both API and user interface) across different types of data.

DTP is broken into a number of sub-projects. This project plan focuses on the SQL Development Tools sub-project, which provides a set of frameworks and basic tools to handle management of database assets and SQL queries

Release Deliverables

DTP provides two main deliverables: one deliverable for developers, which includes source code, examples, and so on; and a user or runtime deliverable that just provides the basics for DTP use.

Table of Contents

Release Milestones

The DTP project delivers a set of components to ease connecting to and working with data sources. Primarily DTP focuses on database (SQL development) work and ODA data sources for BIRT reporting.

M3 11/5/2008

Release Train M3 +1 Date (M3 GA on 11/19/08)

(Note that this will be the DTP 1.6.2 M1 build for now until we branch Galileo sometime the week of November 10th)
M4 12/17/2008

Release Train M4 +1 Date (M4 GA on 1/12/09)

M5 2/3/2009

Release Train M5 +1 Date (M5 GA on 2/16/09)

M6 3/16/2009

Release Train M6 +1 Date (M6 GA on 3/23/09)

M7 5/4/2009

Release Train M7 +1 Date (M7 GA on 5/11/09)

RC1 5/18/2009

Release Train RC1 +1 Date (RC1 GA on 5/25/09)

RC2 5/25/2009

Release Train RC2 +1 Date (RC2 GA on 6/1/09)

RC3 6/1/2009

Release Train RC3 +1 Date (RC3 GA on 6/8/09)

RC4 6/8/2009

Release Train RC4 +1 Date (RC4 GA on 6/15/09)

RC5 6/15/2009

Release Train RC5 +1 Date (Galileo GA on 6/26/09)

Table of Contents

Target Environments

See the main Datatools plan for target environment details.

Table of Contents

Compatibility with Previous Releases

The goal of this release is to be backward compatible back to DTP 1.6.

Table of Contents

Themes and Priorities

The SQL Dev Tools sub-project will work on the following themes and priority for the DTP Galileo release.

(Note that "committed" items have the "plan" keyword in the BZ entry. "Proposed" items do not.)

Multi-page SQL Schema Editor Framework and exemplary implementations for Sybase ASA in enablement project(pending resource availability)

The following items should be considered...

  • Multi-page Schema Editor GUI Framework and the generic preference pages

  • Concrete exemplary schema implementations for Sybase ASA including the following (pending resource availability)

    • Table Schema Editor
    • Index Editor
    • Stored Procedure editor
    • User Defined Function editor
    • User Defined Type editor
    • Constraint/Rule editor

SQL Editor Framework/SQL File related

SQL Results view bug fixing

SQL Query Plan view bug fixing

Sybase Enablement project related bugs

Non-SQL Query Builder Bugzilla queries

  • Committed
    • UI code should be separated from editor.core plugin [252005] (target milestone: Galileo)
  • Proposed
    • SQL GenModel doesn't exist in packaged plug-in [234800] (target milestone: Galileo)
    • BinaryStringDataType produce CHAR FOR BIT DATA (without length) [244751] (target milestone: Galileo)
    • API request for Column.isAutoIncrement() [250023] (target milestone: Galileo)
    • Error logged when save and close a scrapbook to a sql file [241618] (target milestone: Galileo)
    • Enhance DTP User Tooling [247184] (target milestone: Galileo)
    • SQL Editor auto format [170602] (target milestone: Galileo)
    • Overloading Function names [171718] (target milestone: Galileo)
    • execute current statement [185501] (target milestone: Galileo)
    • Editor does not inherit from STD text editors - specifically tabs [217923] (target milestone: Galileo)
    • SQLToolsFacade doesn't recognise SQL server versions correctly [244180] (target milestone: Galileo)
    • Generic SQL parser doesn't treat GO as delimiter [244251] (target milestone: Galileo)
    • SQL Editor incorrectly specifies version number for open connections [244577] (target milestone: Galileo)
    • SQL Statement Editor cannot save the content. [244682] (target milestone: Galileo)
    • Scrollbar doesn't work in the grid mode [245484] (target milestone: Galileo)
    • ResultExportWizard throws NPE when outputter.output throws Exception [246106] (target milestone: Galileo)
    • SOE:Lost line focus after saving [246180] (target milestone: Galileo)
    • Remember result tab while iterating through results [254488] (target milestone: Galileo)
    • Multi-page SQL Schema Editor Framework & exemplary implementations for Sybase ASA in enablement project [256368] (target milestone: Galileo)
    • poor error handling in datatools when browser can't be started [221362] (target milestone: Galileo)
    • Show the elapsed run time of a SQL [231401] (target milestone: Galileo)
    • Add ability to select individual cells in the Results View and copy to clipboard [243778] (target milestone: Galileo)
    • sql editor opens by default [220318] (target milestone: Galileo)
    • postgresql code assist didn't work in SQL File Editor [237037] (target milestone: Galileo)
    • Support for auto-commit and commit/rollback buttons [243779] (target milestone: Galileo)
    • Inconsistent behavior on execution [221845] (target milestone: Galileo)
    • RoutineEditor to open different SQL Objects with same name [199353] (target milestone: Galileo)

SQL Query Builder related

  • Committed
    • No items.
  • Proposed
    • Column names do not appear when launched from editor [220431] (target milestone: Galileo)
    • Integration with DTP SQLEditor [202590] (target milestone: Galileo)
    • Enablement: SQL Dialect Support / Extensibility [202592] (target milestone: Galileo)
    • Enablement: User-Interface Enablement [202593] (target milestone: Galileo)
    • Improve Core UI [202596] (target milestone: Galileo)
    • Easy Access to Database objects [202597] (target milestone: Galileo)
    • Add tabbed properties pane [202598] (target milestone: Galileo)
    • Improve handling of quoted identifiers [202601] (target milestone: Galileo)
    • support: comments in source [202602] (target milestone: Galileo)
    • support: mix of qualified and unqualified identifiers [202603] (target milestone: Galileo)
    • Allow cancel of SQL execution [202604] (target milestone: Galileo)
    • support: SQL subqueries [202605] (target milestone: Galileo)
    • support: INTERSECT, EXCEPT [202606] (target milestone: Galileo)
    • Define and implement connection strategy [206756] (target milestone: Galileo)
    • Enablement: host variable support [216556] (target milestone: Galileo)
    • Minimize dependencies for packaging in a RCP application [225009] (target milestone: Galileo)

Table of Contents

view raw xml of project plan
from project meta-data key "projectplanurl"