Re: Foreign key in Oracle Sql

On Fri, 21 Jan 2005 10:13:07 -0800, DA Morgan wrote:

>Hugo Kornelis wrote:
>
>> On Thu, 20 Jan 2005 14:52:49 -0800, DA Morgan wrote:
>>
>> (snip)
>>
>>>>lower price point for SQL Server licenses and the easier setup and
>>>>administration,
>>>
>>>Old argument that no longer holds water. Oracle matches SQL Server $ for
>>>$ on licensing with a far richer feature set.
>>
>>
>> Hi DA,
>>
>> You're obviously not aware of the existance of MSDE. I'd advise you to
>> look into it before making sweeping statements.
>>
>> As to the rest of your message, I suggest we'll have to agree to disagree.
>>
>> Best, Hugo
>
>Your obviously not aware of Oracle SE1 so let me introduce you.
>http://store.oracle.com
>click on United States English in the lower right corner
>scroll down to Standard Edition 1
>click on the drop-down edit and select Named User Perpetual
>$149.00 USD
Hi DA,

You're right. I guess I somehow got list in all the different licenses and versions when I tried to find the cheapest Oracle version at http://www.oracle.com/corporate/pricing/pricelists.html. Now that I know what to look for, I see it.

However, I'm afraind you've left out an important detail. According to http://oraclestore.oracle.com/OA_HTML/ibeCCtpSctDspRte.jsp?section=11365&media=os_user_minimums, there is a minimum of 5 Named User Plus licenses for SE1, so the licensing cost for a small company is still USD 500, plus an additional USD 100 for every user above 5 that wants to connect to the database.

MSDE is free. That's 100% cheaper. The down side is that no front-end tools are included, but those are not needed anyway for use with an ERP package. Database size is limited to 2GB (plenty for small to medium sized companies) and performance will be throttled when more than 5 user processes are simulteanously active. A well written MSDE app can easily serve 20 or more users.

>Now would you like to compare feature sets with MSDE?
>Any time you're ready have at it.

Sorry, not interested. All my current code expects ANSI-standard behaviour of empty strings. As long as Oracle can't do that, there's no way in the world that I'm going to port my code to Oracle.

>You can disagree with me. That is your right. But what would be your
>point?

None. I've just stated my opinions.

Best, Hugo

-- 

(Remove _NO_ and _SPAM_ to get my e-mail address)