1
I want the equivalent of MSSQL to opensource DB?
What is the equivalent of MSSQL to Open Source
Answers
5
There are plenty of opensource rdbms. PostgreSQL and MySQL are among the more common ones.
Quentin
Posted 2010-01-26T07:03:02.707
Reputation: 1 191
Regarding differences between MySQL and MSSQL http://stackoverflow.com/questions/10616/differences-between-mysql-and-ms-sql. Also, no FULL OUTER JOIN (you have to do UNIONS with LEFT/RIGHT JOIN) + no recursive queries (you have to make a stored proc w/ temporary table). MSSQL can do this easily. Plus, PHPmyAdmin or whatever is no SQL Server Mgmt Studio. MySQL is ok, though. Just like Open Office is ok, just don't expect MS Office.
– hyperslug – 2010-01-26T11:50:42.8731
Do you actually require open source, or are you just trying to keep costs down?
If open source, I would suggest PostgreSQL, since I believe it to be more robust than MySQL. If you are looking for lower cost alternatives to SQL Server, you might want to look at SQL Server Express, Oracle Express Edition, or DB2 Express-C.
Joe Internet
Posted 2010-01-26T07:03:02.707
Reputation: 5 145
Since PostgreSQL uses BSD-style licensing, it tends to be a more attractive choice in business environments. – Randolf Richardson – 2011-06-30T20:39:58.140
0
David mentioned the main big ones out there which are deployed in a ton of environments. If this is for personal use, on a small project, you may find SQLite more suitable. I wouldn't consider it a fully-fledged replacement, but it works well for personal projects. SQLite is the most widely deployed SQL database engine overall as it is used in software like Skype, Firefox and Solaris 10.
John T
Posted 2010-01-26T07:03:02.707
Reputation: 149 037
1Its not for personal project, but for an accounting package – None – 2010-01-26T07:34:32.637
1installable on windows systems – None – 2010-01-26T07:40:34.743
MySQL and Postgres both have Windows installers. – anjunatl – 2012-02-15T14:46:13.447