• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: MS SQL Server Compatability?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
  • Follow-Ups:
    • Re: MS SQL Server Compatability?
      • From: Tim Worman <email@hidden>
References: 
 >MS SQL Server Compatability? (From: Kieran Kelleher <email@hidden>)
 >Re: MS SQL Server Compatability? (From: David Avendasora <email@hidden>)

  • Prev by Date: Re: What is the proper place for frontbasejdbc.jar - JDBC driver to Frontbase on Mac OS X Leopard
  • Next by Date: Re: MS SQL Server Compatability?
  • Previous by thread: Re: MS SQL Server Compatability?
  • Next by thread: Re: MS SQL Server Compatability?
  • Index(es):
    • Date
    • Thread