Re: SQL Server

2009/11/6 Bob McConnell <rmcconne@lightlink.com>:
> bob.vanslobig@att.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@postgresql.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/