Menu

#60 ERM generates DB and Schema Names in DDL in capitals letters

v1.0 (example)
closed-fixed
nobody
None
5
2013-12-10
2011-02-15
Anonymous
No

Hallo.
at first thank you for this easy to use and very functional plugin again.

ERM generates DB and Schema Names for exported DDL scripts in capitals letters. While this doesn't seem to be a problem on windows, it will be a problem at least on LINUX systems because these differentiate between lower case and upper case filenames for a schema.

The problem comes into existance when using generated testdata scripts: these scripts use lower case table names for inserting data in tables. On Linux tables with the lower case names do not exist (they have been created with upper case names) resulting in insertion errors.

I would suggest to take the table names as they have been entered by the user for generating the DDL script, giving the user full control over the names for databases and table (in some companies you are restricted to naming rules for development)

Thanks for reading

Good Bye

Discussion

  • Ajay Deshwal

    Ajay Deshwal - 2012-07-13

    Hi,

    I was facing a similar issue. You can disable auto-uppercase feature by:
    Right click on entity -> Display -> Uncheck 'Display by the capital letter' option.

    Hope it helps!

     
  • Hiroyuki Nakajima

    • status: open --> closed-fixed
    • Group: --> v1.0 (example)
     

Log in to post a comment.