[dbsrgits/SQL-Translator.git] / TODO

*   The regular Sybase parser is only just functional.  If you are
    interested in using Sybase, I would suggest serializing the schema
    (via YAML or Storable) using the DBI-Sybase parser and then
    manipulating that as you see fit. 

*   Some way to deeply check to schema objects, e.g., for testing I
    parse a MySQL schema, translate to Oracle, then parse the created
    Oracle schema and want to check the two schema objects.  I've
    started a script called "sqlt-diff" to diff two schemas, but it's 
    not included with the 0.03 release.  Submit ideas on how this
    should work and what it should create (e.g., text reports and ALTER 
    statements) to the list.

*   Add more DBI parsers!  These have the potential to be very
    thorough and far faster than parsing text files with
    Parse::RecDescent.

*   At least allow more pass-through of INSERT, DELETE, and UPDATE
    statements

*   Add INSERT statements for xSV, Excel parsers to automatically
    create INSERTs for each row of data in the source file

*   Somehow merge ClassDBI producer with CGI::FormBuilder or Template
    Toolkit and some sort of automated CGI builder to create
    view/create/edit/delete forms for objects based on schema defs

*   Embetter the Diagram producer to use some real graphing algorithms
    to distribute the tables so that the lines don't overlap so badly

*   Integrate more with some standard XML schema representations,
    maybe like Torque DB (http://db.apache.org/torque/).  We've
    started messing around with XMI, too, but that wasn't quite usable
    for the 0.03 release.

*   Possibly write a basic ANSI-92 SQL parser which could be extended
    when writing other new parsers.
Commit	Line	Data
d3b1f33a	1	* The regular Sybase parser is only just functional. If you are
	2	interested in using Sybase, I would suggest serializing the schema
	3	(via YAML or Storable) using the DBI-Sybase parser and then
	4	manipulating that as you see fit.
12d68885	5
13ab1113	6	* Some way to deeply check to schema objects, e.g., for testing I
b4d75dc1	7	parse a MySQL schema, translate to Oracle, then parse the created
d3b1f33a	8	Oracle schema and want to check the two schema objects. I've
	9	started a script called "sqlt-diff" to diff two schemas, but it's
	10	not included with the 0.03 release. Submit ideas on how this
	11	should work and what it should create (e.g., text reports and ALTER
	12	statements) to the list.
9398955f	13
d3b1f33a	14	* Add more DBI parsers! These have the potential to be very
	15	thorough and far faster than parsing text files with
	16	Parse::RecDescent.
13ab1113	17
	18	* At least allow more pass-through of INSERT, DELETE, and UPDATE
	19	statements
	20
	21	* Add INSERT statements for xSV, Excel parsers to automatically
	22	create INSERTs for each row of data in the source file
	23
13ab1113	24	* Somehow merge ClassDBI producer with CGI::FormBuilder or Template
	25	Toolkit and some sort of automated CGI builder to create
	26	view/create/edit/delete forms for objects based on schema defs
	27
	28	* Embetter the Diagram producer to use some real graphing algorithms
	29	to distribute the tables so that the lines don't overlap so badly
	30
	31	* Integrate more with some standard XML schema representations,
d3b1f33a	32	maybe like Torque DB (http://db.apache.org/torque/). We've
	33	started messing around with XMI, too, but that wasn't quite usable
	34	for the 0.03 release.
e99e9593	35
13ab1113	36	* Possibly write a basic ANSI-92 SQL parser which could be extended
d3b1f33a	37	when writing other new parsers.