SQLTool conform SQL-99 and SQL-2003

View previous topic View next topic Go down

SQLTool conform SQL-99 and SQL-2003

Post  ObjectiveC on Mon May 02, 2011 3:25 am

Hello everyone,

So I didn't quite know if it's OK to post this in here, so I apologize in advance in case I've posted in the wrong section.

I am searching for a database designer tool that uses the SQL-99 and SQL-2003 standard.

Any suggestions ?

ObjectiveC

Posts : 25
Join date : 2011-03-18

View user profile

Back to top Go down

Re: SQLTool conform SQL-99 and SQL-2003

Post  ngalemmo on Mon May 02, 2011 11:05 am

Not sure what you mean by a designer tool. If you are referring to schema generation, DDL hasn't changed much (it at all). Besides, the physical model is intimately tied to the particular database vendor and version such that the SQL standards version is the least of your concerns.

If you mean a query/reporting tool, most all support the newer join syntax as well as the analytic functions. Also, most tools allow you to code your own column expressions, allowing you to leverage any features your database supports.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: SQLTool conform SQL-99 and SQL-2003

Post  ObjectiveC on Mon May 02, 2011 11:59 am

Hello ngalemmo,

I definitely mean schema generation.

I'm trying out SQL Power Architect at the moment. What I'll try to do is add the proper JDBC driver to use the tool. I'm hoping that will do the trick.

Will let you know.

ObjectiveC

Posts : 25
Join date : 2011-03-18

View user profile

Back to top Go down

Re: SQLTool conform SQL-99 and SQL-2003

Post  ObjectiveC on Tue May 03, 2011 7:24 am

So I've tried the tool SQL Power Architect out and it works nicely. Unfortunately itīs not able to generate the proper DDL for my database LucidDB.

This is concerning Foreign keys:

Code:

ALTER TABLE <table> ADD CONSTRAINT <dimension>_fk
FOREIGN KEY (<dimension>_key)
REFERENCES <dimension> (<dimension>_key)
ON DELETE NO ACTION
ON UPDATE NO ACTION;

ERROR:
Code:

[ALTER - 0 row(s), 0.000 secs]  org.eigenbase.sql.parser.SqlParseException: Encountered "CONSTRAINT" at line 1, column 33.
Was expecting one of:
    "COLUMN" ...
    <IDENTIFIER> ...
    <QUOTED_IDENTIFIER> ...
    <UNICODE_QUOTED_IDENTIFIER> ...



Does anyone here have experience with LucidDB and if so, which tools do you use ?

ObjectiveC

Posts : 25
Join date : 2011-03-18

View user profile

Back to top Go down

Re: SQLTool conform SQL-99 and SQL-2003

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum