oracle or sql server2000, which is best?

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 426,924 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,355 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Oracle advertiser: Programming Forums

Thread Tools Display Modes

Views: 5532 | Replies: 4

•

Join Date: Apr 2004

Posts: 3

Reputation: paresh72 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

paresh72

Offline

Newbie Poster

oracle or sql server2000, which is best?

Apr 19th, 2004

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

•

Join Date: Mar 2004

Location: Oregon

Posts: 39

Reputation: chanto! is on a distinguished road

Rep Power: 5

Solved Threads: 1

chanto!

Offline

Light Poster

Re: oracle or sql server2000, which is best?

Apr 20th, 2004

•

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.

Don't dance to the rhythm - erasure

•

Join Date: Apr 2004

Posts: 3

Reputation: paresh72 is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

paresh72

Offline

Newbie Poster

Re: oracle or sql server2000, which is best?

Apr 20th, 2004

web server is tomcat & programming is done thru jsp, servlet & other java technology. So which database is best?

•

Join Date: Mar 2004

Location: Oregon

Posts: 39

Reputation: chanto! is on a distinguished road

Rep Power: 5

Solved Threads: 1

chanto!

Offline

Light Poster

Re: oracle or sql server2000, which is best?

Apr 20th, 2004

•

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...

Don't dance to the rhythm - erasure

•

Join Date: Feb 2003

Location: Canada

Posts: 786

Reputation: Paladine has a spectacular aura about

Rep Power: 9

Solved Threads: 25

Paladine

Offline

Master Poster

Re: oracle or sql server2000, which is best?

Apr 20th, 2004

•

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!