 |  |  |  |  |  |  |  |
oracle or sql server2000, which is best?
Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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
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
•
•
•
•
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
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
web server is tomcat & programming is done thru jsp, servlet & other java technology. So which database is best?
•
•
•
•
Originally Posted by paresh72
web server is tomcat & programming is done thru jsp, servlet & other java technology. So which database is best?
Don't dance to the rhythm - erasure
•
•
•
•
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
|
Similar Threads
- let me know d steps to connect to oracle(sql) from vb6 (Visual Basic 4 / 5 / 6)
- Oracle sql developer question (Oracle)
- i have installed oracle 9i sql but while installing forms & reports it gives errors t (Oracle)
Other Threads in the Oracle Forum
- Previous Thread: SAP DB - The FREE Enterprise Open Source Database
- Next Thread: Does SQL , ORACLE + MySQL support two-byte integers?
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest Oracle Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
2009predictions acquisition amazon.com bartz bernanke cia citrix cloudcomputing crm database dell economy editor enterprise enterprise2.0 enterprisesoftware federalreserve forbes hp ibm intellipedia internet larryellison layoffs linux loughridge mediawiki michaeljackson microsoft neverland nortel notebooks oil operatingsystem oracle palm rimm saas salesforce sap seagate socialcomputing sql sun sybase technologystocks virtualiron virtualization vmware wiki wikipedia xen yahoo zoho
