PostgreSQL or MS SQL?

Question

I'm looking at these two options, and was wondering about which one would be better for hosting a database that will grow to "take over" for a number of legacy systems including Access and xbase? Any other databases to consider?

I'm shying away from Mysql. I have a lot of experience with it. I need stored procedures. We can't afford Oracle.

Answer 1

My question is what is your OS platform and the applications using the DB. If you are in a Windows environment, I suggest using MS SQL, but if you are in a Linux/Unix environment then I would suggest PostgreSQL. Lastly can you afford MS SQL?



From what I can gather from your questions it seems you are in a Windows environment. MS SQL will be easier to manage and use in a Windows environment.

Answer 2

if you can't afford Oracle, you can use their free edition - Oracle Express Edition.

http://www.oracle.com/technology/software/products/database/xe/index.html

it's free like Microsoft SQL Server 2005 Express edition.



and there's another alternatif like Firebird/Interbase, it support stored procedure, trigger, transaction and Events.

it's not common, but Interbase/Firebird is the first choice for Delphi programmers, and you can use it in PHP too.

http://www.ibphoenix.com/main.nfs?page=ibp_beginners_php



if you want to choose between PostgreSQL and Microsoft SQL, choose Ms SQL. but if you can get Oracle, choose Oracle.



additional :

MySQL ver. 5.0 support Stored Procedure

http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.html

Answer 3

I'd go with MSSQL. It's better supported, and if you're looking to hook it up to an Access database, then that's probably the easiest way since you can write custom programs using VBScript or .NET.

Answer 4

I would definitely go with MSSQL. It has a good management tools and since you're moving from access you should have no problem since they are both Microsoft. Also MSSQL has a better support community.

Answer 5

i agree with nutwp