Re: MS SQL Server Compatability?
Re: MS SQL Server Compatability?
- Subject: Re: MS SQL Server Compatability?
- From: Kieran Kelleher <email@hidden>
- Date: Fri, 6 Nov 2009 13:47:28 -0500
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:
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:
This email sent to email@hidden