On Thu, Mar 21, 2013 at 11:03 AM, Harvey Rothenberg
<[email protected]>wrote:

> Question for all you Sys Admins and Budding DBAs,
>
> Between Microsoft's SQL Server and PostGres (no matter the version) which
> would be easier to install and maintain, in general ?  Could you equate SQL
> Server to Oracle in their flexiblity/complexity or is PostGres more
> challenging ?
>
>
Harvey -

I'd say SQL Server if it's just a basic database that they don't need to
tweak very much.  I have much more experience with SQL server and mySQL
than Postgres, but I've been using Postgres more and more in the last year
or so (and like it).

I think the functionality between SQL Server and Postgres is very similar,
but for someone with no experience with either, and likely little
experience with Windows or Unix administration, SQL server is by far easier
to get going.  While it may not be ideal, they can just about click 'next'
at every stage of the install.

For postgres, you really need to make some system changes just to get the
database going.  Given that the process is eased if you can use the package
that comes with your distribution (RedHat, Debian, etc.).

Nick

--
Nick Webb
Principal Systems Engineer
Red Wire Services, LLC
T: 206.829.8621 / F: 206.826.1223

1725 SW Roxbury St. STE 10
Seattle, WA 98106

http://www.redwireservices.com

http://linkedin.com/in/NickWebb
_______________________________________________
Discuss mailing list
[email protected]
https://lists.lopsa.org/cgi-bin/mailman/listinfo/discuss
This list provided by the League of Professional System Administrators
 http://lopsa.org/

Reply via email to