all it comes down to in EM is whether your plugins support sql generation via the 5.3 API's ...On Nov 6, 2009, at 2:50 PM, Tim Worman wrote: CORRECTED: It was before WOLips/Entity Modeler, for me.
Tim On Nov 6, 2009, at 11:39 AM, Tim Worman wrote: Yes, I was able to reverse engineer our campus data store. It was before WOLips/Entity Modeler and I can't remember what tweaks I may have had to apply after.
Tim
UCLA GSE&IS
On Nov 6, 2009, at 10:47 AM, Kieran Kelleher wrote: Good info, thanks.
Anyone know if we are able to reverse engineer an existing MS SQL database ..... ie., generate the EOModel form the database automatically?
On Nov 6, 2009, at 1:43 PM, David Avendasora wrote:
Hey Kieran,
I used MS SQL Server 2000 extensively with my WO 5.3/5.4 ERP project - and tested it some with 2005 but never used it in production. The biggest problem with it is that you can't defer constraints, so if you have DB constraints, you MUST use chuck's MSSQL plugin so that it will order the inserts, updates and deletes based on dependencies.
The plugin works great, except for situations where a table is self-referencing with a constraint. EOF has no way of knowing which object it should insert first. Chuck and I discussed this situation and I think I figured out how it _could_ be done by evaluating FKs and PKs upon insert in self-referencing situations, but we only ever discussed the concept. I ended up just removing the constraint in the DB.
Also, I believe there was some weirdness related to Vertical Inheritance, but I can't remember now as I eventually ripped it out of my app altogether. But that weirdness could have also been related to D2JC... not sure anymore.
Other than that, it worked fine.
Dave
On Nov 6, 2009, at 1:30 PM, Kieran Kelleher wrote:
I am discussing a possible project with a company that uses MS SQL Server for an existing ERP system. They are checking what version. Can anyone tell me what versions of MS Sql Server work with WO 5.3.3? .... WO 5.4.3? ... and with latest Wonder of course?
Regards, Kieran
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/email@hidden
This email sent to email@hidden
David Avendasora
Senior Software Engineer
K12, Inc.
*****
WebObjects Documentation Wiki : http://wiki.objectstyle.org/confluence/display/WO/
*****
WebObjects API: http://developer.apple.com/legacy/mac/library/documentation/MacOSXServer/Reference/WO54_Reference/index.html
*****
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/email@hidden
This email sent to email@hidden
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ( Webobjemail@hidden) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/email@hiddenThis email sent to email@hidden
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/email@hidden
This email sent to email@hidden
|
