943,691 Members | Top Members by Rank

Ad:
  • Oracle Discussion Thread
  • Unsolved
  • Views: 6553
  • Oracle RSS
Apr 19th, 2004
0

oracle or sql server2000, which is best?

Expand Post »
Hello

I am making a shopping cart where database I like to use is oracle but there are other projects which are already made with sqlserver2000 database & maybe I have to link from shopping cart to sqlserver2000 database where lots of contents are stored so what happens if I use oracle. Is there going to be any clash?

Awaiting reply at the earliest.

Thanking in advance.

Regards
Paresh
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
paresh72 is offline Offline
3 posts
since Apr 2004
Apr 20th, 2004
0

Re: oracle or sql server2000, which is best?

Quote originally posted by paresh72 ...
Hello

I am making a shopping cart where database I like to use is oracle but there are other projects which are already made with sqlserver2000 database & maybe I have to link from shopping cart to sqlserver2000 database where lots of contents are stored so what happens if I use oracle. Is there going to be any clash?

Awaiting reply at the earliest.

Thanking in advance.

Regards
Paresh
What web server are you running? If it's IIS on Windows, life will be much simplier if you go with SQL 2000.

Isn't licensing a concern? Sounds to me that Oracle would cost more. MSDE is free...if you don't anticipate your DB growing bigger than 2GB, it's a good alternative to SQL2000.
Reputation Points: 45
Solved Threads: 1
Light Poster
chanto! is offline Offline
39 posts
since Mar 2004
Apr 20th, 2004
0

Re: oracle or sql server2000, which is best?

web server is tomcat & programming is done thru jsp, servlet & other java technology. So which database is best?
Reputation Points: 10
Solved Threads: 0
Newbie Poster
paresh72 is offline Offline
3 posts
since Apr 2004
Apr 20th, 2004
0

Re: oracle or sql server2000, which is best?

Quote originally posted by paresh72 ...
web server is tomcat & programming is done thru jsp, servlet & other java technology. So which database is best?
Oracle has tighter java integration... and if licensing is not an issue, Oracle sounds like the logical choice. However, I'm sure it'll take a person of more technical knowledge to maintain an Oracle db...
Reputation Points: 45
Solved Threads: 1
Light Poster
chanto! is offline Offline
39 posts
since Mar 2004
Apr 20th, 2004
0

Re: oracle or sql server2000, which is best?

Quote originally posted by chanto! ...
Oracle has tighter java integration... and if licensing is not an issue, Oracle sounds like the logical choice. However, I'm sure it'll take a person of more technical knowledge to maintain an Oracle db...

Actually that is sort of true. Oracle is only a little bit trickier to setup, but will more than do the job well! I would go with Oracle myself (infact I run both SQL and Oracle... don't ask why ) , but you must understand a critical difference between them.


SQL uses T-SQL and Oracle uses PL/SQL. Similar but different.
Like a spoon and fork being different. Both are items used for eating, but not equally as well for some foods. Meaning, some T-SQL statements will not work in PL/SQL. And remember ": " can be a huge pain!



Hope this helps
Team Colleague
Reputation Points: 211
Solved Threads: 27
Master Poster
Paladine is offline Offline
793 posts
since Feb 2003

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Oracle Forum Timeline: SAP DB - The FREE Enterprise Open Source Database
Next Thread in Oracle Forum Timeline: Does SQL , ORACLE + MySQL support two-byte integers?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC