Which Database is best other than Sql Server?

In my currnet project we need to use one databse other than Sql Server. Because Client done not want to use SQl Server due to its lincense cost. So please suggent which one is the best alternative databse in place of Sql Server? We use .Net Technology to build the project.

Hi @Rajdeep,

Here are the list of some powerful database and they can be strong alternative for MSSQL. However the list is incomplete but these databases work well with .net technologies.

MySQL:Oracle owns MySQL and is quite effiecient as compared to SQL.
SQLite is light weight relational database and faster as compared to any other. Usually helpful when we don't want central server.
NoSQL("non SQL" or "non relational") database provides a mechanism for storage and retrieval of data that is modeled in means other than
the tabular relations used in relational databases.
MariaDB:One of the most popular database servers. Made by the original developers of MySQL. Guaranteed to stay open source.
Firebird is an open source SQL relational database management system that runs on Linux, Microsoft Windows, Mac OS X and a variety of
Unix.
MemSQL: is a real-time database for cloud and on-premises that delivers immediate insights across live and historical data.
PostgreSQL is the most advanced open-source relational database with some great features like foreign data wrappers and interesting datatypes to go beyond simple tables.

All the above are free and open source databases.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Debasis Saha8y ago
Accepted answer
You can use any one of the below database -

1. My Sql

2. Sql Lite

3. Mongo DB (basically it is no sql database which store data in json format. Also it is not support RDBMS Concept)

4.PostgreSql

5. Maria DB

6. Fire Bird
+1
Rajneesh Chaubey8y ago
Hi @Rajdeep,
Here are the list of some powerful database and they can be strong alternative for MSSQL. However the list is incomplete but these databases work well with .net technologies.
MySQL:Oracle owns MySQL and is quite effiecient as compared to SQL.
SQLite is light weight relational database and faster as compared to any other. Usually helpful when we don't want central server.
NoSQL("non SQL" or "non relational") database provides a mechanism for storage and retrieval of data that is modeled in means other than
the tabular relations used in relational databases.
MariaDB:One of the most popular database servers. Made by the original developers of MySQL. Guaranteed to stay open source.
Firebird is an open source SQL relational database management system that runs on Linux, Microsoft Windows, Mac OS X and a variety of
Unix.
MemSQL: is a real-time database for cloud and on-premises that delivers immediate insights across live and historical data.
PostgreSQL is the most advanced open-source relational database with some great features like foreign data wrappers and interesting datatypes to go beyond simple tables.
All the above are free and open source databases.
+2