Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want the equivalent of MSSQL to opensource DB?

share|improve this question
installable on windows systems – dave Jan 26 '10 at 7:40
MySQL and Postgres both have Windows installers. – anjunatl Feb 15 '12 at 14:46

There are plenty of opensource rdbms. PostgreSQL and MySQL are among the more common ones.

share|improve this answer
Regarding differences between MySQL and MSSQL…. 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 Jan 26 '10 at 11:50
+1 for PostgreSQL. – Randolf Richardson Jun 30 '11 at 20:38

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.

share|improve this answer
Since PostgreSQL uses BSD-style licensing, it tends to be a more attractive choice in business environments. – Randolf Richardson Jun 30 '11 at 20:39

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.

share|improve this answer
Its not for personal project, but for an accounting package – dave Jan 26 '10 at 7:34

You must log in to answer this question.