Hello newsgroup,

We are hosting (and developing) an asp.net application on a dedicated
server, as database MS SQL Server Express 2005 is used.

We are currently happy with Express 2005, but, since the project will
grow, the 4 GB limit on the database will be a problem. This project
is currently too small to afford a pricey MS SQL 2005 standard edition
Server, so we are thinking about a migration to MySQL or PostgreSQL.

Now, MySQL is much more popular, but I am more symphatic towards
PostgreSQL, since stored procedures, Views, Triggers etc. are built in
since years into PostgreSQL, and are not an "afterthought" like in
MySQL.

But, I am still unsure what to take... I am the guy responsible for
the DB.. and to be honest, I don't have much experience with both,
MySQL and Postgre.

So, does anyone runs a asp.net site with postgreSQL here? How are your
experiences with it? Any problems? How is the performance on windows
server 2003?

I had to troubleshoot a postgresql issue with a bomain key. That turned out 
to be several nights of grief. There's very little documentation and help 
for these sorts of issues. MySql on the other hand is a bit more mature in 
documentation and forum help.

-- 
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET - MS Press
Professional VSTO 2005 - Wrox/Wiley
OWC Black Book www.lulu.com/owc

 wrote in message 
news:1186911002.647764.35490@q75g2000hsh.googlegroups.com...

> Hello newsgroup,
>
> We are hosting (and developing) an asp.net application on a dedicated
> server, as database MS SQL Server Express 2005 is used.
>
> We are currently happy with Express 2005, but, since the project will
> grow, the 4 GB limit on the database will be a problem. This project
> is currently too small to afford a pricey MS SQL 2005 standard edition
> Server, so we are thinking about a migration to MySQL or PostgreSQL.
>
> Now, MySQL is much more popular, but I am more symphatic towards
> PostgreSQL, since stored procedures, Views, Triggers etc. are built in
> since years into PostgreSQL, and are not an "afterthought" like in
> MySQL.
>
> But, I am still unsure what to take... I am the guy responsible for
> the DB.. and to be honest, I don't have much experience with both,
> MySQL and Postgre.
>
> So, does anyone runs a asp.net site with postgreSQL here? How are your
> experiences with it? Any problems? How is the performance on windows
> server 2003?
>