Re: Foreign key in Oracle Sql

Hugo Kornelis wrote:

> Probably. But if you can do it in MSDE, then why would you want to do it
> in any other DBMS?

Linux rather than Windows. Not have the GUI overhead. Not have a large percentage of CPU wasted by the o/s. Not have to spend much of my time running antivirus and anti-spyware programs.

> The only statement I made, is that ERP systems for small to middle sized
> company should run fine with MSDE as the backend database.
> Best, Hugo

Obviously your definition of middle sized is not mine. What I would call middle sized would choke on MSDE and would say no to any product based on it for several reasons.

1. If we grow then what?
2. No support
3. Poor ability to recover transactions if a problem occurs
4. MS will likely drop it in a year or two and then they are stuck just as MS is gearing up now to drop .NET
5. Forces running on the Windows o/s

In short ... it is a very bad choice among freeware.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)