Skip site navigation (1) Skip section navigation (2)

Re: SQL Server

From: Brian Modra <brian(at)zwartberg(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: SQL Server
Date: 2009-11-07 08:36:12
Message-ID: 5a9699850911070036t75600382lbc799db7f143d7ff@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
2009/11/6 Bob McConnell <rmcconne(at)lightlink(dot)com>:
> bob(dot)vanslobig(at)att(dot)net wrote:
>>
>> At the same time, I am looking at reducing cost and thoughtabout
>> switching from MS SQL to MySQL.  Ialso thought of adding some kind of
>> GUI front-end in order to use lesstechnical people to process data
>> requests. In talking with a customer support person at a company that
>> developsfront-ends, he suggested looking into PostgreSQL and that is
>> why I am here.
>>
>> I did not see references to anyone moving from an MS SQLenvironment
>> to PostgreSQL and was curious if anyone has had experience doingthat?
>> Also, are there any suggestionsfor front-ends?  I need something that
>> cangenerate SQL commands but also allow a passthrough if someone
>> needed to writetheir own.
>
> Take a close look at PostgreSQL before you switch. MySQL is fine for small
> projects and private web sites, but for anything serious you will need the
> Enterprise license and support. The future of those is in serious doubt
> right now given the state of Sun, which currently owns it, and the
> possibility the European Competition Committee may prevent Oracle from
> rescuing them.

I would like to re-inforce what Bob has said here:
PostgreSQL is definitely better for large projects, and there are no
licensing issues.
There are great "extras" also, like PostGIS.

> If you do a Google Search on moving from MySQL to Postgres, you will find a
> lot of sites with information on that conversion. There was one project at
> work that did it several years ago, when MySQL AB switched to the per server
> license fees. They found Postgres easier to use and more stable. We now have
> three major products deployed using Pg and two more on the drawing board.
>
> PgAdmin III is the best admin front end. It is available on most platforms,
> including MS-Windows. I use OpenOffice.Base as an application front end.
>
> Good luck,
>
> Bob McConnell
> N2SPP
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>



-- 
Brian Modra   Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/

In response to

pgsql-novice by date

Next:From: Jasen BettsDate: 2009-11-07 12:21:02
Subject: Re: Table design for basic user management
Previous:From: Michael LushDate: 2009-11-06 16:44:32
Subject: Re: how does psql know where to go?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group