1

I want the equivalent of MSSQL to opensource DB?

2
  • 1
    installable on windows systems
    – dave
    Jan 26, 2010 at 7:40
  • MySQL and Postgres both have Windows installers.
    – anjunatl
    Feb 15, 2012 at 14:46

3 Answers 3

5

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

1
  • Regarding differences between MySQL and MSSQL stackoverflow.com/questions/10616/…. 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, 2010 at 11:50
1

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.

1
  • Since PostgreSQL uses BSD-style licensing, it tends to be a more attractive choice in business environments. Jun 30, 2011 at 20:39
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.

1
  • 1
    Its not for personal project, but for an accounting package
    – dave
    Jan 26, 2010 at 7:34

You must log in to answer this question.