Hi Philippe,
I have used the openbase EOModeler synchronisation tool via the GIU
and it seems to work fine. From the Openbase manager GUI just right
click on the DB and select "Synchronize EOModel Schema". It works
well for adding and dropping tables and columns, changing columns
width, data type or accepting null values or not and etc.
The only limitations that I have come across are:
* It does not handle renaming on tables or columns.
* It did have a bug preventing it from syncing one of my EO models
but I believe they have patched this already. (with in 48 hours of my
support request)
* It runs the SQL on the DB immediately instead of outputing the SQL
for you to review. (there might be an option so it can be passed as
an argument?)
p.s In case you where unaware Openbase also provide a "Schema
Migrator" tool which is very useful to transfer your DB schema from a
development/testing DB to your production DB. And no I do not work
for Openbase.
Regards
David Elsner
On 05/01/2007, at 8:34 PM, Philippe Lafoucrière wrote:
Hello,
I was wondering if so ever tried the synchronize an eomodel in
openbase using the openisql command "synchronize". I googled for it
and didn't find any clue on how it works.
To sum up, my choices to sync :
- Use eomodeler sync utility (seems to be broken sometime,
depending on JDBC adaptator) --> too risky
- use openbase synchronize command --> never tried, and no info
available, even in openbase doc
- Generate SQL with Entity modeler or EOModeler, and change it by
hand --> risky too, but the only reasonable solution
- Change directly the schema using the database tools, and hope it
will fit the new changed eomodel :)
Maybe this should appear (in a cleaner version) in the wikibook ?
--
Philippe
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/delsner%
40uow.edu.au
This email sent to [EMAIL PROTECTED]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
