Director of Community at PeerSpot (formerly IT Central Station)
Jul 25, 2022
Hi @Ariful Mondal, @Anteneh Asnake, @OmidKoushki, @reviewer1488372 and @reviewer1362099,
Would you have any recommendations for @Celes Agiriga?
Thank for sharing your knowledge with PeerSpot community members!
Hi community members,
I work as a System Engineer at a large Financial Services company.
Currently, I'm trying to understand the main differences between the two Relational Databases tools: MSSQL and Oracle Multitenant Architecture?
Can you share your opinion?
User at rpc relational publishing & consulting GmbH
Jun 7, 2022
First, both DBs manage your relational data on several operating systems (Linux, Windows Server, ...) and as Cloud Services. The newer architecture of Oracle tries to support you in a mixed environment where you can distribute a large DB over your own servers and cloud services. But as we always saw in the past, if a new feature of Oracle is good, Microsoft will follow.
So your main questions should be:
-How big is your DB? The bigger, the more I suggest Oracle.
-Are you in a mixed world (Cloud and your own servers)? If Cloud is Azure, I think SQL Server is a good choice.
-Is the price a topic? The liscence rules of Oracle are sometimes complicated.
Hope this helps a little.
Freelance Database Specialist at a tech services company with 51-200 employees
Jun 8, 2022
Without going into the technical details; did you have a look a the pricing of MSSQL and Oracle databases?
I always hear that the Oracle database is better than MS SQL. But I never got to test this myself.
What I do know is that when I tell a customer the Oracle pricing, they are usually going in another direction.
You must have a very good functional reason to go for Oracle considering the price difference. As @Patric Gehl suggested: a very big database is good but for a good reason.