Hi Linda, all,
Linda DeMichiel, am 21 May 2012 hast Du um 11:44 zum Thema "[jsr338-
experts] Re: JPA schema gen" geschrieben :
> Do any of the rest of you have any feedback on this? If so, please
> send it now.
>
> thanks,
>
> -Linda
>
>
> On 5/15/2012 10:57 AM, Linda DeMichiel wrote:
[...]
> >> ddl-execution-mode: Used when executing directly against the database,
> >> rather than generating scripts. Options should include:
> >> CREATE_TABLES | DROP_TABLES | DROP_AND_CREATE_TABLES
> >> Do we also need to distinguish CREATE_SCHEMAS_AND_TABLES ? DROP_SCHEMA ?
> >> Or can these be implicit?
> >> Do we also need an ALTER_TABLES capability here?
Actually, I think we do. Once applications have delivered their first
release, they soon face the issue of having to extend the database
scheme they are using. Then they realise that drop and create is not
really what they want to. An alter table mode preserving existing data
would therefore be considered extremely helpful.
This however raises the question of a table life cycle and its
management. A comparatively elementary solution could be based on
comparison with either a previously provided DDL script or the database
catalogue.
In productive environments a chain
Automatically generate DDL scripts -> manually revise them -> have them
executed
would be desirable.
Best regards
Rainer
---
Rainer Schweigkoffer SAP AG Walldorf
Java Persistence TIP Core JI
Core Java Infrastructure Dietmar-Hopp-Allee 16
Technology & Innovation Platform D-69190 Walldorf
Building 3, I.3.14 phone: +49 6227 7 45305
rainer.schweigkoffer_at_sap.com fax: +49 6227 7 821177
Sitz der Gesellschaft/Registered Office: Walldorf, Germany
Vorstand/SAP Executive Board: Werner Brandt, Bill
McDermott (Co-CEO), Gerhard Oswald, Vishal Sikka,
Jim Hagemann Snabe (Co-CEO)
Vorsitzender des Aufsichtsrats/Chairperson of the SAP
Supervisory
Board: Hasso Plattner
Registergericht/Commercial Register Mannheim No HRB 350269
Diese E-Mail kann Betriebs- oder Geschaeftsgeheimnisse
oder sonstige vertrauliche Informationen enthalten.
Sollten Sie diese E-Mail irrtuemlich erhalten haben, ist
Ihnen eine Verwertung des Inhalts, eine Vervielfaeltigung
oder Weitergabe der E-Mail ausdruecklich untersagt. Bitte
benachrichtigen Sie uns und vernichten Sie die empfangene
E-Mail. Vielen Dank.
This e-mail may contain trade secrets or privileged,
undisclosed, or otherwise confidential information. If you
have received this e-mail in error, you are hereby
notified that any review, copying, or distribution of it
is strictly prohibited. Please inform us immediately and
destroy the original transmittal. Thank you for your
cooperation.